ColdFusion

I'm attempting to use the native driver for my datasource on AZURE.  When verifing, I get[Macromedia][SQLServer JDBC Driver][Macromedia][SQLServer JDBC Driver]Attempted connection to the secondary server <HOST>:11000 failed.When I use the JDBC driver from microsoft, I do not have this issue.Any suggestions on how to configure the native driver to resolve this error?  I've tried matching the JDBC connection string in the additional settings, but still get this error with the native driver. Thanks! 

I was sent a patch to solve a particular problem, which I installed.  Then I was sent another patch and told to uninstall the first one and install this one instead.  How do I uninstall the first patch?  I see no uninstaller.jar in the hf-updates directory for the first patch I installed. Thanks.  -bg

hello,I am trrying to setup SSO with a ColdFusion 2021 application and Azure SSO - does anyone know of a guide?I am running into the problem where is seems I get stuck in a loop on the Idp side (azure)I think the problem is where I am  using the certificates. 1) do I have to figure out how to extract the public key from the cf keystore and where exactly do I need to past the cert obtained from the Idpin the sign or encrypt section of the idp configuration on the cfd side this is the errorError Message: The Message of the Response is not signed and the SP requires it

Auto Lockdown adds a few RedirectMatch rules to prevent accessing certain parts of your install when securing an Apache install. A few of the regex's used in these rules are too generic. For instance:RedirectMatch 404 (?i).*.svn.* RedirectMatch 404 (?i).*.git.*The unescaped period and lack of a leading directory separator makes these rules too generic. In particular, the .git expression matches a common words like digit or digital. These were added with the 2021 lockdown tool I downloaded on October 11th and I'm not sure how long they've been added. 

 I am using ColdFusion 9 Enterprise edition and using CFHTTP to send data to consume an API for SMS services, but I am getting the following Error I/O Exception: peer not authenticated. My Code <cfhttp url='https://sms.itpark.pk/api/sendsms' method='POST' multipart='yes' result='res'> <cfhttpparam type="header" name="username" value="03xxxxxxxx" > <cfhttpparam type="header" name="mask" value="ITPARK" > <cfhttpparam type="header" name="password" value="00xxxxxxx" > <cfhttpparam type="header" name="to" value="92300xxxxxxx" > <cfhttpparam type="header" name="from" value="92300xxxxxxx" > <cfhttpparam type="header" name="message" value="Some Message" > </cfhttp>What I Tried:I've Googled and searched and tested all possible solutions. Even Installed the Certificate of the service provider, tried changing the JVM but ColdFusion 9 won't start. Tried to follow the instructions on adobe

Coldfusion 2018, Linux serverThis is on our development site but was working until last week. We've googled and see this is not uncommon and tried the suggested solutions such as creating a mapping, which seems the most popular, and a few others but nothing seems to fix the issue.The development machine is shared so each developer is mapping their CFCs to their own unique location and each application has a unique name even on the same server, a hash is involved.  When we create the Create the object<cfobject component="/#APPLICATION.cfcroot#.Security" name="sec"> It seems to find the Security CFC because the error is on the "extends" attribute which is set to a CFC called Authenticate.<cfcomponent extends="Authenticate" accessors="true" output="false" persistent="false"> It can't find the Authenticate CFC which is in the same directory and throws the error, "Could not find the ColdFusion component or interface var.www.html.mark.financeonline.account_ser

I'm trying to report this so the online docs get corrected:On the page:https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-r-s/cfschedule.html#There is an error: The misfire attribute used to accept "fire_now", but after CF2018 it's "firenow"This page is still telling users to use fire_now, which will result in an error.

Hi Coldfusion communioty. i am trying to write mobile app that uses camera. I have taken CFML code from Adobe website :https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-mobile-functions/camera-functions/cfclient-camera-getpicture.htmland trying to run it using emulator as well as web browser but facing javascript errors:"Your client-side CFML code has encountered an initialization error. The required plugins cannot be loaded successfully within the timeout period"I have coldfusion 2021 Standard edition installed on my local machine.Someone please help me running the code given on above mentioned URL. Whats going wrong, not sure. Your client-side CFML code has encountered an initialization error. The required plugins cannot be loaded successfully within the timeout period.  

Hi,Would like to know is it possible to have multiple sort in array of structuresIn other words,is there any equivalent function for multi_sort like in php?For example,in the below product color information,want primary sort using product style column and secondary sort using its color. ie,if same product has different color,sort again using color as below.AA6040~~redKP155~~LimeKP155~~OrangeTried using arraySort as below,but seems it can be used to sort using single key.<cfscript>local.ary_styleInfo = arrayNew(1);authors = structnew();authors= {style = 'KP155',color = 'orange'};//writeDump(authors);arrayAppend(local.ary_styleInfo ,authors);authors = structnew();authors= {style = 'KP155',color = 'Lime'};//writeDump(authors);arrayAppend(local.ary_styleInfo ,authors);//2authors = structnew();authors= {style = 'AA6040',color = 'red'};//writeDump(authors);arrayAppend(local.ary_styleInfo ,authors);writeDump( local.ary_styleInfo );//sortarraySort(local.ary_styleInfo, function (e1, e2){r

I just upgraded a server from ACF 2016 to ACF 2018 and I started receiving a strange java.lang.ArrayIndexOutOfBoundsException error message on some Query of Query (QofQ) statements.  What's strange is that the exception only occurs when I have SELECT * in the statement.  When I actually specify the columns by name, the exception goes away. Unfortunately I can't replace the issue on www.trycf.com because I need an actual database query to start from. Here's a simplified example of a query that throws the exception:   <cfquery dbtype="query" name="tempInvoices"> SELECT * FROM invoices </cfquery>   Replacing it with the column names (or this), fixes the issue:   <cfquery dbtype="query" name="tempInvoices"> SELECT #invoices.columnList# <!--- I can also list out the columns and it works ---> FROM invoices </cfquery>  The exception looks like this:Has anyone else encounter

Existe-t-il une option pour que la fonction supprime les accentués  (exemple : Ê pour E) ?Merci par avanceIs there an option for the function to remove accentuates (example: Ê for E)?Thanks in advance

Recently our team decided to implement a secure session management. It is very similar to the guidelines mentioned in the article.Session Management Guide CFML Documentation (cfdocs.org) However, the hash stored in the cookie is not immediately updated. ie when CF reads from the cookie to verify it, it still holds the old value and logs the user out. It doesn't happen often but randomly. Especially when we there's multiple user actions in quick succession. Has any one implemented a solution similar to this? The code has been made thread safe by encapsulating in cflock block. Please advice.

Hi,We need to support currency values that are configurable to allow up to 6 decimal places regardless of the currency.  Is there any way to disable or modify the rounding that is applied by lscurrencyformat? thanks,Mark

Hi there,Just as a FYI we have to use CF10 for a specific application we use and we are not able to upgrade this to a later version. Last week the email notifications stopped being sent out from CF, the error from the log is below. Nothing has changed on the servers. "Error","scheduler-0","11/18/21","08:07:37",,"javax.mail.MessagingException: Could not convert socket to TLS; nested exception is: javax.net.ssl.SSLHandshakeException: Remote host closed connection during handshake" Despite not having the Java auto update enabled it appears that this updated last week to version 8 update 212 (build 1.8.0_212-b10) I have spoken to someone one who believes that the issue could be caused by Java depricating some certificates and hence why the Remote host is closing the connection. They suggested that I replace the mail.jar in CF with javax.mail-1.6.2.jar to resolve the problem, but I just do not know if this will work or if I am going to break my CF. I should add

Howdy, We have purchased Cold Fusion 2021 and transitioned to the new production server on AWS.We cloned the production server to use as a development server, which should be permitted under the license.Since it is a clone, the development server has the same license ID, but usage is listed as Production. How do I alter the licensing on the development server so its use is listed correctly?Thank you.

Ok, this is strange. Maybe because I'm darn tire. But anyway...I have a simple login script that checks stuff and then if successful logs them in via setting session variables into the session via a struct like so:<cfset session.user = {} />I then set all my other user specific stuff in this struct. That's straightforward...and when I dump session.user...it shows the data. However, if I refresh the page, this session variable disappears. If I simply dump "session" then I see the usual CFID and CFTOKEN stuff. So session is enabled and ready, but why then does it disappear?I have done stuff like this before so I really can't see what's happening. The session timeout is also set to 30 minutes in the Application.cfc so that shouldn't be it.My CFC code is below.Many thanks,Mikey.==================================<cffunction name="authenticateUser" returntype="void" output="true" access="public" displayname="authenticateUser">        <cfargum

I did a colfusion upgrade from CF2016-11 to CF2016-17 and after that I noticed that the line separator  in JVM settings has changed from Chr(10) to Chr(36).  I believe this is causing issues when I try to view a file and it has the \r\n at the end of each line wth no line breaks. Also few of our menu options is showing this in the screeen too ($\r\n) How do we change the Line Separator in settings from Chr(36) to Chr(10)  like it was before - We are running CF in Linux RHEL env. Any help is very much appreciated. Thanks Sajan

Hi, I've had to increase the allocated memory once before but I forget where to do it? I've looked through CF admin but I must be missing it. Thanks in advance... Gary 

I have just started using PostgreSQL as a datasource for ColdFusion Server 2021 Developer Ed. Used DBeaver to export a legacy MS Access 2007 database into a PostgreSQL 12 database which sits under a schema Datasource registered OK. I ran a cfquery against a table.______________<CFQUERYname="qryFrameworkListRender"datasource="PostgreSQL35W">SELECTPipiObjectClassFrameworkID,PipiObjectClassFrameworkCodePage,PipiObjectClassFrameworkName,PipiObjectClassFrameworkDescription,PipiObjectClassFrameworkExample,PipiObjectClassFrameworkNoteFROMtblpipiobjectclassframeworkWHERE(((PIPI_OK)=Yes))ORDER BYPIPI_Sort, PipiObjectClassFrameworkName;</CFQUERY> ______________ This error shows up. I'm puzzled. The table name is spelt correctly.-----Error Executing Database Query.ERROR: relation "tblpipiobjectclassframework" does not exist Position: 234  The error occurred in C:/ColdFusion2021/cfusion/wwwroot/pipi/framework.cfm: line 2927 : <CFQUERY 28 : name="qryFrameworkList

Good day,I would like to know if there is documentation that explains the field headers in CF2021 so that I may better ingest them into our SIEM Solution.  I have no experience with CF in past and am finding it difficult to locate information about what is being conveyed in the various logs.  Any information is appreciated.Best regards,Greg

Can anyone help me out with settings to get Coldfusion to relay through Gsuite/ Google Workspace. I keep getting mail rejected. Apparently I "must configure your mail server either to use SMTP AUTH to identify the sending domain or to present one of your domain names in the HELO or EHLO command." but I don't know how I would do that with ColdFusion. Thank you.

Hello,Using coldfusion 2016. have some queries related to character entity values.Tried html equivalent character entity for replacing trademark and apostrphe special characters. Function used is given below.private any function specialCharUpdate(strData){// Ampersandarguments.strData = replacenocase(strData, '&', '&##38;', 'All');// ™ trademark// arguments.strData = replace(strData, '™', '&##8482;', 'All');arguments.strData = replacenocase(strData, '™', ' &##153;', 'All');// Apostrophearguments.strData = replacenocase(strData, '''', '&##39;', 'All');arguments.strData = replacenocase(strData, '’', '&##39;', 'All');// Circlearguments.strData = replacenocase(strData, '®', '&##174;', 'All');// Copyrightarguments.strData = replacenocase(strData, '©', '&##169;', 'All');return arguments.strData;} 1) The apostrphe from keyboard ' is getting replaced with 'But another kind of apostrphe ’ is not getting replaced with either ' or «Thi

Does anyone know where to download ColdFusion Builder 2016?  The official URL Adobe - ColdFusion Support Center : More Downloads does not provide a correct download. Thank you in advance for your help, -Chris 

I have a server running CF2018, serving multiple websites.  In CFAdmin, in Mail Server Settings, I have specified the address for our internal email server.  Email generated in this configuration is flowing properly, and has been for years.  What I recently found is that, regardless of the source domain, all emails being passed on to our email server are having the "From" entry in their header file set to the same domain, instead of each email header "From" entry being set to the domain that generated the email.  We are using Exchange 2010 on the internal email server. How do I reconfigure our environment to address the above issue?  As all sites are sending email through the same channel, via CF, is differentiation even possible?

Hi all - I have a clustered environment of three CF Enterprise servers (bare metal) each running four clustered instances.  After much testing, we recently put these into production and are experiencing frequent errors.  This seemingly causes the instance to hang, and requires manually stopping the instance, waiting a few moments and then restarting.    This is happening at random to all instances, across all three bare metal servers, multiple times a day.   It's a full time job identifying the failed server and CF instance, and then restarting it.   Does anyone have any suggestions on how to diagnose the issue? From the coldfusion-error log on a failed instance, we see: Jul 19, 2021 6:27:59 PM org.apache.commons.digester3.Digester startElement SEVERE: Begin event threw exception java.lang.ClassNotFoundException: net.sf.jasperreports.engine.xml.JasperDesignFactory at coldfusion.bootstrap.BootstrapClassLoader.loadClass(BootstrapCla