ColdFusion

Hello everyone, We are getting an error As shown below on our Dev server Error Occurred While Processing Request. Please try again.Error Executing Database Query. [Macromedia][Oracle JDBC Driver]A username and password are required if the connection option 'authenticationMethod' is specified with a value of 'userIDPassword'.The error occurred on line 28.  Whereas on our Prod server we are getting an error message as shown below 500 - Internal server error.There is a problem with the resource you are looking for, and it cannot be displayed. We would like the error message to be the same as that displayed on Dev server on our Prod server also. I have looked at the authentication.cfm file but could not see anything which can help me.We think this is due to an incorrect setting in the Cold Fusion Administrator , Can someone help us with this issue ?

Hello, I am attempting to backup and restore my datastore by copying the datastore/dump.rdb file for one server to another.  Once copied I am not seeing any data from the source location.  Are there other files / data that need to be copied?   My goal is to backup and restore my API's from one server to another.  I am assuming that copying the datastore will move my API's from server to server?  Any suggestions or pointing me to some documentaion is appreciated.   HisEdNess

We have installed ColdFusion enterprise 2018 new installation and we are getting this error   Calling LoadLibraryEx on ISAPI filter "X:\ColdFusion2018\config\wsconfig\1\isapi_redirect.dll" failed

I have an issue with a CFIF statement that is driving me nuts. I'm sure it will end up being something stupid, but for now I need some help.  Here is the code:<cfoutput query="get_procedures"><tr><td>#procedureid#</td><td><a href='new-procedure-page-1/?id=#procedureid#'>#procedurename#</a></td><td align="center">#proceduretypename#</td><td align="center">#name#</td><td align="center"></td><td align="center">#statusname#</td><td><img alt="" src="/#application.environment#/assets/Image/copy_24px.png" style="cursor:pointer;" title="Copy Procedure" /><img alt="" src="/#application.environment#/assets/Image/renew_24px.png" style="cursor:pointer;" title="Renew Procedure" /><cfif #statusname# neq "Archived">#statusname#<a href="archive-procedure/?id=#procedureid#"><img alt="" src="/#application.environment#/assets/Image/archive_24px.png" style="cursor:poin

Hi,I am doing the Update 12 on my Coldfusion 2016 Enterprise Edition using this command below:sudo /usr/java/latest/jre/bin/java -jar hotfix-012-315717.jar and I am having Fatal Error below:Moving files failed: Status: FATAL ERROR Additional Notes: FATAL ERROR - Could not move the file /opt/coldfusion2016/cfusion/jetty/lib to the backup location /opt/coldfusion2016/cfusion/hf-updates/hf-2016-00012-315717/backup/jetty/lib I don't have any idea what's wrong. Did anybody have this experience? Should I try to run the update 12 again? Thank you. OS: Centos 7 (3.10.0-1062.1.2.el7.x86_64)Java version: 1.8.0_221    

The cURL (cfhttp) command in Coldfusion-10 worked, but after migrating the same code to Coldfusion-2018 is not working. I use the same Token value in CF-10 and CF-2018!!! I have the below code working on CF10:<cfset structContainer = { "container": { "number": "ABCD123456", "shipping_line": "ABCD", "sandbox_url": "http://api.myhost.com/" } }/> <cfset structJson = serializeJSON(structContainer) />cfhttp url="https://customerurl/api/v1/" method="post" result="structResult" username="myaccount@myhost.com" password="12345"> <cfhttpparam type="header" name="Content-Type" value="application/json"> <cfhttpparam type="header" name="Authorization" value="Token token=x1x2x3x4x5x6"> <cfhttpparam type="header" name="X-ApiVersion" value="1.0"> <cfhttpparam type="header" name="Accept" value="*/*"> <cfhttpparam type="body" encoded="false" value="#trim(structJson)#"> </cf

https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-c/cfclientsettings.html CFCLIENTSETTINGS produces an error in CF 2018 when HTML/CFML is added to the page.This error does not appear in CF2016."If you view the source of the page within your browser, you'll notice that the double quotations on line #17 are not properly escaped."See attached:

Is there a way to configure CF2018 to use smtp.gmail.com and port 587 and TLS checkbox set when 2-step authentication is applied to the gmail account being used? I'm not seeing any posts on this topic.  I'm using Commandbox environment for my local dev environment and configured it to load Adobe CF2018. This gives me the CF Admin Mail page where I enter my mail server as smtp.gmail.com and port 587 and TLS. But the connection fails. In the Mail log it indicates it's not authenticating due to 2-step auth in use for the account. Do I have to disable 2-step or does Adobe provide a way to handle it?

Hello, all, Running CF2016 update 12 on a Windows server.  We recently updated the Java (8u221 to 8u231) and started getting errors.  Rolled it back to 8u221, but the errors are still happening. SEVERE: Session attribute event listener threw exception java.lang.StackOverflowError Exception in thread "Thread-xx" java.lang.NoClassDefFoundError: java/util/concurrent/ScheduledFuture Exception in thread "Thread-xx" java.lang.NoClassDefFoundError: java/nio/channels/FileLock WARNING: org.xerial's sqlite-jdbc is not loaded. Please advise. V/r, ^ _ ^

Our application has been successfullying using cfhtmltopdf for months now.  Following a patch installation last week, we're seeing an error but there is precious little detail to go on.  Are you seeing similar?   ColdFusion Server Enterprise 2018Error occurred while generating PDF. Reason: GENERAL ERROR <cfhtmltopdfsource = "#rootFilePath#\inventories\#variables.DecryptedinventoryID#\#variables.SourceFileName#"destination = "#rootFilePath#\inventories\#variables.DecryptedinventoryID#\#variables.TargetFileName#"saveAsName = "#variables.TargetFileName#">#ReadHTML#</cfhtmltopdf>

Hello, in the documentation for the decrypt/encrypt functions it mentions that the enterprise edition offers more robust cryptography options as far as algos, etc but then it goes on to say that the standard edition works with all of the ones listed in the parameters list. So I guess what I need to know is if standard edition works with AES256? thanks.

We are getting an errorAs shown below on our Dev server, we are just entering the username and keeping the password null on both Dev and Prod servers. Error Occurred While Processing Request. Please try again.Error Executing Database Query. [Macromedia][Oracle JDBC Driver]A username and password are required if the connection option 'authenticationMethod' is specified with a value of 'userIDPassword'.The error occurred on line 28.  Whereas on our Prod server we are getting an error message as shown below 500 - Internal server error.There is a problem with the resource you are looking for, and it cannot be displayed. We think this is due to an incorrect setting in the Cold Fusion Administrator on our Prod server and we would like the Error message to be the same as that on Dev server , Can someone help us with this issue ?

I am trying to access a Sharepoint Online list from ColdFusion using the below codes: <cfset viewFields = xmlParse(" <ViewFields> <FieldRef Name='Title'/> <FieldRef Name='Model'/></ViewFields> ")> <cfset query = xmlParse(" <Query> <OrderBy> <FieldRef Name='Title'/> </OrderBy> </Query> ")> <cfset queryOptions = xmlParse("<QueryOptions></QueryOptions>")> <cfsharepoint action="getlistitems" domain="Domain Name" name="spVar" userName="UserName" password="Password" params="#{listName="1F8473F8-7969-49F9-936D-89B8FA95DDE", viewName="818CC7AA-9B0A-4D46-A8FB-4A6C872EE064", query="#query#", rowLimit="20", viewFields="#viewFields#", queryOpt

Hello,I maintain a Coldfusion 9 Application that I inherited, and I need to move the applications into a more powerfull and modern Server since the old one is out of memory and low performance.I need to access the CFIDE administrator page to copy the pathing configurations to the new one to make it work (according to a handy tutorial), however, when trying to access the page, I get :Error Occurred While Processing Request unexpected constant #2 99and then browser info. Any idea how to fix it? Or a way around, like an exporting tool or something? I have very low knowledge of Coldfusion. Thanks in Advance

Currently have Coldfusion 2016 installed on Redhat 6 which connects to Oracle 12c database on Previously we had update v5 install and yesterday using the web console, I appled v6 followed by v11 and then finally v12 on our prodcution system. Within an hour of doing the patch update to v12 it exceeded 300 cursors on the Oracle, something we'd never expericed before. Since it was a key production system we increased the cursor size to 600. However the cursor continued to raise with the DBA have to take drastics action on the Oracle database to provent a crash.  My questions is this normal behavior for the v12 patch to incease the amount of Oracle cursors?Will there be a v13 to correct this cursor issue? Another thing, I noticed in the process that v8 was not present to be upgraded to as I remember on the development. 

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