ColdFusion

I have a report that compares one figure against the total of several figures and compares them. If they are the same, they print in black. If the one figure is more than the total of the several figures, the output prints in red. If the one figure is less than the total of the several figures, the output prints in green. (The CF file is attached as a docx.) The report currently outputs 49 pairs of figures. Eight of those pairs, in all cases of which the figures are the same, print in the wrong colors, three in red and five in green. The other 41 pairs, comprising  several in all three possibilities, print correctly. Any ideas? Thanks.  -Dale

Hi, I am not being able to use LIMIT and OFFSET in query of queries. queryExecute("SELECT * FROM baseQueryResult(obtained after querying database) WHERE CONDITIONS LIMIT 10 OFFSET 0",{},{dbType="query"}) returns Database exception.

Hi All,Trying to do a single sign on from my site to another site using JWT.Found this library:https://github.com/bennadel/JSONWebTokens.cfcMy code from my cfm page: <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "<a href="<a href="http://www.w3.org/TR/html4/loose.dtd" target="_blank">http://www.w3.org/TR/html4/loose.dtd</a>" target="_blank"><a href="http://www.w3.org/TR/html4/loose.dtd</a" target="_blank">http://www.w3.org/TR/html4/loose.dtd</a</a>>"> <html> <head> <title>Login</title> <cfscript> payload = { userId: "myUser", userDir: "LDIR" }; jwt = new cfcDir.JsonWebTokens().createClient("HS256","./cfcDir/server.pem", "./cfcDir/server_key.pem"); token = jwt.encode( payload ); </cfscript> <cfheader name="X-Qlik-Session-jwt" value="#token#"> <cflocation url="<a href="<a href="https://myDomain.net/jwt/hub/" target="_blank">https://m

I must take time format like that  : YYYYMMDDHH24MM SS How can ı do it at coldfusıon code? Help please 😞

I have installed cold fusion 2018 on CentOS7, as Server Configuration (Production Profile + Secure Profile) with default Sub-components and servlets, using default install dir, and default Built-In Web Server Port.  I followed this guide here, installing on a fresh new clean server / instance of linux.https://www.adobe.com/content/dam/acom/en/products/coldfusion/pdfs/coldfusion-2018-lockdown-guide.pdf When I got to section 5.4 I could not get the SSH tunnel to work. When I run the following command:[root@server ~]# systemctl status cf2018.service -l I get the following result:● cf2018.service - Adobe ColdFusion 2018 Loaded: loaded (/etc/systemd/system/cf2018.service; enabled; vendor preset: disabled) Active: active (exited) since Mon 2019-09-30 10:12:16 HKT; 1 day 4h ago Main PID: 2285 (code=exited, status=0/SUCCESS) CGroup: /system.slice/cf2018.service Sep 30 10:12:16 server.ewc-asia.com systemd[1]: Started Adobe ColdFusion 2018. Sep 30 10:12:16 ser

I'm setting up CF 2018 (with Update 5) and am having an issue - it seems that "Enable Null Support" option in CF Admin does nothing.  I have some API results that can return null values - eg; json {"FirstName":"Fred","LastName":null, etc} and when I cfdump the struct it has "undefined" as the value for LastName (after doing a deserializejson()). In ColdFusion 9 (which I'm porting over to 2018), the value for LastName shows as "null". My issue is that in CF2018 when I try and access this variable it throws an error "Variable LastName is undefined". It doesn't seem to make a difference if you check the box for "Enable Null Support" or not in CF Admin. I've tried selecting it, un-selecting it, even restarting CF after each update. Is this a bug? I'm using CF2018 with Update 5 (version 2018.0.05.315699). Any ideas? 

Hello, all, Look.. I get it.. I've been a developer for 19 years, now.  I know that to a computer, 1 = true = yes, they are all the same from a boolean point of view.  But from a string perspective, they are not.  So, when I create a switch/case statement to evaluate a URL parameter, <cfcase value="true,yes" delimiters=","> should be valid.  I should not get an error message that "cfswitch has a duplicate cfcase for value 1.0".  A user might use ?myparam=true or ?myparam=yes.  (This is to trigger an update event, btw.) And what is with the "Email me when someone replies" defaulting to checked???  I went into settings to disable this and it's apparently not working.  I'm sick and tired of getting home from work to see five hundred emails from Adobe telling me that someone replied to a thread I'm participating in. Gads, I miss the days of Jive. V/r, ^ _ ^

I'm seeing this message in my application log after submitting a form with blank "required" fields. This is happening on a new install of CF11 with lockdown guide measures taken. Can someone tell me how to fix it?  "Error","ajp-bio-8014-exec-2","09/26/19","22:12:03",,"Exception thrown by error-handling template:""Error","ajp-bio-8014-exec-2","09/26/19","22:12:03",,"File not found: drive:\C11\cfusion\wwwroot\WEB-INF\exception\coldfusion\filter\FormValidationException.cfm The specific sequence of files included or processed is: drive:\C11\cfusion\wwwroot\WEB-INF\exception\coldfusion\filter\FormValidationException.cfm''  Thanks,S

I have been trying to download the Adobe ColdFusion trial. It keeps on taking me to the form (https://www.adobe.com/products/coldfusion/download-trial/try.html) and then just sends me to this page, https://www.adobe.com/products/coldfusion/download-trial/get-started.html, without a download. If anyone could help that would be awesome.  

Hi All,   We have released an update for ColdFusion 2016 and ColdFusion 2018 with 90 external bug fixes, Language Enhancements and many more. We now have support for Java 12 and MySQL 8, this release also has security fix.   Topic Link ColdFusion 2018 Updates Release Notes https://helpx.adobe.com/coldfusion/release-note/coldfusion-2018-updates-release-notes.html ColdFusion 2018 release Update 5 Tech Note https://helpx.adobe.com/coldfusion/kb/coldfusion-2018-update-5.html Bugs fixed in ColdFusion 2018 release Update 5 https://helpx.adobe.com/coldfusion/kb/bugs-fixed-coldfusion-2018-update-5.html ColdFusion 2016 Update Release Notes https://helpx.adobe.com/coldfusion/release-note/coldfusion-2016-updates-release-notes.html ColdFusion 2016 Update 12 Tech Note https://helpx.adobe.com/coldfusion/kb/coldfusion-2016-update-12.html Bugs fixed in ColdFusion 2016 release Update 12           &n

sample code :<cfscript>    myQuery = queryNew("id,name,amount","Integer,Varchar,Integer",                 [                         {id=1,name="One",amount=15},                         {id=2,name="Two",amount=18},                         {id=3,name="Three",amount=32}                 ]);     writeOutput("The new query is:");    writeDump(myQuery);</cfscri

[UPDATE - The following is a very long thread.  If you tire of reading all the updates, see our update below from Sep 28, 2019 for the resolution.]   The compilation below is the entire conversation Adobe deleted (how convenient) when moving to the new forums.  Unfortunately, the original links to those how posted are not live, but you will be able to read the entire conversation.  If you want to see the original post in the old Adobe forums, here it is - not sure how long the link will live. But the text of that original post and the many replies to it are offered below:   Original Post Checking in to see if anyone else out there is dealing with Adobe bait and switch based on havingan application developed in CF that other businesses use? We were sent a questionnaire earlierthis year under the guise of getting a "better deal" for our existing 3 perpetual Enterprise licenses.As a result of what was clearly a bait and switch tactic, Adobe is now claiming we are

Every time I restart the coldfusion serives I have to go back into the dsn setting for each datasource and retype the password also a deleted dsn keeps coming back. Can anyone help , this is getting anoying.

I'm trying to use ORM to CRUD some change logs. I already have a pretty simple table structure that would require 2 joins. I've created entities for both of the joined objects. I'd like to fetch change logs with these objects populated. I already have the tables. I don't have or want any official foreign keys setup; I just use the "_fk" convention to indicate it references the PK of another table. change_logs --------------- change_log_id change_log_type_id_fk message user_id_fk change_log_types ---------- change_log_type_id name users ---------- user_id name ------------------component entityname="ChangeLog" accessors="true" persistent="true" table="change_logs" { property name="id" type="numeric" column="change_log_id" fieldtype="id" generator="native"; property name="message" type="string"; property name="type" column="change_log_type_id_fk" cfc="ChangeLogType"; property name="user" column="user_id_fk" cfc="User"; } component entityname="ChangeLog

This is an age old question, and we're currently using an age old version (CF9), upgrading soon.  I'm a developer of 25 years but have only been using CF for about 8 mos. I have to get data from two different datasources and join them together.  Outer join, of course.  I've read many topics on this.  I had originally done this by looping at a query of the main table and selecting from a query from second table.  My supervisor & former CF programmer doesn't want us to use a loop/select. They first suggested a UNION of the two tables but that's not giving me the results I need. I thought of selecting from one table then inserting them into a temp table on the second datasource but when I try to do an insert into the temp table then selecting from the query of the first table, CF tells me I can't do that either with error "Executing the SQL statement is not allowed."Any suggestions on correct ways to outer join tables from two datasources w

I'm having an issue with uploading or looping through the the file names of my images to my database table.I am able to select various images and upload the selected image on my local machine to a specific folder that I designate. After the image files are put into my folder, I am having some difficulties because I want to insert the file names of the images that I just inserted into my folder, into my database. I'm trying to use the cffile parameters to do that.My question: Being that it is multiple files being uploaded at once, do I need to do a cfloop on a  cfquery insert in order to capture and insert the names into my database? My attempt at the code is below. The upload work just fine. But It chokes out at the insert portion. What do you think could be the issue?<cfparam name="form.fileUpload3" default=""><cfif len(trim(form.fileUpload3))><cffile action="uploadall" fileField="fileUpload3" destination="#cookie.c.webpathmultipleimages#" accept = "image/jpeg

Has anyone been able to inject a Docker Swarm secret into a Docker Compose file's environmental settings?  So in the documentation they have "serial" as an environmental variable we can pass in via either an env_file or just directly into the compose file (or just putting it into the docker run commnand). The issue is I can't use a Swarm secret and I don't see a way to inject it via the setupColdFusion.cfm file they want us to run as I don't see that capability via the Admin API. Has anyone been able to avoid putting in your serial/license key in plain text on a Docker Compose or Environment file?  I've tried injecting it after runtime but it doesn't seem to work.  I am a bit of a Unix novice so really all I've tried is setting the environmental variable named serial and restarting CF.  I'm curious if anyone has had any success. Thanks!

I am trying to build a query where the end-user can search a field in the table for multiple keywords. I've tried several examples I found by searching SQL forums yet I keep getting Incorrect syntax near 'keyword*'. Does CF do it differently? Something Like this....<cfif isdefined("form.search1")><cfquery name="Messages" datasource="somedatasource">Select *From SomeTableWhere AffiliateID = #Session.AffiliateID# AND Contains(messagefile, '#Form.Search1#*')<cfif isdefined("form.search2")>AND Contains(messagefile, '#Form.Search2#*')</cfif><cfif isdefined("form.search3")>AND Contains(messagefile, '#Form.Search3#*')</cfif>Order by SomeField</cfquery></cfif> Greatly appreciate any help...

The ColdFusion Summit is a confluence of everything in the realm of web applications. If you develop web applications, this is the place to be. For designers, developers, strategists and thought leaders, the ColdFusion Summit provides the perfect forum to exchange ideas, inspiration and experiences. Be there and learn from the experts! The Mirage, Las Vegas it is on Oct 1 and 2, 2019. Register today for the ColdFusion Summit!

i'm getting no images at all whenever is try to display images to the browser from a folder from my local computer. Below is the code that i'm using: <cfset webpath2 = "C:\ColdFusion2016\cfusion\wwwroot\The_Resolving_Door\photos\#cookie.communityID#\"><!---the #cookie.communityID# is the name of the folder that matches the ID of the current saved cookie---><!---output-images---><cfdirectory action="LIST" directory="#getDirectoryFromPath(expandPath('*\photos\#cookie.communityID#\*'))#" filter="*.JPG" name="dir"><cfloop query="dir"><cfif dir.type is "file"><!--- <div> ---><cfoutput><a href="#dir.name#">   <img src="#dir.name#" width="50"></a></cfoutput><!--- </div> ---></cfif></cfloop> Could i be doing something in error as a reason for my images not displaying. The images are in the actual folder but nothing is displaying? Thanks for any insight...  

Hello, all, Trying to index a SOLR collection from a database query.  If I set the action to FULLIMPORT, it tells me that I have to use FULL-IMPORT.  If I use FULL-IMPORT, it tells me I have to use FULLIMPORT.  WTF?? Anyhoo.. I've submitted a bug to Tracker.  Anyone else run across this? V/r, ^ _ ^

Hi. I output the file sizes from a <cfdirectory> list that I use, and it shows in bytes. Is there a way to make it so that if it is over 1024 bytes it shows 1KB (or 1.2, whatever the appropriate size is) and in MB if over 1024 KB, and so on... The files will get large, and I don't want to be outputting extremely large file sizes.Thanks!

How to take an integer with no leading zeros and display it with leading zeros? Thank you in advance.

We are currently trying to migrate our PROD environment from CF8 to CF10.  Everytime we try and add a CF10 instance into our cluster... the following error starts happening:java.sql.SQLException: Lock wait timeout exceeded; try restarting transactionHere are some environment specifics:Old Server:Coldfusion 8CentOS 5.x (32 bit)MySQL 5.084New Server:Coldfusion 10CentOS 6.4 (64 bit)MySQL 5.084Is this possibly driver related? Unchecking "Maintain Connections" seems to fix the issue, but I have read that unchecking that can cause more harm than good.

I created pie chart in cold fusion 2018 and add the property show3d="yes".When show3d="yes" then url link is not working but in show3d="no" case url link is working properly.I need to create 3D pie chart.My sample code is <cfchart   show3d="yes" xAxisTitle="Department" yAxisTitle="Salary Average" url="https://www.google.com/" >     <cfchartseries type="pie" seriesLabel="Average Salaries by Department">         <cfchartData item="Finance" value="75000">         <cfchartData item="Sales" value="120000">         <cfchartData item="IT" value="83000">         <cfchartData item="Facilities" value="45000">     </cfchartseries> </cfchart>Please tell me what I am doing wrong.