Questions

Hello, all,I am using Oracle 11g, do not have admin access or authority to make any changes to configuration, and would like to have case-insensitive searches of varchar2 and CLOB columns.I have tried putting the following before my SELECT query:ALTER SESSION SET NLS_SORT = BINARY_CI;ALTER SESSION SET NLS_COMP = LINGUISTIC;This results in an error message: ORA-00922; missing or invalid option.Also, the method I'm using for searching the CLOB is case-sensitive:SELECT * /* I don't use * in production, I'm using it here for brevity */FROM table1WHERE dbms_lob.instr(columnA,'searchWord') >= 1Any advice appreciated.V/r,^ _ ^

Recently I got a VPS server and I'm running Coldfusion, the website was running fine until it got more and more traffic and I started to encounter 'OutOfMemory' exceptions.I thought simply to rise the memory of the VPS server, but this didn't help.After doing some Google searches I found a setting in de CF Admin settings to set the JVM Heap memory. It was on the standard: Max Heap size 512MB and Min Heap size was empty. After playing around a bit I have now set it to Min 50MB and Max 200MB, good things is that I'm not getting the 'OutOfMemory' exceptions anymore. So far so good!But with about 50 active visitors on the website, the website starts to get slow. The CPU usage is only about 8% (Windows Taskmanager), also the taskmanager show only about 30% of the 3GB RAM in use.So I'm thinking that my values could be tweaked to use more of the RAM. Honestly I don't understand these JVM Memory heap settings, so I have no clue what is a good setting for me.I found a CF script that displays th

Installed the beta, and had it set up to use the Apache server that is included in OS X on my laptop.  And, I'm using the 8500 port.  I have all the files in /Library/WebServer/Documents folder. In Httpd.conf I have "DocumentRoot "/Library/WebServer/Documents"".  When I try to run 127.0.0.1/twitterstuff/testing.cfm I get:Error Occurred While Processing RequestFile not found: /twitterstuff/testing.cfmHowever, when I move this directory into /Applications/ColdFusion2018/cfusion/wwwroot/CFIDE, this file runs.  This isn't an ideal answer to the problem, though.  Is this a bug, or some configuration I need to make somewhere else?

One of the features promised for this release was a container version, but no sign of it yet.Is this still coming?

I am in the process of purchasing Cf2016 standard edition and I wanted to know whether my purchase of CF2016 would make me eligible for upgrade to 2018 when its released to market?

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