Questions

HelloI've been installing ColdFusion 2016 on a Windows 2012 R2 server with IIS 8.5 and as part of the installation i selected for CF to configure all IIS websites. I probably shouldn't of done this as i had no sites added in IIS apart from the normal 'default website'I setup my website and then launch wsconfig.exe to configure IIS for my new website but according to wsconfig, IIS isn't configured as it is blank in the list of configured sites but then if you hit 'Add', am i presented with the error 'All the IIS sites are already configured by some other version of ColdFusion'I've been googling for some time and I've tried cf11 guides to manually remove the connector as it's not displaying one for me but the items to be manually removed don't exist. For instance there is no numbered folder in C:\ColdFusion2016\config\wsconfig. There is only a dll and log file. I've been through all of the sites within IIS to manually remove the various CF isapi filters, isapi and cgi restrictions, mime

Hello, all,What is the best way to preserve line breaks from a <textarea> when inserting into an Oracle varchar2(4000) column?I'm creating a comments section for a blog, and want to keep the input as the user entered it.This is being processed in ColdFusion 10/11.V/r,^ _ ^CORRECTION:  Apparently, the line breaks are being kept, just fine, when I "view source" the page.  So, this is a formatting-after-get issue, not an Oracle issue.  Nevermind. 

Hello Community.Recently my team tackled a POC using CF2016 on RHEL 7 connecting to SQL Server 2016 running on Server 2016 and ran into a curious problem.The problem was this nasty error when setting up the Macromedia JDBC DSNs pointed at SQL Server 2016 with EncryptionMethod=SSL in the connection string :Connection verification failed for data source: MyTestDatabaseDSNjava.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: 29Our server Specs:RHEL 7CF2016 2016.0.05.303689Java 1.8.0_144Tomcat 8.5.11.0Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy 8 filesThe DSNs worked fine without SSL enabled.Has anyone else experienced this?  It sure seems like a bug in the shipped JDBC driver.Our work around currently is to use the Microsoft JDBC 6.2 driver

Hello, all,I'm trying to migrate data from an old schema to a new schema via ColdFusion, and I'm getting an error message.<cfquery name="old_data" datasource="#application.dsn_old#">SELECT colA, colB, colCFROM old_table</cfquery><cfquery name="new_data" datasource="#application.dsn_new#">INSERT ALL     <cfoutput query="old_data">          into new_table(aCol, bCol, cCol)               values(colA, colB, colC)     </cfoutput>SELECT * from dual;</cfquery>904: ORA-00904: "colC": Invalid identifierIf I CFDUMP the first query, all the data is there.  Why does Oracle think that colC is invalid?V/r,^ _ ^

Today I have installed the ColdFusion 2018 public beta and replaced the previous beta release with it. After installation the ColdBox 5 framework was broken, CF threw an error when trying to set a variable:var appSettings = getApplicationMetadata();For whatever reason dumping getApplicationMetadata() worked fine. However it only worked once - trying to dump it twice on the same page or assigning it to a variable resulted in an error.Similar errors have been reported on the bug base (Tracker , Tracker)​ but are marked as fixed​ .After verifying the bug I uninstalled the current public beta and replaced the installation with the previous version (from the closed beta) and it worked fine again. The current and previous beta release was reinstalled twice to verify that this bug only occurs with the latest beta (same code/same server configuration).How to reproduce: Install a ColdBox 5 application on the current beta release server and it should break right away.Regards,Philipp

We have Coldfusion 10 configured on an IIS web site using a GoDaddy provided SSL certificate.  When we try to access a web service we receive a 500 error from the server.  When we look at the application log we see the following record:"Error","ajp-bio-8012-exec-2","06/17/13","14:20:19","SmartPriceAdmin","The web service operation caused an invocation exception.The root cause was that: javax.servlet.ServletException: https is forbidden The specific sequence of files included or processed is: C:\WebSites\Something\SMARTPriceServices.cfc'' "C:\WebSites\Something\SMARTPriceServices.cfc is the location on the server where the actual web service file resides.I'm not the sites developer but I'm trying to aid him in finding the issue.  We've added the sites SSL certificate through the SSL Certificate Management feature of the Administrator and restarted the Coldfusion 10 Appllication Service but it had no effect.  Any help would be very appreciated.

(Copied from the Prerelease forum as Adobe did not answer it there)Hi Adobe folks,I am in the process of working on a guide to CF containerization deployment from the perspective of somebody who has never worked with containers before. It is intended for an audience that is stuck in Ye Olde Days of running an installer on a Windows machine and not thinking too hard about what is happening (this is easy, because it described us pretty well until not that long ago).I am making a concerted effort to be agnostic and provide examples and support for as many CF engines as I can. This is made difficult on the Adobe side by some licensing and standard v. enterprise considerations , some of which I know have come up and been addressed to some extent but others I'm not sure about.At the moment, the draft version of our guide covers ACF11, 2016, and the forthcoming 2018 (standard and enterprise), along with Lucee 5+. I think it'd be best for all concerned if it stays that way -- the more versions

When we initiate a Nessus scan on our server, the ColdFusion Application Server consumes 80-90% of the CPU and continues to do so even after the scan is terminated.  Only restarting the service brings the usage back to normal, but starting the scan repeats the high CPU usage.  No errors are thrown, just high CPU.IIS 7, Windows Server 2008 R2 SP1, ColdFusion 2016.0.04.302561Any ideas where to start troubleshooting?

Are there any recommendations on hardware vs. software clustering for high availability and performance?  I.e., running 2+ servers in an Enterprise cluster vs putting those servers behind an F5 appliance for load balancing and failover.

hello coldfusion community,I refer to a previous post from 2016 and would like to continue on this example. It's about a product list with up to 10 items and to add, delete and edit a shopping cart. In my version everything works very well except if I want to change the field in the shopping cart with the amount (Quantity).  I want the user to be able to change the value of quantity in the shopping cart. Somehow I do not get to the point. Does anyone have a suggestion or an idea for me? Thank you. Marcel M.previous post from May 18, 2016: Extremely Simple Shopping Cart products.cfm<!doctype html><html><head><meta charset="UTF-8"><title>Shop - Productlist</title></head><body><h1>Welcome to the Shop</h1><p> </p><form action="ShoppingCart.cfm" method="post"><p>Article-1, property 111, $45.00</p><input type="hidden" name="productID" value="1" /><input type="hidden" name="productName" val

Hello,I've tried many options and searched for many solutions but I just can't seem to get this to work. It's probably something minor that I'm missing.I have a menu that is in a cfinclude file, the menu has the following code to trigger an active state dynamically:<a href="../index.cfm" class="#iIF( thispage IS "index.cfm", DE( "nav-item nav-link px-3 active" ), DE( "nav-item nav-link px-3" ))#">Home</a>When I call this menu from another page with <cfinclude> it works fine using the following code at the top of the page:<cfset variables.thispage = GetFileFromPath(GetCurrentTemplatePath())/>The template path would be 'index.cfm' and the active state would be triggered if I am on that page.However, I have a template page that contains the header and footer of my site named front.cfmWithin the header portion of front.cfm, I call the menu with <cfinclude>. It works fine here.In my index page, the template is called and here is where it breaks, I keep getting

Hi Adobe,Where is the APIM 2018 download link?Thanks!,-Aaron

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