ColdFusion

We are trying to run our application using tomcat 10 . However, we are getting some issue because of JAVA EE to jakarta migration. Currently we are using :Java: 17 Tomcat : 10CF : 2023 Server : Windows 2019 JAVA EE to jakarta migration: We have tried with one third party migration tool (jakartaee-migration-1.0.8) to migrate the war file. Result: Deployment issue was fixed(Context [/cfusion] startup failed due to previous errors) after the migration. However,not getting the new issue as admin page is not working. Issue Details : http://localhost:8080/cfusion/CFIDE/adminnotinstalled.cfm?script=CF_ROOT/bin/cfpm.bat&module=administrator  (HTTP ERROR 500)javax/servlet/jsp/JspContext The specific sequence of files included or processed is: C:\CHAYAN\Local Setup\Apache\Tomcat-VSSInternal\webapps\cfusion\CFIDE\adminnotinstalled.cfm''Could anyone please help/guide me to resolve this issue? 

To the CF team -Please add an enhancement that allows us to select a datetime format for those date/time fields in our queries / structs. There are times when I want to maintain the data exactly from my database so that it shows the same way in my SerializeJSON output. Give me an option to select which dateformat to send to the client. Thanks

Hello,With Chrome's 3rd-party cookie changes, I haven't been able to find anything about adding a partition attr/state with cfcookie. Am I not looking in the right place or I missing something? Any insight would be much appreciated! Right now, I'm using cfheader to set that, but there are some instances (mainly iframes) where I would like to set them and immediately have CF access it.  Working Example: <cfheader name="Set-Cookie" value="__Host-testCookie=; Expires=Thur, 29 Feb 2024 00:00:00 GMT; Path=/; Secure; SameSite=None; Partitioned;"> - https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-c/cfcookie.html- https://developers.google.com/privacy-sandbox/3pcd/chips- https://developer.mozilla.org/en-US/docs/Web/Privacy/Privacy_sandbox/Partitioned_cookies  

Please find the below sample code, <cfif local.fields[myName].readOnly><cfset thisAction = "view"><cfelse><cfset thisAction = arguments.action></cfif> <cfoutput> <cfswitch expression="#thisAction#"><cfcase value="edit"><textarea id="#myName#"name="#myName#"rows="#local.fields[myName].rows#"cols="#local.fields[myName].cols#"onkeydown="maxlength#myName#(this,'#local.fields[myName].MaxLength#');maxlength1#myName#(this);"onkeyup="maxlength#myName#(this,'#local.fields[myName].MaxLength#');maxlength1#FmyName#(this);">#IIF(len(local.fields[myName].value), DE(URLDecode(local.fields[myName].value)), DE(local.fields[myName].DefaultValue))#</textarea> </cfcase> <cfdefaultcase> <cfif LEN(local.fields[myName].value)><pre>#IIF(len(local.fields[myName].value), DE(URLDecode(local.fields[myName].value)), DE(local.fields[myName].DefaultValue))#</pre> <cfelse><!--- nothing

 I have coldfusion 11 installed with its latest update, how can I change to coldfusion 2023 

Have installed ColdFusion 2021 with update 1, on 64-bit Windows server 2019 Datacenter.  I can either run it with Java 11.0.11 from Adobe, or with sandbox security (with Java 11.0.1), but the ColdFusion Application Service will not start if I have both Java 11.0.11 and sandbox security.

I believe when we set up CF2018 a couple of years ago, we set it up for CF Admin to be accessed only if index.cfm is present. For example,http://servername/CFIDE/Administrator/index.cfm - will serve it uphttp://servername/CFIDE/Administrator/ - will not serve it up I'm not sure whether this was done as part of lockdown guide but it appears this is no longer working and I don't see anything in the lockdown guide. We're migrating to 2023 and I would like to set this up. Where should I look? CF Admin is not showing up in IIS as of 2016 as it's using built-in web server.

Hello All, We recently migrated our application from CF2018 to CF2021 latest update 5 version. After we upgraded, we observed issue with our charts all over application.There are some glitches created/observed in graphs and graph is not displaying properly.Please help/advise if anyone has faced similar issue before.Thanks,Dhanshree Joshi

Hi,We have recently upgraded from 2021 to 2023, and we are facing an issue in cfforms, binding is not working on cfselect. we have checked the cfscript directory location and scripts and everything is alligned. It will be great if someone can provide a solution please.  

Howdy,We have a MySQL Community server packaged as an AWS RDS instance. We had been running MySQL 5.7, but AWS is forcing an upgrade to 8.0 unless you pay an extra charge.We have a datasource that works fine for 5.7, using the "MySQL" driver from the dropdown, but when we try to connect to an upgraded snapshot running MySQL 8.0.35, we get:Could not create connection to database server. Attempted reconnect 3 times. Giving up.Stack Trace:java.lang.NullPointerException at com.mysql.jdbc.ConnectionImpl.getServerCharacterEncoding(ConnectionImpl.java:3307) at com.mysql.jdbc.MysqlIO.sendConnectionAttributes(MysqlIO.java:1985) at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1911) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1288) at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2506) at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2344) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2326) at com.

We've used ColdFusion for decades and for the longest time used CFDocument for PDFs.  We still use it for some legacy jobs.  When we saw CF11 included the new CFHTMLTOPDF tag we were excited but that feeling died instantly the first time we used it.  In some instances the results were so bad we soldiered on with CFDocument.  It's been a few years and we've long since switched to using WXHTMLTOPDF.  Our PDFs come our nearly flawless now.  However, we recently were debugging a "WX" issue on a new layout we're installing and decided to re-visit CFHTMLTOPDF.  Hideous!  While we're getting about 90-95% accuracy with WX, CFHTMLTOPDF again disappoints.ColdFusion is made by Adobe for crying out loud!  The quality of PDFs ColdFusion produces, by the makers of Acrobat, is embarrassing.Why has there been no CF integration with Acrobat after all these years!Ok, rant over.

I have a form that submits to a database. Sometimes users inadvertanly click the submit button 2 or 3 times, resulting in 2 or 3 dupkicate submissions.I would like to stop users from being able to insert any record within 5 seconds of the last insert<cfquery datasource="#APPLICATION.ds#" name="get_max_ID">SELECT MAX(insert_time) AS maxtime FROM FORMS</cfquery>When a form is submitted I need to check if it is within 5 seconds of the maxtime . If it is . I <cfabort> with an error message. If it is after 5 seconds I allow the insert. How do I do this check?

Hi, I have coldfusion 2023 on windows server.Scheduled tasks doesn't work. They are inserted correctly. (some of these already existed on the old server with CF2016).If I try to run them from the administration (the little running man) I get the following message: his scheduled task Gioca-resp - message remind of group default was completed successfully. But in reality it is not executedthe URL used in the task is HTTP - so not key issues. I tried to call the url with CFHTTP but I get the following error message:Connect Exception: Connect to Gioca-responsabile.it:80 [gioca-responsabile.it/194.76.116.40] failed: Connection refused: no further informationwhether I use http (therefore on port 80) or https (port 443).If I try to use CFHTTP with a domain that is not on the server, for example google, it works fine. If I put the URL in the browser it works fine What could it depend on? ThanksMarco  

I'm starting a new thread on this because I discovered my first approach would not work for all possible Solr syntaxes; some of which we difinitely need in our application. Basically, we are now taking a variable value from a forms code as shown below:<INPUT TYPE="hidden" NAME="keywords" VALUE="#Form.keywords#"> Then we are populating CFSEARCH with the syntax for a given query by using encodeForURL & decodeFromURL where appropriate in the application. So our CFSEARCH code is:  Note:  We have included an <cfoutput><cfabort> line of code for testing.******************************************<CFSEARCH NAME="applicants_#var#"COLLECTION="Resumes"TYPE="standard"CRITERIA="#encodeForURL( Form.keywords)#"><cfoutput>#applicants_test.recordcount#</cfoutput><cfabort>******************************************The output shows we are using the solr syntax needed for a given search.However, the only time where we get the correct nu

Adobe ColdFusion (2021 release) is finally here! The completely reimagined Adobe ColdFusion (2021 release) offers a modular, secure, and containerized approach to building applications that can run across multiple cloud providers or on-premises. You can now switch between cloud service providers without having to rewrite your application. For more information, see What’s new and changed in ColdFusion (2021 release). Take your applications to the cloud Seamlessly manage your infrastructure and reduce downtime by quickly connecting to the Microsoft Azure or Amazon Web Services (AWS) database, storage, messaging, Amazon RDS, and email services. Move services from one cloud service provider to another without having to rewrite your application each time. AWS SQS AWS SNS AWS S3 Azure Blob Azure Service Bus Modularization You can now install only the services your application needs, and nothing more. Modularization lets you continuously integrate small pieces of code and deliver applicati

Greetings All. After reviewing my testing below I would VERY, VERY much appreciate any suggestions as to why searches against a collection using a phrase are not working properly, in this case the criteria field = "tribology friction".This issue arises as a function of my attempts to solve a CFsearch problem in another thread.The following is a list of test which were done comparing the results of the Solr Admin tool (SAT), production server (PS), development server application code (DSAC) & deveopment server stand alone script (DSSA) against the same data. Note: the production server is running CF 4.51 & the development server is running CF 2023.The testing searched for the words "tribology" and "friction" using 3 different criteria as described below. Note: For those of you who are curious, tribology is the science of bearing wear.Criteria                       &

Hello All,We recently migrated to CF2021 in last week in Production and we are facing major issue with all Java jars. Jars are in CF2021/jre/lib folder but still we are facing hard errors on createObject function.Whenever CF trying to create Java Object using createObject function, it's giving classnotfound exception on that java object.If anyone faced this issue before please comment here. We will really appreciate your help!Thanks in advance!

Hi there, I recently built a ColdFusion 2021 server and I am trying to run "legacy code" on it. I have a service called getBank which I could call from the browser with https://***/rest/services/getBanl.xml or /getBank.json with ColdFusion 11 which would return a response in the correct format. I am now unable to use getBank.json with the new version of ColdFusion. Please assist. See the service below: <cfcomponent rest="true" restpath="getBanks"> <cfset datasource = "dsn"> <cffunction name="list_type_function" returntype="query"> <cfquery name="resultQuery" datasource="#datasource#"> SELECT bank_id, bank_code, bank_name FROM banks </cfquery> <cfreturn resultQuery> </cffunction> <!--- application/json for content negotiation ---> <cffunction access="remote" name="getBanksJSON" output="false" httpmethod="GET" returntype="query" produces="application/j

I have set up ColdFusion in a pod of my Kubernetes cluster. I have configured all settings (services, ingress, etc.), and everything is working fine. However, I'm unable to connect ColdFusion to the Apache web server through wsconfig.I've successfully done the same setup in a Docker container, but I encounter errors only in the Kubernetes cluster. The process of connecting wsconfig to Apache seems to proceed without errors, and when I list the wsconfig connected server, Apache is displayed.When I access the server (Apache), it's working, and I can reach it. However, when I try to run a CFM file, it gives a 503 error.I referred to the following documentation for guidance:https://helpx.adobe.com/in/coldfusion/configuring-administering/web-server-management.htmlVersions used: ColdFusion 2021/23 

Hello All, I am looking for simple solution to list down all objects unders S3 bucket specific folder. I can list down one object but challenge is object/keyname is dynamic. So, I cannot specify keyname while retrieving the object from s3 bucket. Is there any simple way if anyone come across to pull all S3 bucket folder objects and copy them into local directory?Then I can use <cfdirectory> to filter the files I want.Please suggest.Thanks in advance!

Hello Coldfusion Community!  It's nice to meet you all.  I'm seeking out some help performing a JRE update on our CF Server.  I am troubleshooting an high-priority incident with our software and hope I can some guideance toward a solution. Problem:Yesterday morning, we noticed that emails were not being sent from the site, getting stuck in the "Undelivered Mail" list.Upon reviewing mail.log, I found this message each time CF attempted to send an email.javax.mail.MessagingException: Could not connect to SMTP host: secure.emailsrvr.com, port: 465; nested exception is: javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested targetResearching this error led me to believe that it's possible our email provider or their CA had a security configuration change that doesn't work with this old server.   (C

I am trying to figure this out. Anything I try that uses s3:// prefix like readAsBinary() always ends up with "The AWS Access Key Id you provided does not exist in our records". Yet when I use downloadToFile() on the bucket object, there are no issues. Are there special perms to use that prefix? I am not the AWS admin.CF2023.

I am running CF2023 with JDK-21 using commandbox. I am getting the following error (see attached screenshot), which doesn't occur for me on prior versions of CF/Java. I added the following to my server.json which my understanding is this should be added by commandbox to the jvm.config file and I had assumed this would have stop the error, but it did not. Any advice/help would be appreciated:"jvm":{        "minHeapSize":"${MINHEAP:1G}",        "heapSize":"${MAXHEAP:2G}",        "args":[            "-Dcoldfusion.datemask.useDasdayofmonth=true",            "-Dcoldfusion.xml.allowPathCharacters=true",            "--add-opens=java.desktop/com.sun.awt=ALL-UNNAMED"     &nbs

Getting a few errors when we are cf document to generate a pdf file. coldfusion-error.log records: java.lang.NoClassDefFoundError: Could not initialize class java.awt.Toolkitand coldfusion-out.log records the error: Feb 1, 2023 14:16:36 PM Error [main] - Unable to initialise JAI service: java.lang.UnsatisfiedLinkError: C:\Program Files\Java\jdk-11.0.17\bin\awt.dll: Can't find dependent libraries Do I need to reinstall or repair either the Java SE Dev Kit app or CF 2018?

(CF2016/Win 2022/IIS 10) I want my users to be able to stay logged in for a long period of time, however as Microsoft release it's updates every second Tuesday of the month, I like to make sure these are in place asap and this almost always requires a reboot. A reboot loses all of the sessions, so the users would have to log back in again. I believe (well according to my new friend ChatGPT) early versions of CF used to have an option write the session to a file so it could be recovered but now it's memory or Redis. I did find a thread in the forum regards editing of Tomcats config, but I was a little uncomfortable doing that. Does anybody have any solutions to this? My thought is that I'll write a big unique token (or two) into a cookie and stored in their database record, and when they return if they are logged out, use that to reauthenticate them and create a new logged in session, a "remember me" so it automatically logs them back in seemlessly. One dow