ColdFusion

We have been getting frequent errors after installing Update 5 of ColdFusion 2018. The site serves web pages, but pressing F5 (to refresh the page) produces an Apache error page:  The isapi_redirect.log file entry corresponding to the failed request is:   [Wed Oct 23 17:18:44.903 2019] [13452:8640] [info] ajp_connection_tcp_get_message::jk_ajp_common.c (1425): (t1stdrdrci) can't receive the response header message from tomcat, tomcat (127.0.0.1:8030) has forced a connection close for socket 1464[Wed Oct 23 17:18:44.903 2019] [13452:8640] [error] ajp_get_reply::jk_ajp_common.c (2402): (t1stdrdrci) Tomcat is down or refused connection. No response has been sent to the client (yet)[Wed Oct 23 17:18:44.903 2019] [13452:8640] [error] ajp_service::jk_ajp_common.c (2975): (t1stdrdrci) sending request to tomcat failed (unrecoverable), (attempt=1)[Wed Oct 23 17:18:44.903 2019] [13452:8640] [error] HttpExtensionProc::jk_isapi_plugin.c (2739): service() failed with http error 502 &nbsp

Hello,I need help understanding how to check if a variable is defined when the json variable contains a # in its name as shown in the image:I tried using ## but it not correct:<cfif Isdefined('results.track.album.image[2].##text') AND #results.track.album.image[2].##text# NEQ ''> Suggestions? Thanks!Gary

Hi all, New to Coldfusion so posting for help!I have created a form for users to assign jobs to technicians. My form shows the outstanding jobs and below looped output of which tech in each area they can assign the jobs to. The idea is that they assign all the outstanding jobs to the selected tech.The form returns the output as two lists, such as:form.opArea: Area 4,Area 5form.tech: ME1,ME2How can I now update my oustanding jobs table, where the area is matched to the form.opArea and the form.tech name is inserted into the Technician column?Cheers!

ColdFusion 2016SQL Server (SQLEXPRESS01)See below- any help greatluy appreciated. A thorny issue. 

I have a couple of processes that are no longer working after  hotfix 16 for CF 2016.One uses cfpdf to prefill a form - shows a blank page and does not process<cfpdfform action="populate" source="#temppath#\#flist.file_template#"destination="#application.DocStoreDir##newfname#" overwrite="no" overwritedata="yes"><cfpdfformparam name="JMNU" value="#session.jmnu#"><cfpdfformparam name="todaydate" value="#todaydate#"></cfpdfform> The other uses DDX to build a pdf, the DDX is valid (I am also using IsDDX() to verify) and unchanged for a year, but it now always shows this now -The DDX specified is not valid. Any help would be appreciated

Adobe ColdFusion (2021 release) includes a few new array functions. In this post, I shall list (pun unintended!) the new functions and also include the CFFiddle links so that you can also try out the functions before productionizing them. ArrayPush Adds an element or an object to the end of an array. For more information, see ArrayPush. Syntax ArrayPush(array,value) Example 1 <cfscript> arr=[23,65,187,81,9] ArrayPush(array=arr,value=17) WriteOutput("The size of the array is now: " & arrayLen(arr)) </cfscript> Try in CFFiddle Example 2 <cfscript> arr=[{"id":101,"name":"John"}, {"id":102,"name":"Paul"}, {"id":103,"name":"George"} ] ArrayPush(arr,{"id":104,"name":"Ringo"}) WriteOutput("The size of the array is now: " & arrayLen(arr)) </cfscript> Try in CFFiddle ArrayPop Removes the last element from an array. For more information, see ArrayPop. Syntax ArrayPop(array) Example <cfscript> arr=[{"id":1

Hello,On our ERP system Workcube, we receive our pdf documents with Adobe ColdFusion. But the system has been running very slow or stalling for the last 2 weeks. What do you think is the problem.

I am trying to get cfexecute to work. From a command line within drive d\lame on a Windows server if I run:lame -b 128 "Abba - Dancing Queen.mp3" "Abba - Dancing Queen 128.mpe"The file converts as expected.From CF2016 if I run:<cfexecute name="d:\lame\lame.exe" arguments="-b 128 ""Abba - Dancing Queen.mp3"" ""Abba - Dancing Queen 128.mp3""" outputFile = "D:\lame\output.txt" >Nothing happens. Output.txt is blank and the file doesn't convert. Doesn't even seem like lame.exe even executes. Suggestions?  (insert lame song jokes here) Thanks, Gary

Operators define a quick way of implementing complex functionality with a short concise easy to use syntax. ColdFusion exposes multiple operators to ease out the complex operations. With this objective in mind, we have introduced the Spread and Rest Operators. Spread Operator Spread Operator: Spread Operator allows an Iterable Object(Array/Struct/String) to be expanded into individual elements. The Spread Operator is represented by Three Dots (…). Syntax Array Literals : […iterableObject, 2021, …"ColdFusion"]  Object Literals : clonedObject = {…Object} Function Calls : result = setFunctionValues(…iterableObject) Let’s start off with an example to show the Spread operator works. <cfscript> numbers = [1,2,3]; writeDump(sum( ...numbers )); function sum(required x,required y,required z) { return x + y + z; } </cfscript> Output 6 Try in CFFiddle The Spread syntax allows an iterable such as

Hi!I've got a simple Excel spreadsheet that allows user input to produce 15 or so cells with calculated values. The idea is to let a user change one or more values to see what impact those changes would make on the outputs. I can create the form to gather all the input. What I'd like is your thoughts on how to perform the calculations and display them. FWIW, all the input and display cells in Excel are named, and I would use the same names as vars in my CFML. Here's the inputs:The formulas are lengthy, because of the length of the names, but they use simple arithmetic. For instance, like: Average Income Per Hour  =Avg_Del_Inc_Ttl/(Hours_Per_Shift*Delivery_Percent_Time) I have some study to do. I'm just uncertain which path will get me to where I want to go. Do I need to employ cfscript?  Or can I just do the math on new variables whose values I pull from the form field values and other previously calculated variables? Not looking to have my code tweaked. I'm ju

Can anyone show me a simple Coldfusion code to loop to run a piece of code every second? Thank you so much.

Hi, I find myself in a ColdFusion 2018 environment on a Linux server behind an Apache server.I had issues and tried to track them down. It turned out my long running script is called over and over again.I call it manually through a webbrowser once. I see it initiates only one request through the browser's F12 tool.After I realized that requests multiply I searched the internet for possible solutions and found this thread on this site: https://coldfusion.adobe.com/2019/02/apache-crashes-serving-multiple-thread-requests-using-cf2018/ I eventually set heartbeat_interval to 0 and noticed no change. Only after httpd was restarted the "Segmentation fault" messages stopped. Now I start my long running script and enter some data into a database when it is started, including a timestamp. This is how I see that the script is started again and again every 6 minutes.I guess this is still a connector issue.Does this behaviour ring a bell? I like to believe some instance (connector, h

Good morning,       I am haveing an issue with a new ColdFusion 2018 Enterprise edition, installed on a CentOS 7 web server with Plesk Obsidian 18.0.28, not displaying ColdFusion tags at all when being access externally.  Internally on the web server, if I navigate using the 127.0.0.1:8500/Web-App-File-Path, all CF tags are displayed correctly.  I installed CF to use the built in web server which is what I'm thinking is the issue.  Do I need to setup ColdFusion to run on an external server, Apache, to get my web applications do run coldfusion tags externally?   I'm assuming since I already installed CF, I can run the Web Server Configuration tool to setup the external server?  Any suggestions would be greatly appreciated. -Daniel

ColdFusion 2016 Standard update 11 and IIS Server . Nessus scan  vulnerability on port 5500 Trace method enable. We add GET,POST in allow verb inside IIS Request Filter. But still we get vulnerability report. We remove add-on service (Jetty as report show Server: Jetty(9.4.2))

Hi,I wanted to try coldfusion for a project for a customer, also I downloaded and installed coldfusion trial for linux. But when  I start eclipse/coldfusion I got the following error message:"Standard Edition trial expired. Only the ColdFusion Builder Express Edition features are available now." It was supposed to be a 30 days trial not a 0 day 🙂ColdfusionBuilder start but of course not remote server and other stuffs needed for evaluation. I'm a little disapointed 

Has anyone gotten <cfhtmltopdf> to work with svg (or any other vector image formats). I have a require ment for very large vector pdfs that can be imported into CAD. I have tried using wkhtmltopdf but have had issues with it using local files on the server (on a stand alone work station it works great) and finding a way for it to push the completed pdf back to the user rather than doing a local save on the server. Thus if I could get <cfhtmltopdf> to work with the vector images it would be a godsend.

Hi allWe upgraded from CF11 to CF2018 recently.  Today we found a JavaScript error due to a difference in the way ColdFusion's ToScript() function returns its data. The ColdFusion structure going into the ToScript() function looks like this:<cfdump var=#allowedLevels# /> The above structure is passed to ToScript() as follows:  var #toScript(allowedLevels, "allowedLevels")# In CF11 the results look like this: var allowedLevels = new Object(); allowedLevels["1"] = new Array(); allowedLevels["1"][0] = "1"; allowedLevels["1"][1] = "2"; allowedLevels["2"] = new Array();  In CF2018 the results look like this: var allowedLevels = new Object(); allowedLevels["1"] = new Array(); allowedLevels["1"][0] = 1; allowedLevels["1"][1] = 2; allowedLevels["2"] = new Array(); As you can see, the values in the second dimension of the array are created as Strings in CF11 and as Integers in CF 2018. Can anyone offer the reason why thi

In case you hadn't heard, CentOS in it's current form is going early EOL in Dec 2021.  This is a tough blow to sysadmins that need an Enterprise class linux distro, but don't have the budget to license every server with RHEL.   What path does Adobe Coldfusion plan to take?  Will they support the new "CentOS Stream" OS, which is a sort of "staging" release seated between Fedora and RHEL.  Or will Coldfusion simply drop CentOS support completely.  Will Oracle Linux be officially supported instead?  It is another free of cost 100% binary compatible RHEL clone, similar to what CentOS was.  Just curious what path CF plans to take, that way we can plan our new buildout properly.Thanks, -Tony

ı want to make ;1-make a paging at form2-Show the EVENT_TO_POS the personel name not show integer number.(at sgl its nvachar but at employees id is integer)and search with dropdown list and show the data for departman.(for example at technical departmans notes)thats the code ;<cfparam name="attributes.keyword" default=""><cfparam name="attributes.start_date" default=""><cfparam name="attributes.finish_date" default=""><cfparam name="attributes.form_varmi" default=""><cfif len(attributes.start_date)><cf_date tarih="attributes.start_date"></cfif><cfif len(attributes.finish_date)><cf_date tarih="attributes.finish_date"></cfif><cfquery name="deneme" datasource="workcube_teknotel" >SELECTER.EVENT_RESULT,E.STARTDATE,E.FINISHDATE,E.EVENT_HEAD,E.EVENT_TO_POSFROMworkcube_teknotel.EVENT EINNER JOIN workcube_teknotel.workcube_teknotel.EVENT_CAT EC ON EC.EVENTCAT_ID = E.EVENTCAT_IDINNER JOIN workcube_teknotel.workcube_teknotel.

Unresponsive Server alert when .cfr file is called in Cold Fusion 9. The threads were killed by the monitor. Below is the stack trace. Could any experts point out the reason behind this server alert. Help much appreciated! "Information","scheduler-0","12/04/20","05:43:27",,"Aborting request <path to my cfr> handled by thread jrpp-9 Java stack: java.util.HashMap.get(HashMap.java:303) at net.sf.jasperreports.engine.xml.JRElementFactory.createObject(JRElementFactory.java:100) at org.apache.commons.digester.FactoryCreateRule.begin(FactoryCreateRule.java:391) at org.apache.commons.digester.Digester.startElement(Digester.java:1563) at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source) at org.apache.xerces.parsers.AbstractXMLDocumentParser.emptyElement(Unknown Source) at org.apache.xerces.impl.dtd.XMLDTDValidator.emptyElement(Unknown Source) at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanStartElement(Unknown Source) at org.apache.xerces.impl.XMLDocume

Where can i get a user manual for ColdFusion 2018, I'm a new user and would like to have a good start. You can share blogs or links that can help.

I know this is a long standing issue with ColdFusion, and there are many workarounds, but is there an easy way to get the query object to have the columns in the correct order without jumping through hoops? I haven't dealt with it before because I always had display outputs that were manually put together, but when I started using the spreadsheet functions -- spreadsheetAddrows() puts the data into a spreadsheet with the columns in the wrong order. Any easy fix?  Tom Muck

While running getAll is cfimap we get the following error when we hit an email with a blank body and an attachment.http://localhost:8002/test/email_imap_test.cfm?folder=problemStack Trace java.lang.ClassCastException: com.sun.mail.imap.IMAPMessage cannot be cast to javax.mail.internet.MimeBodyPart at coldfusion.mail.EmailTable.getAttachmentName(EmailTable.java:795) at coldfusion.mail.EmailTable.populate(EmailTable.java:309) at coldfusion.mail.IMapImpl.getMails(IMapImpl.java:377) at coldfusion.tagext.net.IMapTag$1.run(IMapTag.java:647) at java.security.AccessController.doPrivileged(Native Method) at coldfusion.tagext.net.IMapTag.handleRequest(IMapTag.java:643) at coldfusion.tagext.net.IMapTag.doEndTag(IMapTag.java:536) at cfemail_imap_test2ecfm1030837708.runPage(C:\Data\backofficeV2\www\test\email_imap_test.cfm:33) at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246) at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736) at coldfusion.tagext.lang.IncludeTa

I have a page which displays some iamges and everything works fine.  When I use cfhtmltopdf to generate a PDF of the page some of the images are rotated 90 deg and others are rotated 180.  Most of the images appear correct, but as I say, some are rotated.  I get the same results if I use cfdocument. I have tried using style="image-orientation:from-image;", but that made no difference. Does anyone have a suggestion of what I might try?  Thanks

Having just recently migrated my intranet to CF2018 Enterprise (from CF10), I'm finding some weird behavior in my Excel spreadsheets.  I use SpreadsheetNew("true") to create spreadsheets and then directions like this to format the rows and columns:<cfset SpreadsheetFormatRow(s,{bold='true'},1)><cfset SpreadsheetFormatColumn(s,{dataformat='##.00'},13)>This ends up producing my first row all in bold (correct), my 13th column formatted as _.00 (correct), but then my 13th column also ALL in bold.  Basically, any column I apply formatting to ends up extending the row formatting all the way down.And if I do it in reverse:<cfset SpreadsheetFormatColumn(s,{dataformat='##.00'},13)><cfset SpreadsheetFormatRow(s,{bold='true'},1)>That part works, but in specialized cases where I've tried to bold particular cells (to highlight data), that instruction is ignored:<cfset SpreadsheetFormatCell(s,{bold='true'},s.RowCount,13)>No cells in column 13 are bold except f