ColdFusion

After migrating a CF11 application to CF2018 I've been seeing the occasional error:Error Executing Database Query. HOUR_OF_DAY: 2 -> 3 This error occurs when trying to query a database record that contains an invalid datetime field due to Daylight Savings Time (DST). For example, using the following timezone data:/usr/share/zoneinfo/America/New_York Sun Mar 11 06:59:59 2018 UT = Sun Mar 11 01:59:59 2018 EST isdst=0 gmtoff=-18000 /usr/share/zoneinfo/America/New_York Sun Mar 11 07:00:00 2018 UT = Sun Mar 11 03:00:00 2018 EDT isdst=1 gmtoff=-14400 /usr/share/zoneinfo/America/New_York Sun Nov 4 05:59:59 2018 UT = Sun Nov 4 01:59:59 2018 EDT isdst=1 gmtoff=-14400 /usr/share/zoneinfo/America/New_York Sun Nov 4 06:00:00 2018 UT = Sun Nov 4 01:00:00 2018 EST isdst=0 gmtoff=-18000A record with a datetime stamp of 2018-03-11 02:15:00 will throw this error because that time doesn't exist due to DST. It seems this is due to underlying changes with upgrading from Java 8 to

If anyone has one that they are interested in parting with, please PM.Thanks in advance.

Good morning everyone. I have a question regarding the lifetime of application-scoped variables. I am migrating to Application.cfc and in my application global variables have been set (in old application.cfm) The global variables I set in the onApplicationStart method Example: <cfset application.ds = 'myDatabase'> <cfset application.table1 = 'table.table1> That is, database table name and database name. But I found problems with these variables  <cfset application.URL_ARQCLI = "http: //" & # Server_Name # & ":" & # server_port # & "/ aseng / attachment / counterclient /"> Our system has the local network access url and the remote access url. When we enter the remote access url the images are not found. Because the variable was set in onApplicationStart, why didn't you save the reference server_name: server_port? In my .cfm file I look for the image with the tag <image src='# application.application.URL_ARQCLI ## myImage #> To work a

Hi, is there a way to select a row range from query of query. I mean like an alternative for LIMIT and OFFSET in regular MySQL queries.

I inherited a program that I've had to modify and I am stuck on adding conditions to.  I have a very long <cfset> statement that is made up of a table and several divs.  <td style="border-bottom: thin solid black"> <div align="left" class="HeadingTwo"> #DollarFormat(Session.WorkOrderReceipt.amount)# #Session.WorkOrderReceipt.Instrument# #Session.WorkOrderReceipt.CheckNumber# </div> </td>This div shows the dollar amount on the receipt and if it's paid with a check then it shows that and then the check number, but since we've added credit/debit cards it would need to show that information as well.  So basically, if #Session.WorkOrderReceipt.instrument eq check# then #Session.WorkOrderReceipt.CheckNumber# would be correct, but if #Session.WorkOrderReceipt.Instrument eq creditDebitCard# then #Session.WorkOrderReceipt.creditDebitNumber# would be correct.  There is another div that would basically be the same with t

Basically i have few tables in MySql and im trying to create an array mixed with data from diferrent tables. I'm using AJAX to get the data from CFC. I've tried using different ajax requests to get the data from different tables but thats making my code very long. First example table - user_info_tb--------------------------------------USER_ID | FULL_NAME | ----------------------------------------      2              Jack      3             John      4             Jamie Second example table - post_tb --------------------------------------POST_ID | POSTED BY (USER_ID FROM THE FIRST TABLE) | | TEXT |--------------------------------------------------------------------------------------------------  &

Dear community, We are still using CF11, which is now in Extended Support.  Obviously, we want to migrate to CF2016 or CF2018, but this is a major effort and we do not have the capacity to do it right now. To precisely assess the risk we are currently exposed to, I need to know whether CF11, Update19 is vulnerable to the following vulnerabilities: - CVE-2019-8072 - CVE-2019-8073 - CVE-2019-8074 Any answer will be deeply appreciated. Kind Regards, 

I followed the steps from Ray Camden's website to use the data import handlers for indexing a collection  http://www.raymondcamden.com/index.cfm/2012/11/1/Some-tips-for-working-with-Data-Import-Handlers-in-ColdFusion-10#c5FB2381E-E361-4453-99BCFB2F2097BF62.  My collection is being populated but when I try to use cfsearch to return results it comes back empty if I add a criteria to the search.  Without a criteria results are returned.  Here is the cfsearch tag I am using - has anyone else had similar issue and if so how did you resolve it?<cfsearch           name = "mySearch"     collection = "FORD OEM"                               maxRows="200"                    &nbs

Hi I have purchased a Coldfusion 2018 standard licence. I would like to use it on a Coldfusion 2016 server. When installing the CF 2016 server the 2018 serial number is not accepted. Is there a procedure to use a 2018 serial number on a 2016 instance? Cheers Daryl

ı want to select province and then which ı selected its county wıll come to dropdown list.ıam wrıttıng thıs code.ıts not workıng.can someone help me whats wrong?or are there any dıfferent code for make thıs same code in project</div></div><div class="form-group" id="item-city_id"><label class="col col-4 col-xs-12"><cf_get_lang_main no='559.Şehir'></label><div class="col col-8 col-xs-12"><select name="city_id" id="city_id" style="width:150px;" onchange="LoadCounty(this.value,'county_id','telcod')"><option value=""><cf_get_lang_main no='322.Seçiniz'></option><cfquery name="GET_CITY" datasource="#DSN#">SELECT CITY_ID,CITY_NAME FROM SETUP_CITY</cfquery><cfoutput query="GET_CITY"><option value="#city_id#" <cfif get_company.city eq city_id>selected</cfif>>#city_name#</option></cfoutput></select></div></div><div class="form-group" id="item-county_id"><la

Does anyone know a way to globally disable the use of a (#) sign by the end user?  I have created code to replace the (#) sign on formfields that users would likely use a (#) sign, but that would be a very timeconsuming task for every text box on the site.  Would love any ideas or suggestions from anyone who may have a solution.

I am getting this error, while converting few random documents to pdf.  error: java.lang.NoClassDefFoundError: com/google/common/cache/CacheLoader at coldfusion.runtime.StructBean.(StructBean.java:79) This issue is occuring with random documents and for 50% of the documents code works fine.I am not sure why this error is thrown. Can someone please help me figure this out. Thanks

I am having to manually change my file extensions when saving in photoshop.  For example if I am trying to save a psd file as a jpeg I click save as then jpeg but the top (where you see the file name and extension) does not change and I have to manually type jpeg in there.  This is extremely furstrating becuase I am constnatnly changing file extensions.  Please someone have a fix for this.

Currently I'm able to access CF2016 admin console on the server where its insatlled as per default url.How can I access Coldfusion2016 admin console from any of the server. In whihc file I have to make the chnages. Please prooovide your inputs.  

If you have forgotten your password and are unable to log in to ColdFusion Administrator, follow the steps below: 1. As an Administrator, launch the command prompt. 2. Enter the following commands: C:\>cd coldfusion2018 C:\>ColdFusion2018>cd cfusion C:\>ColdFusion2018\cfusion>cd bin C:\>ColdFusion2018\cfusion\bin>passwordreset.bat 3. Enter the following: 1: For changing Admin Password 2: For changing Admin Component (jetty) 4. Follow the on-screen prompts. 5. Restart ColdFusion service.

when return implicitly declared array from inside a CFIF with a CFELSE will cause an incorrect return value.in the code below, function test4 will return 0,0 on CF2016 with applied update 12. other server with applied update 6 returns 2,0. function test3 is identical except it has no else statement, works the same on both. <!--- works as expected ---> <cffunction name="test3"> <cfargument name="a1" type="string" required="true"> <cfset var x = 0> <cfset var y = 0> <cfif a1 gt 1> <cfset x += a1> <cfreturn [ x, y, "", "" ]> </cfif> <cfreturn [ x, y, "", "" ]> </cffunction> <!--- doesnt work ---> <cffunction name="test4"> <cfargument name="a1" type="string" required="true"> <cfset var x = 0> <cfset var y = 0> <cfif a1 gt 1> <cfset x += a1> <cfreturn [ x, y, "", "" ]> <cfelse>

I must not be using the right search terms because this has to have been asked before.   I missed a hotfix release because i was not paying attention in april.  do i need to apply the april hotfix AND the june/sept one or does the september one supercede June and april? I am not sure why this might change between versions and that's why i didn't specify a coldfusion server, but if it does, I'm still in CF 11.  I know it's out of support.  We are still trying to get approval to upgrade the server to either 2016 or 2018, but at the moment, i just need to get patches up to date with hf 19 and i'm wondering if i need to install 18 first, or if 19 will supercede 18. Thanks

We are running CF2018 Update 3 with external web server (Apache) and we are getting ready to update the server to Update 5. I understand that I’ll have to upgrade to Update 4 before we go to 5. I was reading through documentation (https://helpx.adobe.com/coldfusion/kb/coldfusion-2018-update-5.html#Connectorconfiguration) and it says that we have to “Recreate Connector”.After upgrading to Update 5 I ran the connector and got message that it was already configured:[root@server1]# ./wsconfig -ws Apache -bin /usr/sbin/httpd -script /usr/sbin/apachectl -dir /etc/httpd/conf/ -vcommand line: -ws Apache -bin /usr/sbin/httpd -script /usr/sbin/apachectl -dir /etc/httpd/conf/ -v  This web server is already configured for ColdFusion. Do we have to run wsconfig just to make sure mod_jk.so gets updated? thanks

formrequiredexample.cfm: <cfsilent> <cfparam name="form.userName" default="" /> <cfparam name="form.favcolFULL" default="" /> <cfparam name="form.visitFULL" default="" /> <cfparam name="form.age" default="" /> <cfparam name="form.height" default="" /> </cfsilent><!DOCTYPE HTML> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Required Form Field Example</title> <style> #thisTable{width: 500px;} .leftTD{width: 200px; text-align: right; vertical-align: top;} .rightTD{width: 300px; text-align: left; vertical-align: top;} input[type='text'], select{ width: 95%; } </style> </head> <body> <cfoutput> <form id="thisForm" name="thisForm"> <table id="thisTable"> <tr> <td class="leftTD">Name: *</td> <td class="rightTD"><input type="text" id="userName" name="use

ı want to some data input to my programs.But some fıle ,users must enter data.for exp name.how can ı do it wıth coldfusıon code? Thank u.

UPDATE (10/10/2019): We’ve have now included binaries for 32-bit versions of ColdFusion. The locations are also updated.   Users who had installed Update 5 of ColdFusion (2018 release) and Update 12 of ColdFusion (2016 release) encountered an error after they'd tried accessing the ColdFusion Administrator using their connector port. The issue was reported by a few users that it might impact all their websites. This issue appears if and only if you access the ColdFusion Administrator using the web server port. We strongly recommend that you access ColdFusion Administrator only using the internal web server port (port 8500) without exposing the port externally.   However, if you still want to use the connector port, use these patches provided for your version of ColdFusion: ColdFusion (2018 release) ColdFusion (2016 release)   Unzip the files to any location in your computer. To apply the patch, follow the steps below:   IIS Navigate to [CF Home]\config\wsconf

Hello community. I have to run a script to retrieve emails from an IMAP account.Everything is working as expected using the CFIMAP tag.However, since emails are not regularly deleted from this account, it is taking very long.Is there a way to limit my "getall" action to unseen emails only? Thank you in advance.

Hi there,I use the url attribute in cfchart for drill down.  Drill down doesn't work if there is a stand alone data point in the line series. Here is a simple example:   ThanksCF2018 update 4

I an using Cold Fusion 2016 Enterprise Edition on a Microsoft Windows 2016 server and IIS.   We do alot of file transfers to printers that are running Solaris Unix via SFTP using the CFFTP secure="yes" option.  On certains system the SFTP portion hangs infinitely, or errros out with a auth timeout.   This only occurs when Cold Fusion is running with a AD domain account, and does not occur if I run Cold Fusion with the local system account.   I've tried using both Key/passphease and username/password to login. Has anyone come across this issue before, and is there a fix?   I am currently running Cold Fusion 2016 using the local system account however the security implementaiton guides I need to follow state that I should be running the service with  domain account. CFFTP Code using: <cfftp action="open" server="#ip#" connection="foo" secure="yes" username="#username

Hello, I want to connect CF2018 with the Outlook installed on my CF server, because i want to save the send email as an .MSG file. But i get following error on init the object. <cfobject type=".NET" name="objOutlook" class="Microsoft.Office.Interop.Outlook"> Class Microsoft.Office.Interop.Outlook not found in the specified assembly list.The assembly that contains the class must be provided to the assembly attribute. Any help? thx