ColdFusion

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

I am attempting to migrate a CF10 application to CF2018 that uses a CFLDAP call to an Active Directory server and is experiencing failures. We have already used keytool to import the AD server certificate, and we have verified connectivity by telnet <ip address>:636 and can create a connection via openssl s_client -connect <ip address>:636. We use CFSSL_BASIC, port 636, and are getting this error on the LDAP call:Detail: One or more of the required attributes may be missing or incorrect or you do not have permissions to execute this operation on the server. Operation: query :<ip address>:636I have noted in the coldfusion-error.log an error that occurs when CF restarts:INFO: The Apache Tomcat Native library which allows using OpenSSL was not found on the java.library.path: [C:\ColdFusion2018\cfusion\lib;C:\ColdFusion2018\cfusion\jintegra\bin;C:\ColdFusion2018\cfusion\jintegra\bin\international;C:\ColdFusion2018\cfusion\lib\oosdk\classes\win;C:\\ColdFusion2018\\jre

I am trying to change my websocket connection to WSS and can't determine why it's not working.  I have obtained a keystore with the type JKS, which uses the same certificate as the website.  It is not self-signed.  Port 8543 is accessible when I try to test the connection.  Yet when I visit https://mywebsite.com,  my browser console says the WebSocket connection to wss://mywebsite.com:8543 failed.  I'm not sure where to go next for troubleshooting.

We were having a number of issues with our database connections (turned out to be a database issue) so did a ColdFusion Application Server service restart just in case that helped.The licence then went back to Developer. Re-entered the Standard licence key and all is well.But need to understand why this happened.  Running ColdFusion 2018. Never occurred on our old ColdFusion 10. Concerned if it happens out of hours - eg. a server reboot or someone else restarts the service, as this used to be a standard way of getting ColdFusion working it if hangs. Thanks  Paul 

Have a case open as well but wondering if anybody knows about this. Just purchased CF Standard 2021 (for All Supported OSes — which should include Windows!) but in the Download area, only see Linux/Mac/Solaris as in screenshot.

On a self submitting form (like a Contact Us)...Why is <cfif structKeyExists(form, "submitform")> preferred over <cfif IsDefined('FORM.submitform')>?What is the advantage/benefit of structKeyExists?Thanks

Hi, We've just started a migration from ColdFusion 2016 to ColdFusion 2021. We have been using cfstat.bat to gather statistics that we periodically write to disk and then ship to Kibana. This has been working well for ColdFusion 2016, but when running the same setup on ColdFusion 2021 we ran into issues. The following works fine:PS C:\ColdFusion2021\cfusion\bin> .\cfstat.bat Pg/Sec DB/Sec CP/Sec Reqs Reqs Reqs AvgQ AvgReq AvgDB Bytes Bytes Now Hi Now Hi Now Hi Q'ed Run'g TO'ed Time Time Time In/Sec Out/Sec 0 0 0 0 -1 -1 0 0 0 0 0 1361 0 0 But when we add the -x switch ("Extended output. (Included counters for individual request types)") we get the following back:PS C:\ColdFusion2021\cfusion\bin> .\cfstat.bat -x Pg/Sec DB/Sec CP/Sec Reqs Reqs Reqs Templ Templ Templ Flash Flash Flash CFC CFC CFC WebS WebS WebS AvgQ AvgReq AvgDB Bytes Bytes Now Hi Now Hi Now Hi Q'ed Run'g TO'ed Q'ed R

I am getting error when I am using column index inside the Query of Query SQL. This is happening on Coldfusion 2021 and seems fine w/ Coldfusion 2016. Is this bug w/ Coldfusion 2021? THANKS!<cffunction name="test" access="public"> <cfquery datasource="myDS" name="local.getData" > SELECT email, first_name, last_name FROM users </cfquery> <cfquery dbtype="query" name="local.testQrySet"> select email, first_name, last_name from getData where id=<cfqueryparam value="1919" cfsqltype="cf_sql_numeric" /> order by 2 asc </cfquery> <cfdump var="#local.testQrySet#" /> </cffunction> <cfset test() /> 

I'm attempting to use the cfexchange tag to create an event in Outlook Calendar. However, I was unable to gain access to the outlook server; is this a security issue with the outlook server itself? Can I still use cfexchange if the email account is a shared account, such as project@xxx.com, rather than a personal account?  

Hi, I have been working with pdf type files in Coldfusion and I can't get the characters to appear quite right.For example I get the character attached, it should be a μ.I am using the tag <cfdocument> to save the information and <cfpdf> to create the component.Thank you very much for any help you can give me.

We updated Coldfusion 2018 from Update 11 to 12 on windows servers and began having permissions issues when trying to read from or write to folders on file servers. ColdFusion can do this for folders on the ColdFusion server but if it is a file server (aka not on the same server), it has issues. Prior to the upgrade the we could perform folder and file related access activities without issue. We tested this issue with a script which looped over a list of folder paths and performed:Check to see if the folder exists (directoryExists(...))If not create the directory (<cfdirectory action="create"...>)If does exist then just print that it existsDo a directory listing of the folder and dump results to screen (<cfdirectory action="list" ...>)Copy a file from a local server folder to the destination folder (<cffile action="copy" ...>) We verified that the ColdFusion service account had read and write permissions to all of the folders involved and were even

I read this article https://helpx.adobe.com/coldfusion/kb/enable-ssl-coldfusion-administrator.html about making the CFADMIN use SSL with CF2021.  But I don't understand this line: "Make sure you also import the private key and have the correct key pair." How do you import the private key? Thanks!

Hi,We updated our CF servers over the weekend and since the update we've had errors coming in from an area with a Query of Queries is used. Basically there is an order by in the QoQ and this is the field not being returned. It should be returned and it was until we did the updates and for now I had to manually add the field back into the select statement. It should be returned via a select query.* from original but not working now. The only one missing though is the one used in the order by clause. Anyone had similiar issues? Thanks

Our IT started to block outbound internet traffic from our Coldfusion server by default. I usually use CF amin interface to install CF updates. Can anyone tell me what IP addresses Adobe uses for ColdFusion updates? I would like to allow outbound traffic to those IP addresses. Thanks. William

We have the base version of CF 2018 (build  2018.0.0.310739) and need to apply the upgrades.  There are 12 of them.Looking at the comments in some, they say : The updates below are cumulative and contain all updates from previous ones. If you are skipping updates, you can apply the latest update.Does this mean I can cut it down to 3 updates (ie. updates 4, 8 and 12)?Or should I always apply each upgrade in turn.To make life interesting we have no test server and it is used 24x7 within out organisation, so I need to minimise down time.

Worked on and ensured both Server.xml and workers. properties file resolved.  pointed both to server Ipfor host. Continues to get Internal 500 when logging into site for index.cfm. I have tried different index.cfmunder our content folder under root. For some reason .cfm not rendering. I intially removed /installed Connector. was getting errors now fixed.Triplex check IIS setting ISAPI etc all look good.If i click on recycle site, home page load with any content showing. Just some embedded links.at a loss. Working on this last 2-3 days.This is a fresh CF2021 install on Windows server 2019.CF Admin working fine, mappings/DSN for both Oracle 19c and MySql 8 testing fine. txs in advance Jose

Hello,I have an strange issue on CF2021. The following code works in the first loop and afterwars fails with the message: "I/O Exception: Received fatal alert: handshake_failure. Connection Failure. Status code unavailable." Other targets like google.com e.g. work fine. <cfloop from=1 to=10 index=i><cfset data_url = "https://www.cruiseportal.de"><cfhttp url="#data_url#" method="GET" resolveurl="no" useragent="#cgi.http_user_agent#" timeout="50"></cfhttp><cfdump var="#cfhttp#"></cfloop> Any ideas? CF 2021.0.02.328618Tomcat  9.0.50.0JVM 11.0.1 

We updated our Coldfusion 2018 installations to the recent version 12.After this update code of the form <queryname>("<querycolumn>").toArray(), which worked the way ValueArray(x,x) worked before, is broken.Is there any way to get compatibility here or do we have to change the application?

I am having an issue where some of our mail is not sending to the mail server. All the mail is setting the spool. When I check the mail log I am seeing this error.  Can't find resource for base name coldfusion/tagext/mail/resource.properties Does anyone have any suggestions?

Saw the link athttp://www.irt.org/articles/js154/index.htm which explains how to do it.But, my need is a bit more than what is shown.I have to run a query and based on results of it decide what should be a row title, then display its value. Something like<cfquery name="getDepartments" datasource="#Application.ds#">                    SELECT *                     FROM departments                    WHERE deptID = '#form_data.deptID#'                </cfquery>then<table width="100%" border="1" rules="all" cellpadding="5px" cellspacing="0px" style="width:100%; font-family:Arial, Helvetica, sans-serif; font-size:12px;"&gt

Hi,I have a current development environment where we use a program called GoodSync to copy files from our local computer to a development server where we can then test our code.  We don't run CF locally on our own desktop/laptops.  Usually this works just fine but occasionally we have an issue where we can't copy our files to the server because the file gets locked by ColdFusion.exe.Any ideas why ColdFusion is locking files and not releasing them?  We have to restart the CF service in order to clear the locks.  It seems like this is happening by mistake for some reason.  I've never encountered it in any other environment.-Steve

Before I start working on manually migrating over CF11 fix19 setttings over. I was trying to update newly installed CF services to run under domain account. This accounthas logon as services permissions and is an Administrator on our 2019 Windows server.I keep getting logon failure. I made sure this account has full rights to f:\Coldfusion2021 install folder and its subs. ty Jose

 Started receiving errors on issuing a spreadsheetAddRows in production code using a CF2018 standard server after applying update 12.Production code was working as intended until update was applied.  After Update 12 was uninstalled, the code is once again working as before.