ColdFusion

I used ColdFusion 2016 and CF Builder 2018 until recently, and had no issues using the CF debugger. We've upgraded to CF 2023, and when I try to debug my apps, breakpoints work, but I don't see any variables in the Variables view. If I try to evaluate an expression, the value is always "<error(s)_during_the_evaluation>". I've enabled Enable Request Debugging Output in the CF Administrator, and the Allow Line Debugging checkbox is checked. The Test Debugger and Test Connection buttons in the RDS configuration work successfully. No logs appear to be generated related to this issue. I'm running CF 2023 (update 7), CF Builder 2018, Windows 10 and IIS. What am I missing? Thanks!

Greetings,We have ColdFusion (2021 release) Update 13. The POI version should be 4.1.2 according to the next articleWhat are the version numbers of the libraries underlying CF2021 - ColdFusion (adobe.com)The CF package in the laptop show the same versionBut the version show 3.1.7 using the next codevariables.objPoi = createObject( 'java', 'org.apache.poi.Version' ).getVersion();writeOutput('<h2>'&variables.objPoi&'</h2>');We reinstall the update and reboot the laptop, still show the old poi version.Any ideas about this issue?How can we resolve this issue? Do we need to reinstall CF?Thanks,Johnny 

Hi, All.I'm running cf2021. Our application has been running smoothly during development for months, but we suddently got the following error message in the browser when accessing the site: After that, everyone else accssing the site got the same message. I'm seeing the following in the application log for the same times as the user attempts  (URL changed for privacy purposes):"The prepared statement handle 1 is not valid in this context.  Please verify that current database, user default schema, and ANSI_NULLS and QUOTED_IDENTIFIER set options are not changed since the handle is prepared. The specific sequence of files included or processed is: C:\inetpub\wwwroot\blabla\index.cfm, line: 55"I found comments at https://community.progress.com/s/article/Queries-with-ANSI-NULLS-ON-OFF-fails-with-SQL-Server-JDBC-Driver about this error, and it said it is related to SQL pooling. I looked at the advanced settings for my datasource (out of the box settings) and th

Hi All,I am finding solution in ColdFusion21 to get a file from a folder. I want to make changes in that file and want to remove top few header rows as well as blank rows. Then i want to filter records based on keywords "Water" that is in column 6. Then I have to remove last 2 coulmns that is 9 and 10.After all that changes I have to save that modified Excel file at target location.Note: Top header rows exsists in 2 columns only where detailed rows is in 10 columns.

I am finding solution in ColdFusion21 to get a file from a folder. I want to make changes in that file and want to remove top few header rows as well as blank rows. Then i want to filter records based on keywords "Water" that is in column 6. Then I have to remove last 2 coulmns that is 9 and 10.After all that changes I have to save that modified Excel file at target location.Note: Top header rows exsists in 2 columns only where detailed rows is in 10 columns.

I am finding solution in ColdFusion21 to get a file from a folder. I want to make changes in that file and want to remove top few header rows as well as blank rows. Then i want to filter records based on keywords "Water" that is in column 6. Then I have to remove last 2 coulmns that is 9 and 10.After all that changes I have to save that modified Excel file at target location.Note: Top header rows exsists in 2 columns only where detailed rows is in 10 columns.

Hi All,We have CF2021 in windows  IIS 10 (windows server 2019).We have 4 sites all in IIS using one application Pool. Can we assigned one site to their own application pool for better performance?I know it was a tomcat limitation before:Multiple application pools for ColdFusion possible... - Adobe Community - 6246482Thanks,Johnny

Hi,I am having issues with connecting to my ColdFusion website after changing  fileExtensions allowUnlisted="false" in IIS 10.0.   If I change allowUnlisted back to true, then the website works perfectly. Neither the IIS logs nor the ColdFusion logs show offer any assistance in debugging this problem.  There is a proxy if that matters.My web.config is shown below. (I have tried without the mimeMap settings and I have tried resetting the IIS connector)Any assistance would be greatly appreciated! Thanks!<?xml version="1.0" encoding="UTF-8"?><configuration><system.webServer><security><requestFiltering allowDoubleEscaping="false" allowHighBitCharacters="false"><fileExtensions allowUnlisted="false"><add fileExtension=".cfm" allowed="true" /><add fileExtension=".cfc" allowed="true" /><add fileExtension=".json" allowed="true" /><add fileExtension=".htm" allowed="true" /><add fileExtension=".css"

Hello, I am working on integrating UPS REST API and getting error message:{"response":{"errors":[{"code":"110609","message":"All package dimensions are required and each must be greater than 0 for package 1."}]}} This is my code:<!--- Get UPS Access Token Information ---> <cfhttp url="https://wwwcie.ups.com/security/v1/oauth/token" method="post" result="ups_authorization"> <cfhttpparam type="header" name="Content-Type" value="application/x-www-form-urlencoded" /> <cfhttpparam type="header" name="x-merchant-id" value="#UPSAccountNumber#" /> <cfhttpparam type="header" name="Authorization" value="Basic #ToBase64(clientID & ':' & secretKey)#" /> <cfhttpparam name="grant_type" value="client_credentials" type="formfield"> </cfhttp> <cfset ups_access_token_json = DeserializeJSON(ToString(ups_authorization.filecontent)) /> <cfset ups_access_token = ups_access_token_json.access_token /> <!--- Get UPS Shipping Rat

What has happened to the user guide? The Adobe page does not seem to include links to the reference for tags / functions etc. https://helpx.adobe.com/coldfusion/user-guide.html

Hello folks, Sorry for this naive question. Hello, I have recently installed ColdFusion 2023 and ran the update 6 which gave me an error during the installation. below is the error I have got Execute Script/Batch file: Extracting CURRENT_RUNTIME_USER from cfsetup.sh Status: ERROR Additional Notes: ERROR - Error while attempting to execute the installation scriptI realized that I have not mentioned SILENT_RUNTIME_USER  parameter in my silent install properties file. How do I fix this issue?  Please advice. Thanks.

I have a newly setup REHL 9.3-0.5.el9.x86_64 server. I have Apache 2.5.47 running on it. I installed CF2023 using the GUI installer and set it up with the Production Profile. I upgraded to Update 7 and then upgraded the Java to 17.0.11 and in the CF Admin I can see that it is running Tomcat version 9.0.85.0. In Apache I setup two virtual hosts and on my windows machine I edited my hosts file so that I can access both of those sites through a web browser on my local computer. I can access the CFAdmin just fine and .cfm test pages work fine. I am having problems getting the cfldap tag to work. I have setup many CF servers over the years from CF2008 until the current version and to get LDAP to work all I ever had to do was install some LDAP security certs into my java key store, restart CF, and then it would work. I have done that for my new server as well but I get an error on my test page “One or more of the required attributes may be missing or incorrect or you do not have permiss

How can I pipe a remote file directly to the response, without having to read the file in the memory or writing it to disk on the server? The remote file can be huge and I'm not going to do anything to the file itself. If possible I'd like to be able to set the basic headers like 'content-type' and 'content-length'. 

I am having an issue where the ColdFusion service inside of the Docker Container is not starting up. When I look at the Logs view in Docker Desktop all that returns is the following.  [] Checking server startup status...  This setup has been working for months and all of the sudden after the 14.5 update on MacOS it stopped working.  Chipset: Apple M3 MaxMacOS 14.5Docker Desktop Version 4.30.0 (149282)Docker Engine: 26.1.1 Docker Container Setup Script # variables cf_administrator_pwd=ColdFusion123 # Run the docker conainer docker run -dt --name mysite -p 80:8500 -v $PWD/www:/app -e acceptEULA=YES -e password=$cf_administrator_pwd -e enableSecureProfile=true --platform linux/amd64 adobecoldfusion/coldfusion2023:latest # Wait 10 seconds sleep 10 # Install All docker exec mysite /opt/coldfusion/cfusion/bin/cfpm.sh install all  When I look at the logs in the container I am seeing that ColdFusion is started /opt/coldfusion/cfusion/logs/c

I need to build a coldfusion 2016 environment before upgrading to coldfusion 2023. However, I can't find the 2016 installation version, can you help me?

I need a tool to support Unit Testing and Code Coverage for ColdFusion project, do you know any such tool? Thank you.

Hi, Every server I configure with the PMT (CF+PMT2021) it can't figure out the connectors, it has dubplicate entries for all connectors, once by ip, once by application name.It keeps switching over from ip to sitename connector constantly, and everytime it does I get an alert saying site unavailable, site available. This happens like 1000 times a day depending on the amount of connectors. I am fine with just ignoring this as everything seems to work fine and the PMT is just buggy I guess.The only problem I have is there is no option to disable these notifications, all alerts are turned off in every section on the nodes as well as the PMT alert settings itself. Anybody have any clue? <rant>It doesn't seem the PMT is used by many, as there are like 10 topics in total about it on this forum (2 of which are mine now, one on another account) and not properly updated by adobe as the 2021 PMT still says "© 1995 - 2020 Adobe. All Rights Reserved." It is also a pita to

So, hello again. On my website inside my root folder I had folders for some guides, however I moved them to another location. What I would need now is when they try to go to https://almarsguides.com/Aion/ , they are moved to https://almarsguides.com/Computer/Games/Aion/ . Because right now they will be redirected to page 404.  One important thing to note is that this should work for all guides. If let's say they go to https://almarsguides.com/Aion/professions , they should be redirected to https://www.almarsguides.com/Computer/Games/Aion/professions/ I will have to do this for other folders too, but this is the main idea. Is it possible to do this in Application.cfc because it seems that my htaccess doesn't work well?

Greetings,We have a ColdFusion 2021 installation on Server 2022 that calls all of its scheduled tasks via http://localhost. Now that we have implemented SmartCard login for the server, and set the server to https only and Client Certificate required, the tasks of course will not run. Any call to the server, even from localhost, will now require an https connection and must provide a valid certificate. I don't beleive the scheduler can provide that, though we could issue a soft cert for it and have it available to the engine if needed. Do you know of any guidance on how to do that?Alternatively we could run the tasks as Windows tasks, but it seems like the cfm files that contain the tasks scripts might need to be altered to run from the cf.bat in either cmd or powershell. It also looks like the cfms may need to be altered to run that way vice running in the browser. Do you know of any guidance for our developers on how to alter the cfm tasks to be run via cf.bat instead of via the brows

We have recently switched from one Antivirus/Firewall app to Windows Defender for Servers.  I tried replicating our settings into Windows Defender Firewall to allow our ColdFusion Webservers to operate.  End result, our sites were unable to be reached. Can someone provide a complete list of Ports/Port Ranges that require access? Windows Server 2019 running ColdFusion 2021.  SQL 2019 backend.  Apache webserver.  Traffic comes in as HTTPS (443) to our primary firewall, then using a VIP is transferred to our Load Balancers.  The Load Balancers do SSL Offloading, so the traffic is forwarded to the ColdFusion server on HTTP (80).  I have Firewall rules for both 443 and 80 to allow access.  I also have rules to allow the SQL access using the specific ports we have designated in our Data Sources (Within CFadmin).Turning off the Defender Firewall allows the websites to work again, so I am apparently missing a rule or two.Thanks,Phillip

Hello - Has anyone ever seen CFDUMP  - form, not display all the fieldnames with data in it? I have a number of formfields, but not A LOT of them and one of the names is missing. Anyway, I have attached a CFDUMP of the form fields...The field in question should be the last one in the list, it should be journal_date.It doesn't exist in the list of fieldnames, but the value does exist. Anybody have an idea of what's happening? Thanks Doug

We have 2 load balanced ColdFusion servers, and want to use PMT Performance Monitoring Toolset. The advice from Adobe : For deploying in production, it is recommended that Performance Monitoring Toolset must be deployed separately from a ColdFusion server. If we install on one of the ColdFusion server how much of an impact would it have? Marginal or a total no-no?

We are using cfhtmltopdf and inside calibri font block, content is not displaying in PDF  <cfhtmltopdf destination="FILEPATH" overwrite="true" orientation="portrait" unit="in" marginbottom="0.25" marginleft="0.25" marginright="0.25" margintop="0.25"> <cfprocessingdirective pageencoding="utf-8"> DISPLAYED IN PDF <div style="font-family:calibri;font-size:13pt;"> THIS IS NOT DISPLAYING IN PDF </div> DISPLAYED IN PDF </cfhtmltopdf>  We have installed calibri font. and coldfusion server: 2018.

I have setup CF on many windows servers over the years but this is my firat attempt at setting up CF on Linux. I have a newly setup REHL 9.3-0.5.el9.x86_64 server. I have Apache 2.5.47 running on it. I installed CF using the GUI installer and set it up with the Production Profile. I upgraded to Update 7 and then upgraded the Java to 17.0.11 and in the CF Admin I can see that it is running Tomcat version 9.0.85.0. In Apache I setup two virtual hosts and on my windows machine I edited my hosts file so that I can access both of those sites through a web browser on my local computer. Next I ran the wsconfig from the command line with this:sudo ./wsconfig -ws Apache -dir /etc/httpd/conf -bin /usr/sbin/httpd -vI can see it created several files in the ColdFusion2023/config/wsconfig folder and in the /ect/httpd/conf folder it added mod_jk.so and it added these lines to the httpd.conf file.Include "/etc/httpd/conf/mod_jk.conf"Include "/home/cimwebadm/opt/ColdFusion2023/config/wsconfig/1/mod_jk

I've been using a slightly modified version of the SocketGateway (examples.socket.SocketGateway) for over 15 years (modified just to comment out the "welcome" message) with great success.  Our legacy ERP system has several processes that communication on TCP/IP sockets and we've been able to streamline multiple integrations by letting it talk to my ColdFusion sockets and using CF code to connect to partner APIs.The new version of the ERP system has changed one of those socket processes to communicate over TLS and my CF socket can no longer understand what it's sending.  Strangely, the process still CONNECTS, but what I would typically receive as a single "message" with an EOF character is now broken up into multiple messages and gets logged as gibberish (the usual sort of binary characters you see from encrypted data).  I'm trying to figure out what changes would be needed to allow this connection to work properly.  I've started down the road of trying to modify the