ColdFusion

We have been using the result structure from CFQUERY for years to retrieve an inserted ID, but it started to fail after applying update 2021/11 recently. It would appear that we now need to pull the inserted ID out of another structure entirely. I created a simple test scenario below and dumped out both the query and result structures - note that GENERATEDKEY is no longer in the result structure: <cfquery name="myquery" datasource="#ds#" result="myresult">    insert into ejtest(testfield) values('test')</cfquery>  The test table has both an identity field and PK set on that field. It produces the same result whether I have a PK set or not, however. The CF documentation for CFQUERY also does not mention this: cfquery (adobe.com) Thoughts? Thanks,Eric Server DetailsServer Product ColdFusion 2021Version 2021,0,11,330247Edition StandardOperating System Windows Server 2019OS Version 10.0Update Level [CF Path]/cfusion/lib/updates/

Updating the last server in our company and get an error that I do not get on the two other environments.we are applying update 3 to CF 2021 - developers are pointing at server issue as works in other two enviroemts - I attached a picture of what the page should look like - seems to pull up some grid viewany help always apprective Jan 22, 2022 10:48:04 PM org.apache.catalina.core.StandardWrapperValve invokeSEVERE: Servlet.service() for servlet [CfmServlet] in context with path [] threw exception [ROO. CAUSE:java.lang.IndexOutOfBoundsExceptionat java.base/sun.nio.cs.StreamEncoder.write(StreamEncoder.java:121)at java.base/java.io.OutputStreamWriter.write(OutputStreamWriter.java:211)at java.base/java.io.PrintWriter.write(PrintWriter.java:507)at coldfusion.runtime.CharBuffer.writeTo(CharBuffer.java:154)at coldfusion.runtime.NeoJspWriter.writeOutput(NeoJspWriter.java:281)at coldfusion.runtime.NeoJspWriter.flush(NeoJspWriter.java:374)at coldfusion.runtime.NeoPageContext.flushOutput(NeoP

I am not able to run my project in docker container after upgrading to MacOS Sonoma in Macbook M1 Pro. First I thought I have some issue in my Dockerfile. So tried with a default blank command  docker run -dt -p 8500:8500 -e acceptEULA=YES -e password=ColdFusion123 -e enableSecureProfile=true adobecoldfusion/coldfusion2021:latest Still not able to run ColdFusion, so attached some log files. Please help me out.

As of December 2, 2022, Tenable security scans are once again flagging ColdFusion with a Critical vulnerability, identifying the latest CF Update 15 (that we applied two weeks ago).  States we had previously mitigated this issue, but is back.   Has anyone else seen a vulnerability scan (of any level) identifying cf-logging,jar   as using v. 1.2.15.  (A logging library running on the remote host is no longer supported.). Identifies:[drive]:\ColdFusion2018\[cfinstance]\hf-updates\hf-2018-00015-330106\backup\lib\cf-logging.jar I can only find posts about this vulnerability in posts from Jan 2022, where Adobe says they checked and they "weren't vulnerable" I'm concerned because it is flagged as Critical and security teams will expect this to be mitigated.   

Help, Scheduller.cfm corrupted

Document update history: 10/10/2023: Added Docker Hub and ECR locations. 10/10/2023: Refreshed the Server ZIP and GUI installers, Lockdown installer, and Add-on installer for ColdFusion (2023 release). Head over to ColdFusion downloads to download the installers.   We are pleased to announce the availability of ColdFusion (2023 release) Update 5 and ColdFusion (2021 release) Update 11 today!   Where do I download the updates from ColdFusion (2023 updates) ColdFusion (2021 updates)   What's new and changed in the updates Both the updates include bug fixes and enhancements in Administrator, Installer, Migration, Package manager, Database, and other areas. The update contains upgrades to Tomcat (v9.0.78) and other libraries, such as jackson-databind, Netty, etc. Note that this update is cumulative and includes fixes from the previous updates.  The updates include package install enhancements, Admin APIs for activation requests, new attributes for Exchange tags

Looking for some sort of integration (maybe third party) that allows for building out JS/HTML dashboards using Coldfusion.Leadership has asked that I create dashboards with graphical interface, such as pie charts, etc. These dashboards need to be acceessible via the CF web application that warehouses our client data. Ideally, the dashboards will also feature links wherein users can drill into more detail if desired.The CF web app uses Azure SQL db and runs on Windows.   

I have write a code in body_supportlog.cfm as below, able to download excel, but it show "The request resource are not available. It suppose link with eclipse's parameter from date and to date. The file path refer to  C:\ColdFusion11\cfusion\runtime\webapps\BIRT\test1.rptdesign<html> <head> <!--- Security Check ---> <cfset mid="100000"> <cfset fid="121212121"> <cfinclude template="#rootdir#checkaccess.cfm"> <cfoutput> <TITLE><cfinclude template="#rootdir#pageTitle.cfm"></TITLE> <LINK REL="STYLESHEET" HREF="#css#iesync2.css" TYPE="text/css"> <script language="javascript" src="#jslib#mainframe.js" type=text/javascript></script> <script language="javascript" src="#jslib#iesync2.js" type=text/javascript></script> </cfoutput> <script language="JavaScript"> function urlencode(str) { str = (str+'').toString(); return encodeURIComponent(str).replace(/!/g,

Hello I am new to Cold Fusion,        Well I am new to Cold Fusion 2023. The last Cold Fusion version I have used is CF 10.We have a web site that I would like to migrate to Cold Fusion 2023 and it is basically a document search web site. I need to know if the 2023 version has the same functionality for collections and search as in the past. I know that Adobe has replaced Verity with SOLR. Any major differences in setuping the collections, indexing and searching them?      Is there is anyway I can move the current web site to testing/development environment to do the testing until we decide on investing in the new Cold Fusion Server? The testing environment should also have SQL server. Thank you so much!

Hello - We're running ColdFusion Standard 2018.  Early yesterday morning the service stopped, and we have not been able to start it.  Is anyone familiar with these errors?  Thank you. Apr 30, 2023 2:02:28 AM org.apache.catalina.core.StandardServer awaitINFO: A valid shutdown command was received via the shutdown port. Stopping the Server instance.Apr 30, 2023 2:02:28 AM org.apache.coyote.AbstractProtocol pauseINFO: Pausing ProtocolHandler ["http-nio-8500"]Apr 30, 2023 2:02:28 AM org.apache.coyote.AbstractProtocol pauseINFO: Pausing ProtocolHandler ["ajp-nio-127.0.0.1-8018"]Apr 30, 2023 2:02:28 AM org.apache.catalina.core.StandardService stopInternalINFO: Stopping service [Catalina]Apr 30, 2023 2:02:34 AM org.apache.catalina.loader.WebappClassLoaderBase checkThreadLocalMapForLeaksSEVERE: The web application [ROOT] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@480d45d0]) and a value of type [org.apache.xerces.parsers.SAXP

I am submitting values to MS SQL where I set the value in the CFQUERY usingdatabasefield = <cfqueryparam value="#TheValueHere#" cfsqltype="CF_SQL_DECIMAL"> The database is set to DECIMAL(8,2) If I manually type in a value into the database such as 1.5 it works fineIf I use the cfqueryparam above, and post 1.5, it rounds to 2, so that's not right I removed the cfqueryparam, and again submitted the valkue of 1.5 in the variable, and it worked fine, I end up with 1.5 in the databasedatabasefield = #TheValueHere# Would anybody have any idea why using CFQUERYPARAM DECIMAL is causing it to round? 

I am executing a stored procedure like this. <cfstoredproc procedure="GetAction" datasource="test_DSN"> <cfprocparam cfsqltype="CF_SQL_INTEGER" dbvarname="actionId" type="in" value="1"> <cfprocresult name="actions" resultset="1" > </cfstoredproc> and my stored procedure in oracle is, create or replace function GetAction(actionId IN ACTION.ID%TYPE) RETURN ACTION%ROWTYPE IS actions ACTION%ROWTYPE; begin select * INTO actions FROM ACTION WHERE ID = actionId; RETURN actions; end GetAction; then I get the error message like, ORA-01008: not all variables bound Please help me on this. Thanx

Hello Adobe Support and Community, I am currently in the process of migrating and reconfiguring systems that utilize ColdFusion 2016. For this purpose, I require access to the ColdFusion 2016 installation files. Understanding that Adobe primarily promotes the latest versions of its software, our current infrastructure and applications are specifically tied to ColdFusion 2016, making it essential to obtain this particular version. Details of the ColdFusion 2016 setup:Edition: EnterpriseVersion: 2016.0.0.298074Operating System: Windows Server 2012 R2 I would greatly appreciate it if you could provide a direct download link or guidance on obtaining the installation files for ColdFusion 2016. Furthermore, within the "About" section in the ColdFusion Administrator, I can view the current serial number. I wish to know if it's possible to directly use this serial number on the new server after installing ColdFusion 2016? Are there any specific steps or considerations

I'm hoping I'm missing something obvious here and this will be a simple fix. I'm working with the LinkedIn API, specifically creating a share. I've got all the authentication working and have successfully created plain text and article shares.  However, in order to include an image with a share I'm hitting a snag. According to the documentation, after making an initial call to obtain the uploadUrl, you then upload the file.  Specifically:  "To upload your image, send a POST request to the uploadUrl with your image included as a binary file." It gives this cURL example: curl -i --upload-file /Users/peter/Desktop/superneatimage.png --header "Authorization: Bearer redacted" 'https://api.linkedin.com/mediaUpload/blahblahblah'  I have tried numerous ways to replicate this call with CFHTTP, but LinkedIn always returns a 400 Bad Request response.  No other info. Here's my latest try: <cfhttp url="#uploadURL#" method="pos

We have a stored procedure in Oracle which has an insert statement into global temporary table. But , calling this stored procedure from ColdFusion application throw error saying "Object no longer exists".  Procedure definition looks like below, INSERT INTO DSB.TT_SP_bill_getBillInfo_Device SELECT DISTINCT 100, 'test', 'test', 'test', 1,'test','test', 10,1,0,1, 0,1,0 from dual; Apprecite your help debug the error.

Given the CF2018 PM is updated to HF 5, does anyone know the latest tested Java (JRE) version for the toolkit?  Currently, it is running 11.0.1, though interested if it can/will run 11.0.20, or if not, the latest version currently tested on the CF2018 PM toolkit.

Hi, I have a REST-service that is working excellent on CF11. When I copy the files to a new CF2023 server and try to register the service in the administrator I get the following error when the model contains either fieldType="one-to-many" or fieldType="one-to-one" exception.log:Caused by: java.lang.ClassNotFoundException: org.hibernate.engine.spi.SharedSessionContractImplementor not found by orm [155] I tried it with the original build-in Java 17.0.6 and 17.0.8

We are running CF 2016 update 17 docker image. CF Admin trying to use Simlink feature in Tomcat using file /opt/coldfusion/cfusion/runtime/conf/server.xml   CF Admin added <Resources allowLinking="true" to get simlink working, When we are restarting the container, the file is getting replaced by the default file.  If i'm trying to mount this file using file-mapping, then CF container isn't strating successfully. showing this:   [000] Checking server startup status... [000] Checking server startup status... [000] Checking server startup status... [000] Checking server startup status... [000] Checking server startup status... [000] Checking server startup status...   Can someone advise how to get arounf with this issue?

Bit of an odd one here. We are still using the YUI library for cftree back from when it was included pre CF2016.When installing an update through the CFAdmin UI, the update seems to delete some things from the cf_scripts folder. Most notably the yui folder containing the yui.css file at: cf_scripts\scripts\ajax\resources\yuiDoes installing an update clean up things in cf_scripts or something? This behaviour did not exist in CF2018. We skipped over CF2021 so not sure there.

Is there a way to restrict access to  CFIDE admin in docker containter in CF 2023? Mapping or using special port? 

Hi All, Running ColdFusion 2023 on Windows Pro 11.MSSQL 2022 server installed. Does CF "REQUIRE" jdbc driver to connect to SQL server or is it only an option? If it's required CF should clearly state that. I know I've dealt with this before, but can't remember how I fixed it. I downloaded the jar file for it ( mssql-jdbc-12.4.1.jre8.jar )  and put it in the lib folder in coldfusion. Still no go. I don't see it listed as a driver when creating the datasource.I did restart CF and SQL server afterwards. I'm logging into SQL server using Windows authentication. I don't recall seeing a choice during installation to do it any other way. Web searches suggesting:1. make sure TCP/IP is enabled: Yes, did that.2. Get jdbc driver: Yes, did that.  Put in CF lib folder.3. Add "AuthenticationMethod=ntlm" in the advanced settings Connection String CF settings: Did that.4. Tried putting servername/username in that didn't help. Still not working. Head is

Hi We recently upgraded from coldfusion 9 to coldfusion 2016 and the error that we are getting when we try to load the code is runWddx.js:15 Uncaught ReferenceError: WddxDeserializer is not defined.From inspecting it seems that it is not able to load wddx.js and wddxDes.js these two files.Please suggest what needs to be done.Screenshot is attached for ref.

I have a component that declares a closure,  executing the closure fails when run outside of the original request. It's calling another component function but getting this error java.lang.IllegalArgumentException: Response cannot be nullAny solution will be helpful. 

I'm trying to do the following: The query works and cfdumps 2 items as expected. valuearray fails as part of cfset set and I've tried various and sundry combinations of quotes and such with no luck. Can someone help me sort this out? The end goal is to have an array I can do an arrayFind against to see if someone gets to see a particular web app or not. Tanks, JimB 

Hello allI have a new installation of CF8 on a Windows XP Pro machine. Configured to run on IIS. Whenever I try to open CF Administrator or other cfm files, I get a download pop-up instead of loading the file. I have IIS set up to recognized index.cfm files. I made sure CF8 is actually running.Any input?ThanksKhaled