ColdFusion

ColdFusion version:9.0.1 standardserver OS: Windows 2008 R2webserver: Apache 2.2.19These forums worked great once before, hopefully we can go 2 / 2.I am opening a workbook, adding a header row to all the tabs, and then saving the workbook back to the directory as a different file.  My problem is that the workbook can have any various combination of tabs in it, and I don't know what ones unless I open the workbook itself.  Is there a way to read either the name of every tab in the workbook and then loop through those names (or the amount of sheets would work also).Code is here:<!--- All possible prefixes that could be in the sheet name ---><cfset prefixList = "10-00, 10-10, 10-20, 10-30, 10-40, 10-50"><!--- All possible status that could be in the sheet name ---><cfset statusList = "In progress,Closed"><cfloop list="#statusList#" index="si">    <cfloop list="#prefixList#" index="pi">        &

Hi, I'm having some errors popping up on a site, in which users have to fill out a form where there is an input field for specifying quantity. If someone puts in 1,500 then the form submits without problems, because the validate="integer" passes. (Commas supposedly are allowed in integers). However, the database insert query fails, because <cfqueryparam cfsqltype="integer"...> doesn't pass. This seems quite inconsistent... why would CF allow integers with commas in form validation, but not allow integers with commas in the cfsqltype parameter? Does anyone know how I can work-around this? Thanks, Margaret

Hello,Since Java 10 is current release will release to manufacture CF2018 support JDK10 rather than JDK9 as is installed with Beta?Of note I see beta CF2018 does funtion with JDK10 with some minor work. Details:CFadmin > System Information > Server DetailsServer Product ColdFusionVersion 2018,0,0,308164 JVM DetailsJava Version 10  Java Vendor Oracle Corporation  Java Home C:\Program Files\Java\jdk-10   Regards, Carl.

Hello,Will release CF2018 offer SQL 2017 as supported database?Refer:https://coldfusion.adobe.com/files/2018/04/Public_Beta_Support-Matrix.pdf Regards, Carl.

I get an error generating my PDF whenever someone's name has a special character's in their name such as accents and diacritics.Is this a bug or how do I properly set the charset for the <cfhtmltopdf> tag. I didn't have this issue with Coldfusion 9 and cfdocument. Any help in this regard would be much appreciated.version: Coldfusion 11 Update 3 on Windows Server 2008 R2 on IIS 7.5SEE STACK TRACE BELOWcoldfusion.document.webkit.PDFgErrorHandler$ServiceManagerConversionException: Error occurred while generating PDF. at coldfusion.document.webkit.PDFgErrorHandler.handleConversionError(PDFgErrorHandler.java:188) at coldfusion.document.webkit.HttpPDFRequestHandler.requestPDFGeneration(HttpPDFRequestHandler.java:113) at coldfusion.tagext.lang.HtmlToPdfTag.processPDFgRequest(HtmlToPdfTag.java:1331) at coldfusion.tagext.lang.HtmlToPdfTag.handlePDFgConversionRequest(HtmlToPdfTag.java:1466) at coldfusion.tagext.lang.HtmlToPdfTag.convertToPDF(HtmlToPdfTag.java:1413) at coldfusion.tagext.lan

We have a strange issue whereby the CF 2016 standard license of some of our servers changes to a developer license.  I cant replicate the issue, and have no idea why it would happen.  Has anyone seen this issue before or have an idea of what the cause would be? When we do a build, some of the NEO files are copied over to retain settings like SQL connection strings.  Could this be causing the issue?Thanks in advance for your help.

Just upgraded to CF2016 on a Windows 2016 server. Using CFHTMLTOPDF for the first time and I can't get any image to convert. The PDF created just has a "?" where the image should be. What am I missing? It worked fine before with CFDOCUMENT.<cfhtmltopdf><img src="logo.jpg"></cfhtmltopdf>Thanks in advance for any help!Gary

Hi, I signed up for the online coldfusion tutorial course but what I found that the training CF course starting from lecture 8 - hdStreet Database through the default local connection is missing. So there is no way for me to keep going to learn the rest of material. If possible, can you contact the instructor  Damien Bruyndonckx to upload that DB of hdStreet tables through RDS Dataview? Thanks! Ken

We are experiencing a strange issue with ColdFusion/IIS, which can’t crack and would need help with. Our set up is 2x Windows 2008 R2 Servers, ColdFusion 9.01274733 Standard, IIS 7.5. The CF isn’t installed in high availability mode, instead we sync WWW directories across two servers, have identical CF and IIS settings and there is Barracuda Load Balancer in front of the two servers diverting the load. The issue is that CF/IIS stops working from time to time and the server isn’t loading any cfm nor html files. It can happen once a day or 10 times a day. The “freeze” can lasts from 10 seconds to 3 minutes and eventually fixes itself. IIS or CF restart also fixes it. During the outage the web browser would just be waiting and trying  to load the page (or html file) without any error. When the server is back up again the page would eventually load fine. There are no errors on Windows event viewer and CF only shows time out error. This is affecting only one of the websites on IIS, whi

Hi, I was wondering if anyone knows when/if there would be support in ColdFusion for nosql datasources such as Mongo, Cassandra, etc.  I remember at a CF Summit a few years ago there was a class about it, but I don't see anything that would make it easy to configure a datasource within the administrator. It appears anything done would have to be via code outside of the administrator.  I've tested with CF 2018 and still don't see any native support for nosql datasources.

Hi,Currently standing up ColdFusion 2016 and SQL Server 2016.In the Cold Fusion Admin, added the following in the Connection String (came from the CF11 encryption)EncryptionMethod=SSL; ValidateServerCertificate=false;Port 1433 has a certificate installed.Below is the certificate information:Version: V3Signature Algorithm: sha256RSaSignature hash algorithm: sha256Thumbprint algorithm: sha 1The following error message appears when trying to check the connection between the ColdFusion2016 and the SQL Server database.java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]SSL handshake failed: Unsupported curveId: 29The root cause was that: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]SSL handshake failed: Unsupported curveId: 29Thanks,Mike

I'm facing javax.naming.NameNotFoundException while trying to use a preconfigured JNDI datasource name in SOLR data import request handler. Here is the list of steps I took:1. Modified $JETTY_HOME/start.ini file to include "plus" into OPTIONS and add etc/jetty-plus.xml;2. Added etc/jetty-plus.xml file that includes the following:        <Configure id="Server" class="org.eclipse.jetty.server.Server">           <Call class="org.eclipse.jetty.webapp.Configuration$ClassList" name="setServerDefault">            <Arg><Ref refid="Server" /></Arg>            <Call name="addAfter">              <Arg name="afterClass">org.eclipse.jetty.webapp.FragmentConfiguration</Arg>    &nbsp

Hi,I'm installing CF10 on CentOS 6. The install works just fine but when I start the CF server and try to browse the ADMIN page I get this error: HTTP Status 500 - java.lang.NullPointerException. I have tried: compiling a custom Apache connector, installing the mandatory CF10 updates, installing to the latest version of CF10. However, everything I have done, I still get the same error. In the ColdFusion out log there is this:Apr 16, 2018 10:50:35 AM Error [pool-2-thread-1] - Unable to initialise Client Storage service: coldfusion.server.ServiceFactory$ServiceNotAvai$Apr 16, 2018 10:50:35 AM Information [pool-2-thread-1] - Starting xmlrpc...Apr 16, 2018 10:50:35 AM Information [pool-2-thread-1] - Starting jaxrs...Apr 16, 2018 10:50:35 AM Information [pool-2-thread-1] - Starting graphing...Apr 16, 2018 10:50:35 AM Error [pool-2-thread-1] - Unable to initialise Graphing service: java.lang.ExceptionInInitializerErrorApr 16, 2018 10:50:35 AM Information [pool-2-thread-1] - Starting solr...A

We are pleased to announce the availability of public beta for Adobe ColdFusion (2018 release) and Adobe ColdFusion Builder (2018 release).The public beta is available on the ColdFusion community portal. If you are new to community portal, watch the video on the portal or read the getting started document for the ColdFusion community portal. Get rewarded for your contribution! Each engagement earns you points.Click on the “Adobe ColdFusion (2018 release) public beta” banner on the right hand side of the community portal to enter the public beta release area for ColdFusion (2018 release). You will find all the installers, links to documentation, link to report bugs and link to initiate/follow all the discussions on public beta.As always, we appreciate every contribution you make and provide feedback on this most awaited release of ColdFusion. If there is one thing that ColdFusion (2018 release) is about, then it is about performance. It is not just the runtime performance improvements.

So, we've just moved CF11 to our production servers.  Among the many weird issues we've encountered is IE refusing to keep cookies set using CFCOOKIE.Keep in mind this is only a problem in IE.  Seems to be all versions: 6-11.For instance, a user loads Page A where this code resides:<cfcookie name="myCookie"  value="#myVar#" expires="NEVER">At the end of the page I dump out:<cfdump var="#isDefined(cookie.myCookie)#">Result: YESI then click a link and load a Page B (same domain) and dump out:<cfdump var="#isDefined(cookie.myCookie)#">Result: NOWhy is IE dropping this cookie?  All other browsers keep it.Exception: if I add my site to IE's Trusted Site list then it will keep the cookie.  WTF?Also, the particular CFCookie code we're using has been in place and working for YEARS.  Since CF7 at least.  It has also been working on our testing server running CF11 for months.  It only stopped working when moved to our production servers.T

We are testing our cf code which all works fine on a CF9 Windows Server 2008 machine but we are going to migrate to a CF11 Windows 2012 R2 machine. We have a test machine setup and all the code moved over and so far the cfm pages seem to work fine as well as the Application.cfc page but when we call a cfc via AJAX or we visit the cfc methods directly we get a 500.0 error Application could not be found.Anybody else run into this?

When trying to edit report builder files that were created on an older version of the Coldfusion Report Builder in the newest version, after saving the file will throw the error:Invalid construct.A script statement must end with ";"Just opening and saving the file will cause the error. Is there any solution to be able to edit the older files in the new Report Builder?

Hi,I recently set up a Filewatcher gateway instance that watches for a file, then based on the file name will perform actions, including deleting the file, in the ONADD function in the associated CFC.This has worked perfectly for a couple of weeks, however, I noticed a few files in the directory and upon investigation have found it has stopped working.The error code I'm getting in the EVENTGATEWAY log is:"Error","Thread-20","04/13/18","12:55:41",,"Error invoking CFC for gateway hrDashboardReportsWatcher: Variable FORM is undefined.  {GATEWAYTYPE={FileWatcher},ORIGINATORID={},CFCMETHOD={onAdd},DATA={{LASTMODIFIED={Fri Apr 13 11:38:31 BST 2018},FILENAME={d:\inetpub\wwwroot\hrdashboard\reportswatcher\114.txt},TYPE={ADD}}},CFCPATH={d:\inetpub\wwwroot\hrdashboard\reportsCode\watchHRDashboardReport.cfc},GATEWAYID={hrDashboardReportsWatcher}}. "Which seems to indicate that the error is around a variable called form.  But that's the issue.  There is NO variable "form" in any of

Hi,We are in the process of upgrading from coldfusion 9 to 2016 and we see an overall decrease of performance for coldfusion 2016. As far as we read coldfusion 2016 should be faster then coldfusion 9but this is not the case. Below a test script that can be run to see the difference in performance:<!--- Machine info ---><cfset runtime = createObject("java", "java.lang.System")><cfset props = runtime.getProperties()><cfset env = runtime.getenv()><Cfoutput>java.version: #props["java.version"]#<br>java.vm.name: #props["java.vm.name"]#<br>os.name: #props["os.name"]#<br>PROCESSOR_IDENTIFIER: #env["PROCESSOR_IDENTIFIER"]#<br>PROCESSOR_ARCHITECTURE: #env["PROCESSOR_ARCHITECTURE"]#<br>NUMBER_OF_PROCESSORS: #env["NUMBER_OF_PROCESSORS"]#<br><Br></Cfoutput><!--- Create a query ---><cfset myQuery = QueryNew("Name, Time, Advanced", "VarChar, Time, Bit")><cfset testQuery = QueryNew("ColumnA,ColumnB,ColumnC,Co

Based on the following article ( ColdFusion Help | Administer ColdFusion security ), I set the allowed IP as it stated for all 10.x.x.x addresses.To add IP addresses that must be allowed access:Go to Security > Allowed IP Addresses > Add/Remove IP Addresses which will have Administrator access.In the IP Address text box, specify the IP addresses.Click Add.Repeat the procedures to add more IP addresses.Regular expressions are supported. That is, if you specify 10...*, all IP addresses starting with 10. are allowed access.That is, I literally added 10...* as the allowed IPs, and wouldn't you know I locked out getting to CF admin from anywhere. I have tried from several 10.x.x.x addresses, and from the server itself (also 10.x.x.x) and for grins from a non 10.x.x.x address.I get either:Diagnostic Information:You tried to access the ColdFusion Administrator or other internal components from a disallowed IP address (70.x.x.x). These ColdFusion components can only be accessed from loca

Hi all, I need to prevent all scheduled tasks across multiple servers from running. I thought I could just pause the job from within the administrator however it appears the jobs continue to run (enabled scheduled task logging so can see entries within then scheduler.log).Am I misinterpreting the pause feature within the administrator UI?The jobs are straight forward, just daily jobs usually running every hour, configured to run in indefinitely just calling a URL. No fancy cluster configuration.I'm a little naive with managing scheduled tasks within CF so if anybody has any ideas on the best method to easily disable a job I would love to hear your thoughts. I'm trying to avoid having to manually edit start times of jobs which, given the amount we have and the uncertainly around when we need to start them will be a PITA.Servers are running CF2016 update 5 on RHEL7.4 if that makes any difference.In advance, thanks for you help.

We have switched from CF11 32 bit to CF11 64 bit and now for some reason cfreport does not work anymore.  We have a number of reports we have used in CF11 32 bit with no problems.  With 64 bit we get no response, no errors, just browser spinning waiting for a reply.  Is there something that we need to do to make this work?  It is imperitive we get this working as our business relies on it.  Please let me know as soon as possible what is needed to be done to make this work!I am eternally grateful for your assistance on this matter!Thank You!

I was looking at a comparision for ColdFusion Enterprise (2016 Release) and ColdFusion Standard (2016 Release) (see Buying guide | Adobe ColdFusion Family ) . The feature "Server monitoring dashboard" is available on both versions. To what feature(s) is this option referring??.The "Server Monitor" option is not available on my 2016 Standard version of coldfusion (only on the enterprise version). So what do they mean by "server monitoring dashboard"?

I am using an AWS instance behind a load balancer with NAT. It has its advantages, but one of its disadvantages is the remote_addr coming through is the remote_addr of the ELB.http://leaguemanager.playerspace.com/test.cfmWhat I'm trying to do is trick or configure the CF10 Administrator > Debugging and Logging > Enabled Request Debugging Output to use the x-forwarded-for as opposed to the remote_addr so I can use server debugging without that information being made visible to the public.Is this possible by, say, modifying a file somewhere, to have the IP addresses set in Debugging and Logging > Debugging IP Addresses to be matched with the true client's personal IP (x-forwarded-for)? JS

Is it possible to control when ColdFusion outputs the debug information at the bottom of the page by something other than IP?  We moved our servers into AWS Cloud and they are going through load balancer, so all the IPs look the same to the server.  Plus we have folks working remotely, so their IPs keep changing.  We use OneLogin for authentication, and we can have a Developer role in there.  So we'd like to find a way to display all the debug at the bottom of the page only if a Developer is logged in.