Questions

Hi,I've never used cachedwithin parameter before in queries as the queries are generally dynamic but i'm potentially thinking it might be of benefit to us. The question I have is with a lot of users and active sessions, would adding this cachedwithin parameter to a few queries overload the cache or have negative affects to performance. I don't know enough about how the cache works or what kind of space it has to operate. Is there a benefit of using that parameter if the queries are dynamic. All I can see in the documentation is that for dynamic queries it will create a new one for each but it doesn't warn against using it if that is the case.Thanks

Ive been using POIUtility.cfc on cf8 and its worked flawlessly. Now we have switched to cf23  and I am getting this error Element CELL.CELL_TYPE_NUMERIC is undefined in LOCAL. We are using the exact same spreadsheet. worked fine in cf08 but now doesnt work cf23. Any ideas?

ColdFusionを用いてPDF統合の検証中ですが、うまくいきません。複数ファイル（拡張子：xls,xlsx,docx,txt,pdf）を１つのPDFファイルに統合し表示したい（PDFポートフォリオを作成、表示したい）のですが、一部ファイルがプレビュー表示されません。 表示する端末によっても挙動が変わってしまうのですが、TXT,PDF形式のファイルはプレビュー閲覧できています。Excel、Wordのプレビュー閲覧ができず、「文書を開く」を押下することで作成元のアプリケーションが立ち上がり、別ウィンドウでの展開はできる状況です。 検証中のソースではcfpdfタグを使用し、以下設定しています。action="merge"package="yes"overwrite="yes" PDFポートフォリオの作成方法の変更で端末に依存せず、全ファイルのプレビュー表示ができるでしょうか。それとも、特定のAdobe Readerでしか表示できない等、制約があるでしょうか。

Except for uninstalling and reinstalling the software as a whole, is there a way to update the Deployment Type from Development to Production?ColdFusion 2021 Enterprise was installed initially with the Development Type because the environment where it was being installed was yet to be full Production. We now have licensing acquired and are ready to go full Production with the software, but I am looking for if there is an easier way to update it.

Getting below error while running the application in localhost :  You do not hold the required permissions to access this page.If you believe you should be able to access this page, please contact the system administrators:The following information has been logged for audit purposes but I have access to the development database, same application is running as development server, no issues with dev serverI cleared cache in my 127.0.0.1 cf aministrator. but still same issue. I'm not sure how to resolve the issue, please help

I am using Coldfusion 2023 (developer version, for now while I test it). In the debugging IP address section (see image below) I have entered 127.0.0.1 But, it doesn't matter what IP address I connect from, I still see the debugging info when I test with a .cfm page that has an error in it.I thought that debugging info would only show if I connected from the ip address in the debugging list. Is there something else that I need to configure?  

I have code that reads a network share to get a list of directories which then I compare to another newtwork share to determine if there are duplicate folders (same name folder in both network shares).  I had the code running  correctly on ColdFusion 2016 (Linux) but we are now on ColdFusion 2023 (Windows Server 2022) so i'm working on updating the code to access the network share on the CF2023 server. I've tried just using the network share location but that doesn't return anything and then I tried mapping a drive in Windows to access this share but I get a directory not found error.  I also tired using the linux network share '/nas/root' but that just throws errors saying it doesn't exist (which is to be expected). The code below is what i'm using to test cfdirectory.   It looks like ColdFusion can read and write to the network shares but when I run the cfdirectory to get a listing of directories nothing is returning.  I've been in the wee

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"