ColdFusion

Can anyone help me make this loop work.  This is how my structure is created: <cfset resData = ConvertXmlToStruct(gatewayResponse.Filecontent, StructNew())><cfset resTran = 'resData.Body.PosResponse.Ver1.0.Transaction.ReportBatchHistory.Details'><cfloop index="idx" from="1" to=#StructCount(resTran)# step="1">    more cf code....</cfloop> Here is the structure: I thank you in advance.

Apologize in advance for not seeing the obvious query to get the result set I need, but a picture is worth...Thanks for your advice.

Good morning,       I am having an issue when attempting to add a new or remove an existing web server via the ./wsconfig -i gui command on my CentOS 7 box.  I am getting a message when attempting to add or remove: "This web server is already configured by some other version of ColdFusion.".  This is a new install of ColdFusion 2018 and the server has never had another instance of ColdFusion installed.  However, I have had to un-installal/re-install ColdFusion on a couple of occasions.  I would really appreciate any insight on how I can fix this issue as I am currently testing some test web applications before moving production applications over to this new server. Daniel

Hi!I hope nobody minds, this is not strictly a Coldfusion issue. But I like my chances here better than in any of the other, more general forums. I'm trying to embed a video in a div on my site's homepage. Whether I use the iframe embed code that YouTube provides, or create it as an <object>, the video will play, embedded, within the div for all screen sizes but my iPhone screen. In that case, it zooms to fullscreen when the video starts, and I can click the control on the video as it's playing to force it back into the div. You can view/test this behavior at  https://test.aptmaps.us/index_video.cfm. This is just a borrowed video, so it doesn't relate to the site's content.  I've searched for an <iframe> or <object> method that might force the video to play "minimized," but I can't find anything. Anybody know the trick I'm missing? Thanks! The code I'm using is either of the two following below. FWIW, I'm incorporating bootstrap styling, so the div

Hello,We recently migrated our applications from ColdFusion 9 to ColdFusion 2016. One of our applications SFTPs files using cfftp tag.We noticed that CFFTP tag with ColdFusion 2016 no longer works. We worked with our internal IT team and the remote SFTP server team to resolve all issues with firewall. When we connect with WINSCP from our end, we were able to successfully connect to the remote server but when we use CFFTP from ColdFusion 2016, it seems stuck in the CFFTP tag. It does not even time out.Initially we thought it's the same code as CF9 and since CFFTP worked in CF9, it should work in CF 2016 but it did not. Later we realized that some of the tags were deprecated and we corrected that and ran the tests. But our efforts were in vain.We get this error message in the FTP log: "Information","ajp-nio-8016-exec-1","06/20/18","14:06:00","","Starting FTP request {action='open'}"We used the below code to connect:<cfftp action = "open"   connection = "myConnection1" &

Good morning,       I have a ColdFusion 2018 install on a Cent OS 7 server.  I have changed the document base via the server.xml file, and added the PreResources base for CFIDE and WEB-INF: <Context path="" docBase="/var/www/vhosts" WorkDir="/opt/coldfusion2018/cfusion/runtime/conf/Catalina/localhost/tmp" ><Resources><PreResources base="/opt/coldfusion2018/cfusion/wwwroot/CFIDE" className="org.apache.catalina.webresources.DirResourceSet" webAppMount="/CFIDE"/><PreResources base="/opt/coldfusion2018/cfusion/wwwroot/WEB-INF" className="org.apache.catalina.webresources.DirResourceSet" webAppMount="/WEB-INF"/></Resources></Context> After saving the sever.xml file, restarting coldfusion server, I am able to see my local web sites just fine on the browser, but the admin page is grayed out with a search bar.  I have done some initial research, and have tried editing the neo-runtime.xml file for the CFFormScriptScrc, a

We are going to migrate several servers from Coldfusion 2016 to 2018.During our tests we have the following problem:We use a SOAP webservice for communication between two servers.The caller of the webservice is still CF 2016, the called server was migrated to 2018. Since the migration the webservice throws the following error if the returned data contain boolean elements: <br> <pre>AxisFault faultCode: {http://schemas.xmlsoap.org/soap/envelope/}Server.userException faultSubcode: faultString: org.xml.sax.SAXException: No deserializer for {http://rpc.xml.coldfusion}CFBoolean faultActor: faultNode: faultDetail: {http://xml.apache.org/axis/}stackTrace:org.xml.sax.SAXException: No deserializer for {http://rpc.xml.coldfusion}CFBoolean at org.apache.axis.encoding.DeserializerImpl.onStartElement(DeserializerImpl.java:453) at org.apache.axis.encoding.DeserializerImpl.startElement(DeserializerImpl.java:393) at org.apache.axis.encoding.DeserializationContext.startElement(Deserial

This is about as mission critical as it gets in the US Federal World. PDFs generated by ColdFusion must be section 508 compliant. It looks like the biggest issue is tagged content. Has anyone successfully generated a tagged pdf in ColdFusion 11???

Greetings,This correct method is most likely staring me in the face, but my head hurts after 2 days of SQL headaches.Attempting to import GEDCOM (.ged) formated data to SQL Server is not easy.GEDCOM is supposed to be a universal data format for genealogical data (Ancestry etc. etc.).In order to get this data into a SQL DB, one needs to import .ged to .csv to .mdb & finally to SQL. GEDCOM columns, relationships and schema are suppsed to be standardized- not yet, by a long shot. My goal is a results query that matches spouses using the tables as they were contructed in GEDCOM.The "FamilyTable" contains FartherID & MotherID columns.The "NameTable" contains NameID , Surname, Given.The NameID = everyone in the DBProbably an easy answer to query both tables.Since there are 4000 records (people) in the DB, the output I'm looking for would be table rows (2000) with Father-surname-given, Mother-surname-given.I thought a junction table would solve issues easily, but when I created it, it

I am trying to use the Google QR code generator and I cannot read the response. If you go here: https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=123456 it will produce a PNG image of a QR code with 123456 in its message.  When I try to read the filecontent of a cfhttp response I get this: ‰PNG  IHDR±±KË’bKGDÿÿÿ ½§“ÒIDATxœíÝAnÛ0@Áºèý¯œ.² ž7*ÃOËéÌ>²<fd’����_ðÅïWß·£ J”&(MPš 4Ai‚Ò¥ J”&(MPš 4Ai‚Ò¥ J”&(MPš 4Ai‚ú³ñZ�ÇcãÕþÕ•ÅKÏwøüWWžbí¯æì]¸eœ 4Ai‚Ò¥ jç¼ãÙÜFW¾ç=ÅkŸý;Œ”&(MPš 4AÍÎ;ž­}g>¹Û•wk÷sÿgÿdœ 4Ai‚Ò¥ êô¼ã¤µ_Cíše¼/㥠J”&(MP?yÞ±6ƒ˜{ßñ.Œ”&(MPš 4A�žwÜÿûÜê‰û?û'㥠J”&(MP³óŽ×îòtÅ®®®\ù]'(MPš 4Ai‚z¼Ë?áxs±Æ8Ai‚Ò¥ JÔéó;v­ž˜;eãµ{UÍÝáuÆ J”&(MPš NŸß±k�öÜÜd—“ÏåÜ@fi‚Ò¥ JÔÎyÇÜʈ]Wž{—±ëÊwØMË8Ai‚Ò¥ JÔìúŽ]3ˆ]o&#

GreetingsI have a text string containing the last names of a people (5000+ in DB), but in this case, alias names follow delimited by spaces. French last names have "dit" (Smith dit Smythe dit Smitt) names.I would like to retrieve only the first (last) name to use in a dynamic query.so,<cfquery name="trim_last_name" datasource="#Request.BaseDSN#">SELECT ged_lastnameFROM ged_main</cfquery><cfset clean_last_name = listfirst(trim_last_name.ged_lastname, " ")> <cfoutput query="trim_last_name"><cfquery name="match_carignan_name" datasource="#Request.BaseDSN#">SELECT *FROM carignan_main, ged_mainWHERE carignan_lname LIKE #clean_last_name#AND carignan_fname LIKE ged_firstnameORDER BY clean_last_name ASC</cfquery></cfoutput>This is wrong, of course, and the result shows only one last name, which actually does not have additional "dit" last names.Error Executing Database Query.[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column nameThere is

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))