Questions

Hi, I'm running CF 2023 Update 6 on Windows Server 2022. According to the package manager the htmltopdf package is installed but cfhtmltopdf isn't working. On the CF admin -> PDF Service page it looks like everything is setup properly:Name: localhostHost Name: 127.0.0.1Port 8995Engine: 2.0When I try to start the service I get "Error enabling PDF Service Manager. Check logs for more details" In the coldfusion-out.log I get: Mar 19, 2024 10:54:15 AM Error [http-nio-8500-exec-3] - Connect to 127.0.0.1:8995 [/127.0.0.1] failed: Connection refused: connect http://127.0.0.1:8995/PDFgServlet/verifyMar 19, 2024 10:54:15 AM Error [http-nio-8500-exec-3] - Error enabling PDF Service Manager.Mar 19, 2024 10:54:15 AM Error [http-nio-8500-exec-3] - coldfusion.document.webkit.PDFgErrorHandler$ConnectionVerificationFailedException: Connection verification failed. Using "netstat -an", I don't see any service listening on port 8995. What am I missing? Sincerely,  Alan Ya

This is really annoying.  When I use jquery selectors with #, cf builder's code coloring gets broken.For example, in this image, the rest of the page after the selector in the is that sickly yellow / brown color.  My code block is not surrounded with <cfoutput> tags.  Any way to fix this that doesn't involve doubling up on #? 

Hello there. I have over 5k pages where each has at least one image with extension .png or .jpg. Now, I was checking my website performance here: https://pagespeed.web.dev/ and it shows my images load very long which gives low google score.  They suggested to me to use webp files which is okay however, I have plenty of images. Do I really need to convert each image to webp and than brute force each .cfm file to edit HTML for each image. That would be crazy.  Another thing here is that I would like to set that webp but still keep compatibility for browsers that don't support webp. That would probably involve using <picture> tag.  But, my main question here is if there is something coldfusion can do about this to automate this so that I don't have to trouble myself with such robust job? 

After upgrading from Coldfusion 9 to Coldfusion 2021, I'm having issues with displaying Chinese/Japanese characters in the pdf files that are generated using cfdocument from html code. The characters display properly when output as html, but disappear when converted to pdf with cfdocument. Any one else encounter this? Was there any changes to the pdf engine that Coldfusion uses? Thanks!

I have downloaded the latest CF 2018 server to install a development server on my local machine.  However, during the installation process, my machine restarted.  I am not able to get the server to start.  So, when I launch the uninstall app I get the following pop-up error message. File Missing!installvariables.properties file is not present in install folder. Hence uninstallation has failed. My aim is is to uninstall so I can redo the installation process.  Even if I could fix the current installation, I would still like the ability to uninstall in the future.   I have searched online and in the forums but I might have missed an answer to this problem.  Any assistance that leads to a solution to my problem will be greatly appreciated!

Unwanted white-spaces appear when using inline HTML-tags, while converting HTML to PDF: <cfdocument format="PDF" pagetype="A4" orientation="portrait" overwrite="no" fontembed="yes"> This is a sentence with <i>italics</i>.<br /> And here <b>bold</b> is used.<br /> </cfdocument> The <i> and <b>-tags (actually: any tag) generates extra whitespaces. Anyone an idea to solve this problem/bug?

hi all, I'm having a problem with the implementation of new fonts to be used both in the cfdocument to create a pdf and in the cfreport. As you can see in the picture I downloaded the .ttf files and put them exactly in that path and put the correct path inside Font Management on the administrator cf . The folder exists and the path is right, I restarted CF but there is no way the fonts are displayed in both cfdocument and cfreport. Always use a default font, how can I fix this? 

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