Questions

Using cold fusion 11 we unable to viee the data from front end through stored procedure. Pls help how to modify cf script accordingly 

Updating to CF2021 Enterprise Update 11 on my Linux server connecting to Oracle 19c database that uses encryption & checksum breaks.  Downgrading the Oracle package from 2021.0.11 to 2021.0.05 lets me connect again. While an update to the Oracle driver isn't listed in the Update 11 notes, it is indeed updated. They do mention "enhancements in ...Database, and other areas".  Searching for "database" I see some changes to MySQL and Postgres but nothing for Oracle.  I do indeed see the new files on my filesystem.  Going to the Package Manager in the CF Administrator GUI shows that it has updated to "2021.0.11.330247".  If I select "2021.0.05.330109" in the "Available Versions" and then click "Downgrade" and restart my CF instance, the datasource now connects.  Incidentally, there is no "downgrade" command in cfpm.sh so I had to actually go through using the web-gui to do the downgrade.  I'll submit a Feature Request to allow downgrade command vi

Hi, After applying CF update 14 on cf2021 box search no longer works.  When I go to the CF admin to the coldfusion collections tab I get: Unable to retrieve collections from the Search Services.Ensure that you have installed ColdFusion Search Service and it is running. I tried uninstalling the search component and re-installing and also down grading the search component but no luck. After more research, I see that the issue only happens when there are multiple Coldfusion Instances and does not happen on my local which only has one CF instance Any ideas? Thanks,Gabe

I want to pass a query into a function one row at a time in the same way you could pass an array to a function one row at a time. I've read that queries are just CF structures under the hood so I believe it should be possible. I just don't know the syntax to reference a single query row (and all it's variables). I don't want to pass the whole query to the variable because I would like to do the looping outside the function. The idea is to simplify and standardize the formatting and arrangement of several variables (columns) in a UDF and keep the syntax to use the function simple. Therefore, I'd like to avoid having to do stuff like convert the query to an array. That would defeat the goal of keeping it simple. Thanks Magnus

Hi all,Recently I have installed coldfusion2023, while configuring IIS and coldfusion appliaction server, trying to run wsconfig.exe file, I am getting java.lang.NullPointerException errors and unable to move forward.can anyone help me how to troubleshoot or suggest me alternative solution for this?Charlie ArehartThanks,

The following cfdocument is not displaying the fonts.<cfoutput>        <cfdocument format="pdf" fontembed="true">            <style>body{font-family: 'SimSun' 'Microsoft Yahei'; font-size: 35px; }td,th, h1,h2,h3, p{font-family:'Microsoft Yahei', sans-serif,Helvetica, Arial;}    </style>        <cfoutput>            <h1>PDF #chinese characters here#</h1> <!-- "PDF Example Title" in Chinese -->          </cfoutput></cfdocument></cfoutput>===========================AWS Linux 2023 EC2 instanceCF2023 TrialTried:Adding fonts via CF AdministratorAdding fonts to /usr/share/fontsAdding fonts to /usr/share/fonts/default/TrueTypeUsed in-built web server as well as apache All suggestions welcome!  Thank you.

I installed PMT 2023 on a REHL 9.3-0.5.el9.x86_64. I accepted all of the defaults from the installer. When the installer finished it said it had some errors and I should look at the log files. I went to where it told me the log files were but there were no log files. Trying to connect through a browser returned a 404 page not found error. I stopped and then started the PMT and when I started the PMT I got the error below which probably explains why there were no log files. It seems there is a permissions issue. [cimwebadm@tx11cofu01lvtst bin]$ sudo ./perfmontoolset startException in thread "main" java.lang.RuntimeException: starting java failed with [1]output:[0.000s][error][logging] Error opening log file 'logs/gc.log': Permission denied[0.000s][error][logging] Initialization of output 'file=logs/gc.log' using options 'filecount=32,filesize=64m' failed.error:Invalid -Xlog option '-Xlog:gc*,gc+age=trace,safepoint:file=logs/gc.log:utctime,pid,tags:filecount=32,filesize=64m', s

Here's the revised text with your example included:---If you are using a Docker image of Adobe ColdFusion, such as `adobecoldfusion/coldfusion2021:2021.0.13`, and in the compose file you have set the environment variable `INSTALL_MODULES=ALL`, the Docker container will fail to build.The issue is related to the latest hotfix update 14, which was released recently. When you specify `INSTALL_MODULES=ALL`, it attempts to install all ColdFusion packages to their latest version if you do not specify any version for the packages. This works fine if you are using the latest build tag of ColdFusion.On June 12, 2024, ColdFusion 2021 update 14 was released. I was still using the ColdFusion base Docker image `2021.0.13`, where the latest update 14 is not installed. When the container starts and `INSTALL_MODULES=ALL` is set, it tries to install the packages to their latest version. Some packages require the latest update (e.g., update 14) to install the latest version of those packages, causing the

Anyone know how to setup a Datasource connection to a MS SQL Server 2016 using Active Directory credentials with CF 2018 enterprise version? Currently we use DB credentials but the business is moving away from that and wants more secure AD account connections. Problem is my CF 2018 installation is on RHEL 7.9 and WebSphere 9.0.5.6 and CF does not run under any AD account that I am aware of. I am thinking there is no way to do what I am asking unless we created an AD account for CF to start under which may cause other permission issues with CF. This is all new to me to so any suggestions or thoughts are greatly appreciated. Thanks.

Hey all. I have a footer in my PDF document and I'm trying to show "Page 1 of 2", for example.  <cfhtmltopdfitem type="footer" align="left"> <cfoutput> <body style="padding: 0px; margin: 0px; width: 100%; border-top: 1px solid ##000000;"> <p style="padding: 0px; margin: 5px 0px 0px 0px; width: 50%; float: left;">As of #dateFormat(now(), "mmm dd, yyyy")#</p> <p style="padding: 0px; margin: 5px 0px 0px 0px; width: 50%; float: left; text-align: right;">Page _PAGENUMBER of _LASTPAGENUMBER</p> </body> </cfoutput> </cfhtmltopdfitem> When I render the PDF, it shows "Page 1 of _LASTPAGENUMBER", so it looks like it's not getting a proper value for _LASTPAGENUMBER. I have also tried using: Page #cfhtmltopdf.currentPage# of #cfhtmltopdf.totalPageCount# But it outputs the same thing as above.

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?