ColdFusion

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.

Is it possible to merge 2 query results? I have a function that returns a querey result. < CFSET temp = query1> <CFSET FNCTransfers = temp> Now I want to change the query to return a merged query result < CFSET temp = query1> <CFSET temp2 = query2> Is it possible to merge the two results? Some thing like this (I know that it cannot be done like this) <CFSET FNCTransfers = temp1 & temp2> Maby it should be a union and query of query?

Hi, I need to consume the bitstamp websocket ( wss://ws.bitstamp.net. ) using ColdFusion and process the stream in the backend. I have read the cfwebsocket documentation, however this focuses on creating a websocket, i just want to consume an external websocket and process. Much the same as using cfhttp to make an API call. Any example code would be very much appreciated.    Link to bitstamp documentation  https://www.bitstamp.net/websocket/v2/

After installing the update 12 via CFAdminstrator, CF will not start. 😞 The log files shows...Installation: Successful with errors.3397 Successes0 Warnings1 NonFatalErrors0 FatalErrors The only error in the log file is...Custom Action: com.adobe.ia.action.ServiceStopCheckStatus: ERRORAdditional Notes: ERROR - class com.adobe.ia.action.ServiceStopCheck.install() runtime exception: When starting the service, Windows says... "Windows could not start ... blah blah blah ... contact the service vendor and refer to service-specific error code 2." Windows event log says: The ColdFusion 2018 Application Server service could not be started. Check the server "cfusion" log files for more information. The cf log files haven't been changed since the update. This is all I have to go on.  

Bonjour,Ayant un fichier word d'un livre, je voudrais le découper automatiquement par chapitre.Le problème est que je ne sais pas par où commencer 😞Est-il plus facile de la transformer avant en pdf ?Merci pour vos idées.Cordialement Hello,Having a word file of a book, I would like to automatically split it by chapter.Problem is, I don't know where to start 😞Is it easier to convert it to pdf before?Thank you for your ideas.cordially

I just received an email from Godaddy that they'll no longer support Coldfusion hosting on their servers within a couple of months. Finito. All coldfusion websites on godaddy will have to be taken down.For me, this is a huge burden, because I have several sites that I now have to find hosting for and waste all this time to configure again onto some other server. What about people who have businesses running on Coldfusion??I'm sad by this. I mean, Godaddy is one of, if not, THE largest hosting company. For them to just trash coldfusion is bad sign for me.I always worried after making the decision to use coldfusion that it would be put away someday due to its small audience. This worries me. What do you guys think of this?

Coldfusion 2016 install completes with the expected one non-fatal error (wsconfig connector). Once I fix that, I can open the Migration Wizard login page (http://localhost:8500/CFIDE/Administrator/index.cfm), but password fails repeatedly. I've tried running passwordreset.bat and restarting the services, to no avail. I've done this exact upgrade on 3 different servers with zero issues, but this one is making me bang my head against the desk.

It has looked like the problem was solved at CF 2021. After the 2nd. update, the same problem come back! I've created a simple component containing a private and a public function. component{    private numeric function f_private(){        return 12345;    }    public struct function f_public(){        local['s_test']={            'v_test':f_private()+9876        };        return local['s_test'];    }} Then a simple page that calls the component itself... <cfprocessingdirective pageEncoding="utf-8"><cfscript>    variables['c_test']=createObject('component','path.to.cfcFile');  &nbs

I'm looking for some help into resetting a session query variable in coldfusion.I'm currently implementing a lock account after 10 tries to a login form and I'm struggling to reset the number of failed tries once a user successfully logs in.public function getLoginFails(required String Username, required String App){ getLoginFailsQuery = new Query(); getLoginFailsQuery.setDatasource(this.datasource) getLoginFailsQuery.addParam(username) getLoginFailsQuery.addParam(ip) getLoginFailsQuery.addParam(application) getLoginFailsQuery.setSQL(data inserted into db) session.numFails = getloginFailsQuery.execute().getResult(); if(session.numFails.count < 10){ return session.numFails.count; }else if(session.numFails.count == 10){ run a query to update accountLocked to = 1; } } The above part works fine (I know some stuff is missing from the addparams() etc). It updates to 1 if 10 attempts and stores the tries in a session. session variable sh

Was going to try to use Coldfusion once again.  I used to use Dreamweaver to develop the apps but now it's cloud only.  NO THANKS!! Other option seems to be CFBuilder 2018 but free trial download page collect my info and then nothing.   Is there a better local solution for developing CF apps? AND IS COLDFUSION REALLY STILL ALIVE??? It seems DEAD to me!! Thanks

I have installed ColdFusion 2021 Update 2 throught the admin UI on two systems now. One development and one testing. In both cases, after installing the update I was greeted with the following message... After reinstalling the administrator UI as sugguested by the message, I login and can see that none of the other packages I had previously installed were still installed. I then had to manually install each of the packages again. These systems were built using the 32-bit zip installer on Windows Server 2019. The server was installed into C:\ColdFusion and the instance is C:\ColdFusion\cfusion. Once installed, the packages were all installed using the cfpm.bat file and restoring the contents of an export taken previously. The settings were then all restored using the cfsetup.bat file. Maybe something with the install location of C:\ColdFusion or me using the cfsetup.bat or cfpm.bat to configure the systems originally cause the update to do it? In any case. After the packa

Hello everyone, I have a cfm file that I use to upload a csv document every morning to a database. Recently I came across a problem when it was using the first name column A instead of the prefered name column F. The output file looks like this: <cffile action="write" file="#export_file#" output="First Name,Last Name,Email Id,Mailbox Id,Internal ID,Joint A/C holder,Company/Department,Address1,Address2,City,State,Postal code/ Zip Code,Country(ISO Code),Phone Number,Mobile,Recipient Type,Email Notification ?,SMS Notification ?,Active,Notes"/> My question is since I already have the csv set up with First Name A, Last name B etc is it possible for me to just change the code to this and it should apply that edit to show the joint AC first instead of the frist name during the upload?<cffile action="write" file="#export_file#" output="Joint A/C holder,Last Name,Email Id,Mailbox Id,Internal ID,First Name,Company/Department,Address1,Address2,City,State,Postal code/ Zip C

Hey Folks, We store timezone IDs from java.util.TimeZone, and now we want to use them with SQL Server (2019)'s AT TIMEZONE function. The problem is, the Java name for the timezone is not the same as the name SQL server wants.  For example, we store the timezone ID from Java 'Australia/Adelaide'. We can get the full name via java.util.TimeZone.getTimeZone('Australia/Adelaide').getDisplayName(), which returns 'Australian Central Standard Time (South Australia)'.  But.... SQL Server wants 'Australian Central Standard Time' and throws an error when using the string returned from Java. --- this works select datetime AT TIME ZONE 'Pacific Standard Time' AT TIME ZONE 'Australian Central Standard' AS datetime_TimeZone -- this fails select datetime AT TIME ZONE 'Pacific Standard Time' AT TIME ZONE 'Australian Central Standard Time (South Australia)' AS datetime_TimeZone Note, our dates are stored in PST and there is no way to easily change that now.

We run a website on a subdomain (mysite.abc.com) while other parties within our company operate various other websites on the main domain and other subdomains (www.abc.com, anothersite.abc.com, etc.). Our site is ColdFusion-based, as are a few of (but not all of) the other abc.com websites.We started to encounter recently a problem in which our users key their log in information into our log in page and click submit only to have the page refresh. No failed log in attempt, just a page refresh. I have seen the issue primarily in Firefox, but I believe this is just because our users perfer that browser. I am unable to recreate the problem on my end, but then again I rarely use Firefox and don't often visit the abc.com websites outside of our own.The only fix that seems to work is to clear the browser's cookies entirely, or if the user objects to that, just the cookies for "abc.com". Doing so lets the user log back into our website (again, at mysite.abc.com) fine. I do not have to clear th

I need to programmatically flatten AEM pdf's. I've searched the other posts here and do not see a solution to my need.  Per the other responses though, I want to add that I am NOT trying to lock down or protect the documents from editing by flattening them. We maintain a local master copy of the documents, so integrity is not the goal.  My need is simply to insure that the live data, watermarks, and signature images in the documents are visible in my end result when the user views the pdf in Chrome's built in pdf reader for example. I can achieve this manually by opening the pdf in Adobe Reader and printing to a pdf (going thru a print to pdf printer driver), but I need a programmatic solution do do this on the fly after my webpage has constructed the document and filled it with data and signatures that I capture.  cfpdf flatten function does not support LiveCycle and AEM documents... Thanks in advance!