Questions

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!

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

<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

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

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

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

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?

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.

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.)  

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

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?

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  😞

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?    

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?

Hi,I installed CF2021 and updated until 16 and any module have not installed. So I go the cfpm and when I try to install administrator module or whatever, it displays unexpected error D:\ColdFusion2021\cfusion\bin>cfpmcfpm>listUnexpected char -1 at (line no=669, column no=2406, offset=53831)cfpm>install administratorUnexpected char -1 at (line no=669, column no=2406, offset=53831)cfpm>install allUnexpected char -1 at (line no=669, column no=2406, offset=53831)cfpm>install mailUnexpected char -1 at (line no=669, column no=2406, offset=53831)cfpm> Any hint to fix this?

ColdFusion 2023 HF12 Finding - writeLog() function.  Following CF2023 server update to HF12, If a JSON string is passed as part of the text input to the writeLog() function, it double quotes {""key"":""value""} all JSON key/value pairs in the log.  Prior to HF12, JSON was logged normally {"key":"value"}.  Anyone able to confirm/verify this finding and whether there is a way to resolve?  thx! 

I noticed some errors ( for example, undefine varibles) are not logged on one of our coldfusion server. I have checked the settings, and I did not find any difference on the logging settings when i went to admin page. Because of the lack of logging, I have a hard time to debug our application. Can anyone help me? Thanks!

I’m relatively new to ColdFusion 2023 as we are in the process of migrating from ColdFusion 2018. Before I continue, I understand that we should have already completed the migration and the reasons why it is necessary. Unfortunately, I didn't have any control over the timeline, but I’m doing the best I can, and we are making progress. That said, I’m a bit confused about how updates are supposed to be applied to the server. From what I’ve gathered, the ColdFusion (2023 release) Update XX file updates the core application server, applying immediate fixes, adding new features, and so on. This update is cumulative. However, it appears that this update does not include any updates for ColdFusion packages. On the other hand, the Hotfix and Packages repository seems to contain fixes for specific issues and updates for packages. My question is: Which is the preferred approach? Should I apply the Update File, the Hotfix/Packages repository, or both? From what I understa

Last year the Log4J vulnerability called for the addition of the JVM argument -Dlog4j2.formatMsgNoLookups=true in CF2018 and CF2021. Does anyone know if this JVM argument is still needed/recommended/valid in ColdFusion 2023?

Our CIS has flagged Tomcat version < 9.0.98 as being vulnerable with critical severity.   Incorrect object re-cycling and re-use vulnerability in Apache Tomcat. Incorrect recycling of the request and response used by HTTP/2 requests could lead to request and/or response mix-up between users. This issue affects Apache Tomcat: from 11.0.0-M23 through 11.0.0-M26, from 10.1.27 through 10.1.30, from 9.0.92 through 9.0.95. Users are recommended to upgrade to version 11.0.0, 10.1.31 or 9.0.96, which fixes the issue. A hotfix to patch Tomcat to latest stable version for ColdFusion 2021 would be appreciated.

I have ColdFusion 2023 with update 11 installed on windows server 2022 Apache and for some reason it stopped working, no critical error reports

I am developing SAML SSO with Azure AD and our Coldfusion application at the moment and in Coldfusion 2021 everything seems to work. The configuration is there and the authentication works as well. When I try to configure SAML in Coldfusion 2023, errors are thrown in spconfig.cfm When I generate a new service provider, the configuration is created but this error is thrown:Variable GENERATESUCCESSMSG is undefined.The error occurred in spconfig.cfm: line 122Called from spconfig.cfm: line 100Called from spconfig.cfm: line 40Called from spconfig.cfm: line 1 Identical errors (only with other variables) come when deleting / updating a configuration.Also identity provider creation throws errors. Did anybody experience this? We use Coldfusion 2023.0.06.330617and SAML package 2023.0.05.330608 If I ignore the errors thrown and try to init SAML authentication also an error is thrown (that may be because the configuration is not correct): java.lang.NullPointerExc

Hi,I failed the Adobe ColdFusion 9 Certification attempt.  How many days should I wait reappearing for the test?  I could not find any information for this in any FAQ or page on Adobe.comMay be I am missing some portion of site, can anyone help me here

This is my code:<cfhtmltopdf orientation="landscape"> <h3>Test Landscape Output</h3> </cfhtmltopdf>This is my output:

While reviewing the technotes for Update 16, I noticed a mention about keeping the JDK updated. I understand that ColdFusion supports Java 11, and according to the ColdFusion documentation, it supports versions up to 11.0.25. Currently, I am running Java 11.0.11. My questions are: Is there a need to upgrade to a newer version of the JDK?Has anyone encountered any significant issues or challenges during the upgrade process? Additionally, if I install the new JDK using the .exe file, can I simply update the path to the /jre folder in the ColdFusion Administrator, restart the server, and test the changes? If there are any issues, would it be possible to revert to the previous version without complications?