ColdFusion

spreadsheetAddRows treating strings like numbers and ending up with -1 as a value

Hi,We have certain values  (e.g., '1002-1', '1002-2',  ...   '1002-12') that end up as -1 when added to a spreadsheet via spreadsheetAddRows.  Weirdly, '1002-13' is fine.  Maybe spreadsheetAddRows is making bad guesses about whether a value is text vs a number?   spreadsheetSetCellValue doesn't seem to have the problem.  I reproduced the issue in cffiddle, although it looks like CF 2025 is going to fix the problem.   This cffiddle link shows the issue:  https://cffiddle.org/app/file?filepath=b1d4c4bd-0989-4481-bcd3-46200ec39e7f/f4b909fd-a448-49ff-87da-91f8eb9f4d16/f29fc59a-821f-4481-9ad3-8f32869c6dd4.cfmHas anyone run into this before, and do you happen to have a workaround?  thanks,  Mark<cfset testArray = [[ 'Bar, Foo', '1002-1', 'G009']]><cfset theSheetObj = SpreadsheetNew("tempSheet",true)><cfset spreadsheetAddRows(theSheetObj, testArray)><cfoutput>#SpreadsheetGetColumnCount(theS

2952

KARMA28699455uxq6Inspiring

cfhttp call within REST service returning 301 Moved Permanently

In building out a new server for ColdFusion 2021, I migrated code running on CF2016 which is returning a strange error. One of my GET REST services which calls another using cfhttp is returning the following: { Message: "JSON parsing failure at character 1:'<' in <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN"> <html><head> <title>301 Moved Permanently</title> </head><body> <h1>Moved Permanently</h1> <p>The document has moved <a href="https://myservername.ddns.net/rest/services/grantPermission">here</a>.</p> <hr> <address>Apache/2.4.52 (Ubuntu) Server at myservername.ddns.net Port 80</address> </body></html>" } What makes this even stranger is the fact that there is no redirect in either service.See the below snippet of error from the exception log:"Error","ajp-nio-127.0.0.1-8020-exec-2","04/21/23","18:57:09","","HTTP 500 Internal Server Error" coldfusion.rest.meth

27822

SajanMInspiring

CF2023 java.sqI.SQLException: Timed out trying to establish connection

We had a new linux vm built (RHEL 9) and installed CF2023. We migrated the settings (.car file) from the existing CF2021 and trying to get it up and running. So far we are good with admin console and app folder migrations. But we could get the datasource connection working. The issue we are seeing is when trying to verify an oracle datasource. (using macromedia.jd bc.oracle.OracleDnver)        Connection verification failed for datasource:ptcltst        java.sqI.SQLException: Timed out trying to establish connectionWe have checked network connectivity between the cf 2023 server and the orace database on port 1521 and it successfull but it fails in the admin console with above error. There is nothing being recd at the target oracle db.When we try the same connection from CF2021 server admin console, we are able to connect and oracle is able to recieve the connection info20-NOV-2024 15:00:22 * (CONNECT_DATA=(SERVICE_NAME=tstdb)(CID=(PROGR

27592

Aidan WhitehallInspiring

cfchart issues in a security sandbox on ColdFusion 2021 Developer Edition

A machine running ColdFusion 2021 Developer Edition has sandbox security enabled and the ColdFusion Lockdown Tool run. The following sandbox File/Dirs permissions have been granted: %cfusion-root%/tmpCache/CFFileServlet/_cf_chart      Read,Write,Delete%cfusion-root%/tmpCache/CFFileServlet/_cf_chart/*   Read,Write,Delete A chart created using cfchart is causing a NullPointerException to be thrown (stack trace shown below), seemingly in the method call setUpWatermark(). Activating the server or disabling the sandbox causes the cfchart image to be displayed. In the latter case, the Not For Production Use watermark is shown. Does anyone know what changes are required (perhaps additional sandbox permissions?) so the cfchart-generated image is displayed when sandbox security is enabled on a machine running the Developer Edition? Thanks in advance. java.lang.NullPointerException at coldfusion.graph.InteractiveChart.setUpWatermar

2081

Saurav_GhoshCommunity Manager

NOW LIVE! Adobe ColdFusion (2025 release)

The wait is finally over! ColdFusion (2025 release) is now live and generally available! What’s New in ColdFusion 2025? New licensing With the release of ColdFusion (2025 release), Adobe has transitioned from a traditional serial key-based licensing model to a subscription-based licensing mode. About ColdFusion's new licensing method Named User Licensing Feature Restricted Licensing: Online Offline Isolated New spreadsheet and CSV functions Support for streaming spreadsheets, 30+ new methods for cell and sheet properties, and methods to read or write CSV files. For details and a list, see What's New in ColdFusion (2025 release).   Language enhancements See Language enhancements in ColdFusion 2025. New functions and tags listGetDuplicates     structValueArray cfchartset getCSPNonce interruptThread isThreadInterrupted getPropertyString getPropertyFile setPropertyString   Deprecations and removals View Deprecated and removed features in ColdFusion

33385

karih38190410Inspiring

Having issue with cf2023_scripts location

I'm migrating from cf2021 Standard to cf2023 Standard and have a snag.  If I try to utilize an ajax component it is throwing this error.  It appears to be utilizing my virtual host as the location for the coldfusion scripts instead of the coldfusion install. I'm using RHEL9 with apache. Ajax component activates this path looking for what to do.http://<URL>/cf2023_scripts/ajax/package/cfajax.js

5161

mithilesh kumarParticipant

Coldfusion Certification

Where can I give Mock test for ColdFusion certification exam?

2233

joeyg60012433Inspiring

Coldfusion 2023 Silent Zip Install using built in webserver

We're upgrading from Coldfusion 2016 to 2023 for development on our laptops. We are attempting to make 2023 a silent install zip package. I've used the instructions here and was able to get into CFAdmin: https://helpx.adobe.com/coldfusion/using/install-coldfusion-zip.html The admin is running on port 8500. However, I can't manage to see any other files in http://localhost:8600/ besides the usual CFIDE, cf_scripts, restplay, and crossdomain.xml.In 2016 from what I remember, we just put our application files in wwwroot and didn't have to do anything else. So I'm not sure if the zip installer installs the built in webserver? Or maybe it doesn't enable it? My server.xml looks just like the 2016 version. I'm at a loss.

3971

Dordrecht7177366Inspiring

Are there Log4j vulnerabilities in ColdFusion2021, Update 18?

Hi, all.  I recently asked about Log4j vulnerabilities in CF2023, and learned that there are not any known at this time. Now, I need to ask whether CF2021, Update 18 has any Log4j vulnerabilities. The main reason I ask is because I have CF2021 Update 13 installed locally, and when I match the files that @Charlie Arehart mentioned in one of his linked articles, I find that of the files he indicates should exist in (CF_Home)/lib folder prior to file replacement with 2.17.1 versions:log4j-core-2.16.0.jarlog4j-api-2.16.0.jarlog4j-to-slf4j-2.16.0.jarMy directory has only these unversioned files (with no corresponding file for log4j-to-slf4j)log4j-core.jarlog4j-api.jar Possibly the files I have are version 2.16.0, although not named as such? I'm not sure how to check the versions programmatically, and I don't see that the installed Log4j versions are listed anywhere in the CF Admin. In a nutshell, will updating to CF2021 Update 18 remove all known Log4

5762

CHRISTOPHER5FF6Participant

New Java 17 versions?

Does Adobe still provide Java JRE downloads?  I need Java 17.0.14 and can't find it anywhere

7011

bell_the_catInspiring

ColdFusion 2023 Instances not using isolated Mappings

I am running an environment with a ColdFusion 2023 application on one instance (call it Prime) and two additional instances set up as developer copies (Dev1 and Dev2).  Each instance points to its own copy of the application source repository, so developers can work on their own isolated copy in their Dev sandboxes and restart or whatever without affecting the Prime instance.   Each instance maps /component_root to the appropriate local repository location in Server Settings for that instance: Prime--> /component_root = /prime/wwwroot/component/Dev1-->  /component_root = /dev1_repository/wwwroot/component/Dev2--> /component_root = /dev2_repository/wwwroot/component/ The code is supposed to use the mapping to call the correct version of the component for the instance: <cfset variables.SomeComponentCFC = CreateObject("component", "component_root.SomeComponent") /> However, what I'm seeing is that ALL instances come up with the P

8082

ctreevesInspiring

cfquery date range from UNIX

I have a table with UNIX timestamps. I’d like to get a count of events for “today”. So I’d like the query to find any event between 1 second after midnight and now. I’m using this on a forum to see if we reached our goal number of posts per day. Before I reinvent the wheel in a very painful 🙂 (for me) and sloppy way, I wanted to see if you professionals had any advice.    Please keep in mind, I am not a programmer. Thank you!

4982

Dave WattsCommunity Expert

ColdFusion 2025 public release today!

Hi, everyone!   It looks like ColdFusion 2025 was released to general availability today!   https://www.adobe.com/products/coldfusion-family.html  

2931

Junaid32092262a1i8Participant

Variable NULL is undefined`

<cfscript>test=null ///Variable NULL is undefinedtest1=javaCast("null",""); writeDump(test1); // Variable test1 is undefined</cfscript> Is there a way to make prevent getting the "variable null is undefined" error? If not, then I guess javacast("null", "") is the only alternative. However, when trying to use test1, I get the error "test1 is undefined". Could someone suggest a way of getting around this please?Thank you very much

3772

lucasc25675147Participating Frequently

QueryDeleteColumn errors out with java.lang.NegativeArraySizeException

I need help with an error I can't find an explanation for anywhere. On ColdFusion 2021, I'm trying to delete a column from a query. The query for sure contains the column I am trying to delete, as you can see from the code snippet, which works otherwise when I comment QueryDeleteColumn. <cftry> <cfset local.newColumnArray = ArrayNew(1)> <cfloop query="Data"> <cfif len(Data.columName)> <cfset ArrayAppend(local.newColumnArray, Data.columName)> <cfelse> <cfset ArrayAppend(local.newColumnArray, otherMethod(Data.differentColumn))> </cfif> </cfloop> <cfset QueryAddColumn(Data,"newColumn","VarChar", local.newColumnArray)> <cfset QueryDeleteColumn(Data,"columName")> <cfcatch type="any"> <cf_mcabort message="xxx [line #cfcatch.tagContext[1].line#]: #CFCATCH.Message#" except="#cfcatch#"> </cfcatch> </cftry> However, when I try do include that call, I get the following erro

5243

jarviswabiInspiring

Deploying CF App as WAR on Tomcat

I'm trying to deploy a simple CF8 application on Tomcat 5.5 as a WAR file. I've done the export of the app from the CF Admin as a WAR file and copied it over to my Tomcat webapps directory. When I first tried to start Tomcat, I got an error related to the "*.cfml/*" servlet-mappings in web.xml, so I commented those out based on a post I found elsewhere. But now I'm getting this error, and I can't figure out why: javax.servlet.ServletException: Invalid configuration at line 2 in file /usr/local/apache-tomcat-5.5.23/webapps/wishlist/WEB-INF/flex/flex-config.xml - cvc-elt.1: Cannot find the declaration of element 'flex-config'. at flex.server.j2ee.cache.CacheFilter.setupFlexService(CacheFilter.java:93) The flex/flex-config.xml file is there, and line 2 reads: <flex-config xmlns=" http://www.adobe.com/2006/flex-config"> Are there other manual edits I need to make in order to get this to work? If Flex is the problem, can I disable it from being included in the WAR? Has anyone done

15553

derekn911Participant

Legacy authentication fails when upgrading from Coldfusion 10 to 2023

I recently installed Coldfusion 2023 on a new server and got it configured to run my applications previously running on Coldfusion 10.  As I started to migrate applications, I discovered that all of them that utilized a legacy application.cfc authentication script now throw the following error:Failed to set cookie.ColdFusion is unable to add the cookie you specified to the response. This is probably because you have used it to set one of the ColdFusion Session Cookies or Authentication cookie. Please use Application/Server level configuration for this. The error occurred in E:/InetPub/wwwroot/ad_authentication_XXXXXXX/XXXXXXXX.cfc: line 1715 : 16 : <cffunction name="onSessionStart"> 17 : <cfcookie name="CFID" value="#SESSION.CFID#" /> 18 : <cfcookie name="CFTOKEN" value="#SESSION.CFTOKEN#" /> 19 : <cfset SESSION.DateInitialized = Now() /> I googled this error and found information regarding a setting change in CF Admini

9212

kirkdickinsonInspiring

Dates not formatting correctly since update to CF 2023 (found solution)

My CF host just did a server update to CF 2023. I spent all day fixing scope issues, but that wasn't too hard.I noticed that my pages are showing weird dates. For instance in the MySQL database, this date shows as: 2023-05-15 00:00:00, But it displays as: 5/135/2023 The code to display that date is #DateFormat(Born,("M/D/YYYY"))# Figured out what the issue was... D is days from the first of the year and d is days fo the month. When did this change?

9042

groundchuckyParticipant

Unable to configure IIS connector error ColdFusion 10

I am trying to get CF 10 installed on a Windows Server 2008 IIS 7 machine. I could not get the install to go through. Everytime I tried to bind to IIS All Sites it threw an error:"Unable to configure IIS connector. Enable the required ISAPI options(ISAPI Extensions, ISAPI Filter, ASP.NET and CGI). I installed as a development version and then added the serial number to see if I could trick it. It did install but when I went into the WEB SERVER CONFIGURATION tool to bind to IIS All sites, it threw the same error. I have all the features outline in the error message installed and verified. Has anyone else had this issue. Anyone know of any fixes/workarounds. Could it be a setting in IIS that I am not aware of......any help is appreciated.

26481

Dordrecht7177366Inspiring

Cf Admin errors in CF2021 After upgrading to Update 18

After I upgraded to update 18 on CF2021, I find that many of the administrator pages display errors like those below. I backed out the upgrade back to CF2021 Update 13 and the errors persist. The errors did not occur prior to the upgrade attempt. Anyone kno0w a solution? (P.S. Sorry to be asking so many questions lately. I've been a ColdFusion user for 25 years and am much better at programming than debugging software versioning and installation issues.)  

12741

the empress jonesParticipant

hyperlink with variable not working in CF2023

in a couple of places on my website i use hyperlinks with variables to go from one page to another<a href request2.cfm?thearea=area2>Area 2</a>this has worked perfectly for years right until the upgrade to CF2023 - now i get an errorVariable THEAREA is undefinedis there a solution besides changing to a button instead of a hyperlink - a button won't work when moving from one site to another

11531

ademd90752149Participant

Restricting users' access to Coldfusion datasource

Hi,There are two different databases on the same server (MSSQL) with a Coldfusion datasource added. How can I restrict access to these databases for two different developers who are developing with Coldfusion? Both users have file systems at a level that only they can access.For example, only user x can access database a. User y can access database b. User x, who has access to database a, can access the database that he/she does not have permission to by typing <cfquery name="GetAll" datasource="b{coldfusion datasource that he/she does not have permission to}">...</cfquery>Is there a way to prevent this?

3621

Laura32781154plhtInspiring

Does 2023 ColdFusion Developer version really expire?!

It's been installed for over a year with no problems.  Then today I couldn't login to Administrator.  I got no errors. I'm sure it's the right password.  I just does nothing when I attempt to login.  No messages of any kind.I checked services to make sure everything was running.  Everything was running except the "API Performance Monitoring Toolset  services. Nor will they start. I checked the apimanager.log and see this:"[ERROR] 2025-02-19 15:32:05.037 [main] GrootServer - Your Trial period has expired. Apply Enterprise license to use API Manager." Does anyone know what is going on?  Is this for real?What a bummer  😞

3421

douglas_4674Participating Frequently

Scheduled Tasks fail after updating SSL certificate

After updating my SSL certificate, my website runs correctly,  returning the new certificate information. However, I cannot get my scheduled tasks to run via CF Scheduler. Errors are like: "Information","DefaultQuartzScheduler_Worker-2","02/18/25","13:29:37","","Task DEFAULT.CHECK FOR COLDFUSION UPDATES triggered.""Error","DefaultQuartzScheduler_Worker-2","02/18/25","13:29:37","","Connection Failure: Status code unavailable" My java path is /etc/alternatives/jre_17/ How do I get the scheduled tasks to use the new SSL cert?    

7612

Matthew22377144yk0gKnown Participant

Licensing issues for Coldfusion 2021

We recently purchased a Coldfusion 2021 Standard license with the intent to upgrade our existing CF 2018 installation - we have both a test and production environment.  We initially upgraded the test environment using this license, and then upgraded our production environment.  We removed the license from test, however, in our CF Admin on production, we were no longer able to access the page with licensing settings (we could click on it, but it wouldn't load).  We even reinstalled CF2021, only to have the same issue, and had to revert back to a snapshot of our 2018 environment. Does anyone have any idea of what could be going on?

33772