ColdFusion

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

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