Questions

Hello All:I tried to read password protected excel file by using this line of code<cfspreadsheet action="read" query="MyControlPanelQuery" src="D:/LocalDocuments/FileName.xlsx">I gave me this error "An error occurred while reading the Excel: org.apache.poi.EncryptedDocumentException: The supplied spreadsheet is protected, but no password was supplied"I got this kind of error because the FileName.xlsx is password protectedThe thing is "<cfspreadsheet action="read"....> doesn't any attribute to read a password protected excel file.Any advice please? Thank you

Hi ,I want to upgrade my application from coldfusion 9 to coldfusion 2021..can I upgrade cf 9 to cf 2021 Directly? Thanks..

We updated Coldfusion 2018 from Update 11 to 12 this week (including query of query hotfix by the Coldfusion Support) and after this some of our servers were not reachable any more (we had to roll back as these are productive servers).Tomcat outputs HTTP Status 403 - Forbidden.I searched in the forum and found entries about Update 8 leading to such an error.But we had installed coldfusion 2018 incl. Update 10 in the beginning and updated to 11 since. So I presume this must be another problem.Is there any known problem with the current Update 12 and Tomcat?

Hello, Will CF2021 be adding support for Java 17 now that it is the latest long-term support (LTS) release? Regards, Carl.

I need to do my updates manually so I need all of the files (hotfix and repos). The page below does not currently contain a link to the hotfix 002 file. https://helpx.adobe.com/coldfusion/kb/coldfusion-2021-updates.html I used the format of the link to update 001 to create the link below which will download the hotfix 002 file but again this link is not on the updates page. https://cfdownload.adobe.com/pub/adobe/coldfusion/2021/updates/hotfix-002-328618.jar Can someone please get the link to the hotfix file added to the 2021 updates page.  Thanks.

I'm preparing to upgrade a CF application from v2016 to v2021.  In looking at Deprecated Features (adobe.com) page, I'm confused by several features that are listed as removed in v11, but deprecated and unsupported in v2018.  The information on "cfcache" is a good example. This doesn't make sense to me.  If it was removed in previous version, why would it be listed as deprecated in a later version?  Is this a mistake on the page or am I misunderstanding something? Thanks.

We have Coldfusion 2016 and it is running on Oracle 11g. we just updated from Oracle 11g to 19c and have tried to make a connection by creating a new data source with ojdbc8.jar in Data Source on a CF Admin.  The creation was sucessfully and the verfication also showed me "OK"however, when running our web it showed an error belowHere are the steps what I did. 1. downloaded a ojdbc8.jar ( I also tried ojdbc10.jar but no luck ) and placed it in C:\ColdFusion2016\cfusion\lib and then restated the service. 2. create a new data source in a DS page (I added the tnsoraname.ora below)-----AAAA=(description=(address_list=(address = (protocol = TCP)(host =xxxxxx)(port = 1521)))(connect_data =(service_name=AAAA)))-----so, I put the JDBC URL and Driver class like that: JDBC URL:jdbc:Oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxx)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME = AAAA)))Driver Class: oracle.jdbc.driver.OracleDrivert

Hi All,Our Prod environment hosted on CF18 connects to a FTP server to place some files through a schedule job. The client complains that they getting multiple keep alive requests per second which is causing a big drain on their resources. We initially thought some error with the job and restarted the job which was scheduled for the next morning. We din't get any keep alive erros until the next moring but once the job run we got the error again. We also tried moving the codebase to a new CF instance but that din't help either. Have checked for the FTP connections and they are indeed closing. At a loss as to what is happening. Any insights would be very helpful. Thanks,Abhi.

Hello, I want to get the value of cfselect option whitout click submit. I see, we can use the OnChange Method but i can't recover the javascript value in Coldfusion. Can you help me ? Thanks in advance.

Hello folks, Has anyone recieved this erorr when trying to add or edit a SP within the CFADMIN? Its working on one server and not on the other, both have identical configurations. I get this error when editing an existing SP entry and when trying to save a new one! class coldfusion.saml.SpConfiguration cannot be cast to class coldfusion.saml.SpConfiguration (coldfusion.saml.SpConfiguration is in unnamed module of loader org.apache.felix.framework.BundleWiringImpl$BundleClassLoader @1bbea556; coldfusion.saml.SpConfiguration is in unnamed module of loader org.apache.felix.framework.BundleWiringImpl$BundleClassLoader @487f3afe)   

Hello, I create a Docker container using the latest, standard image of ColdFusion 2021 docker run --rm -d -p 8500:8500 -v /cf_test:/app -e acceptEULA=YES public.ecr.aws/adobe/coldfusion:latest start I try and access org.apache.commons.lang.StringEscapeUtils.<cfset escapers = CreateObject('java','org.apache.commons.lang.StringEscapeUtils')> Response:java.lang.ClassNotFoundException: org.apache.commons.lang.StringEscapeUtils This works on a server installed version of CF 2021. What am I doing wrong here? 

Is it possible in coldfusion Globalization and localization?for example i have developed a site in india.Now i need to open a same site in china,but the site will display in chinesense language.Which coldfusion version will support this.Thanks,

I am uploading files to an Azure Blob storage container using CF2021. The files are uploading with a content type of application/octet-stream. I need to change this so that I can display them rather than having them download when accessed. What option can I use in my parameters to upload files with the proper content type in Azure? 

I am trying to get animation to work in CF11, CFChart. I can't it to work any input would be greatly appreciated.My code is below. Arrows works, but plot does not.<cfscript> arrows=[{"backgroundColor":"red","label":{"text":"Data for 2017","bold":true,"backgroundColor":"white"}, "size":6,"FROM":{"x":200,"y":100},"to":{"x":400,"y":200}}]; plot = { "animation": { "effect": "ANIMATION_FADE_IN", "speed": "2000" } } </cfscript> <CFSET FormsMarkedCompleted = 34> <CFSET FormsMarkedNotCompleted = 21> <CFSET TotalFormsEntered 40> <cfoutput> <cfchart showygridlines="true" gridlines="20" type="bar" <!--- arrows="#arrows#" ---> plot="#plot#" chartHeight="320" chartWidth="800" title="Number of competed forms and expected forms" > <cfchartseries >

I´m having trouble figuring out how to implement the uploadDirectory method for Azure Blob.The documents are giving and uploadFile() example instead of the correct one and the parameters listed does not comply where used as shown below: Thanks in advance!

Ola, alguem recomenda algum curso on-line de CF?

Needed to update my CF Addons container and went to Adobe Docker page and found out that Bintray is dead (good) but that instead of moving CF Docker files to someplace like Docker Hub - I have to manually download a .tar file?     It's 2021? Is Adobe serious about Docker / containers and modern infrastructure????And the best part was when I finally DID manually download the CF2018 tar file for the container image it was broken.   So frustrated with Adobe's direction lately.

I just installed a dev version of CF 2021 to prep for an upgrade from CF 10.The exact same urls now respond with the above error from identical urls.  I presume the bad parameter is the "&{}" but this existed in CF 10 with no issue.  Tried adding URIEncoding="UTF-8"relaxedQueryChars="{}" to the apache server.xml but had no success. It's not browser specific. This is the log entry:Oct 15, 2021 12:09:56 PM org.apache.coyote.http11.Http11Processor service INFO: Error parsing HTTP request header Note: further occurrences of HTTP request parsing errors will be logged at DEBUG level. java.lang.IllegalArgumentException: Invalid character found in the request target [/iFM-Portals/system/srre/editor/index.cfm?targetaction=GlobalEditor&t=ifm_users&keylist=BELLPA2&{}&_=1634310596756 ]. The valid characters are defined in RFC 7230 and RFC 3986  

Hello  i make portable data logger device and i want to be all data in pdf formate  i use microcontroller Pic 18f2450 that have USB interface  i want when the usb is pluged or by push button the device create pdf file from the data  

Hi, I am testing a process we have, on CF 2016 enterpise. ( 2016.0.16.320445  ) A scheduled page month_end.cfm calls a number of additional processes via cfhttp. This website ( on an intranet ) I have just recently implemented https. Since the move to https the calls to the other pages do not work. The documentation for CFHTTP has instructions for using https, and I have imported the site certificate with the provided keytool command, however the error still occurs.   CF server http.log shows the call, but does not show an error. Other logs show no info either. The call is pretty straightfoward:<cfhttpurl = "#getPageContext().getRequest().getScheme()#://#cgi.server_name##getDirectoryFromPath(cgi.SCRIPT_NAME)#runthispage.cfm?EOM=#VARIABLES.MONTH_END_DATE#&unique=#TimeFormat(Now(),"hhmmss")#"method = "get"></cfhttp> How do I further debug the connection failure, and where do  I go from here? Thanks, 

Hi everyone,I got a strange issue with coldfusion 2018. It is working on my local machine, but everytime I try to run it on one of my servers, the first time it goes through, but the second time it throws me an error.{"Errordetail": "I/O Exception: Received fatal alert: handshake_failure","Mimetype": "Unable to determine MIME type of file.","Statuscode": "Connection Failure. Status code unavailable.","Filecontent": "Connection Failure","Responseheader": {},"Text": true,"Charset": "","Header": ""} I thought by adding the certificate into the cacerts would solve the issue but to no prevail. I verified the debug but I'm no expert in this matter.What bugs me the most is that, whenever I restart the coldfusion service it works for one call, and then goes back into the error.Can anyone help me with this?Url I'm calling is (it's not the real one, but I have it set on this to test the return): https://api.opensea.io/wyvern/v1/ordersThx

Hi All,We are trying to connect Azure DB by CF ORM. But it keeps showing the error message like either Unable to determine Dialect to use [name=Microsoft Azure SQL Database, majorVersion=12]; user must register resolver or explicitly set 'hibernate.dialect' ORjava.lang.NullPointerExceptionat coldfusion.orm.hibernate.HibernateConfiguration.determineDialect(HibernateConfiguration.java:401)a We tried to setup "ormseetings.dialect" with different values in application.cfc,e.g.MicrosoftSQLServerorg.hibernate.dialect.SQLServer2008Dialectorg.hibernate.dialect.SQLServer2012Dialectorg.hibernate.dialect.SQLServerDialectorg.hibernate.dialect.MicrosoftSQLServer2012DialectSQLServer2012DialectSQLServer2008Dialect But all failed, any idea which value would be correct in "ormseetings.dialect" to make it works? Thanks,CF Dev 

I would like to use ColdFusion to add dynamic breadcrumbs to my site. Does anyone know what is the best way to do this? For example, if I'm at www.mysite.com/about/privacy.cfm. I'd like to display Home > About > Privacy Policy at the top of the page. Thanks.

I have been banging my head against this brick wall for awhile now. I have some beefy scheduled tasks that easily go over our global timeout. Since we upgraded to Coldfusion 2018, it seems like the standard fix of <cfsetting requestTimeout="7200"> doesn't override the global timeout.I have also added timeouts to every query within the template, as well as the cfhttp call itself. Funny thing, when I remove the cfhttp call from the template, it still times out with the same error The request has exceeded the allowable time limit Tag: cfhttp even though the tag is gone.When I run the page directly via the URL, the template runs perfectly and never times out.So, how do I make the schedule task respect the timeouts within the template and ignore the global timeouts?

Hi,I am trying to run a Java Agent with ColdFusion 2021. In coldfusion error.log it prints NoClassDefFoundError and breaks some functionalities. This is usually due to OSGi infrastructure conflict which gets resolved via adding property org.osgi.framework.bootdelegation=agent.package.* in a osgi related config file or via -D option. But with  -D option it's not working and there is no appropriate .properties file to give in this value or even a way to know if these are getting picked up or not. Any solution to this?Exception in thread "DefaultQuartzScheduler_Worker-1" Exception in thread "DefaultQuartzScheduler_Worker-10" java.lang.NoClassDefFoundError: agent/package/InterceptorDelegatorBoott at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java) ..... Caused by: java.lang.ClassNotFoundException: agent.package.InterceptorDelegatorBoot not found by org.quartz-scheduler.quartz [14] at org.apache.felix.framework.BundleWiringImpl.findClassOrResourceByDeleg