ColdFusion

I keep getting this error and I am not sure why:An error occurred while trying to encrypt or decrypt your input string: The input and output encodings are not sameI think it is because the password is being pulled from a database.Here is my code:<cfquery datasource="#datasource#" dbname="#dbname#" password="#password#" name="getpass">SELECT email,pass,usernameFROM membersWHERE email = '#email#'</cfquery><cfoutput>#decrypt("getpass.pass", "xxxxxxxxxxxxxxxxxxxx==", "AES", "Base64")#</cfoutput>Thanks!

I am using CFHTTP to connect to an external company API. When I check in the "inspect" of google Browser it is like Resquest Method "GET". The API receives request via "POST". And the Content-type does not change to application/json.  <cfhttp url="https://app.XXXXXXX.com/ErpPedido/V1" port="443" charset="utf-8" method="Post" result="response">    <cfhttpparam type="header" name="accept" value="application/json">    <cfhttpparam type="header" name="Content-Type" value="application/json">    <cfhttpparam type="body" value="#serializeJSON(stFields)#">  </cfhttp>

Hi,ColdFusion could not delete the file C:\ColdFusion11\cfusion\wwwroot\LAW\Briefs\A2878\pwd1.txt for an unknown reason.I am unable to delete any .txt or .msg file immediately after upload from their physical path and as well as from server too and the Coldfusion doesn’t return any particular reason for failure.It doesn't allow me to delete the file from the physical path i.e. from the brief folder, it will show an error pop-up with a message 'The action can't be completed because the file is open in coldfusion.exe'(see attached screenshot). It seems that Coldfusion locks the file in the background and after sometimes it allows me to delete the file successfully.For another extension like .docx, .pdf, I am immediately able to delete the file after upload. Apart from this, when I restart ColdFusion service it will allow me to delete the file again as if the file is getting locked by ColdFusion. I am using ColdFusion version '11,0,03,292866'.Does anyone have a solution to this problem?

Hi, I'm doing some form data validation and would like to add rules for files (size and type). Ideally I want to avoid CFFile as the validation shouldn't have anything to do with moving the file anywhere. I know that when ColdFusion processes an upload, it stores it in a temporary directory and filename. This is stored in the form field (e.g. form.file = c:\sometempdirectory\blahxxx.tmp) and I can use that to do a GetFileInfo and find out the filesize. Awesome.... except it's called blahxxx.tmp :( I want to know the real filename, not the temp filename but I can't find it anywhere. ColdFusion must know it, probably hidden along with its other darkest secrets, as it'll use it when we do a CFFile action="upload". So where is it being hidden? Any ideas? I have seen suggestions of using an extra hidden field plus some javascript, but to be honest, I don't like trusting something like that as it's possible to abuse it. I've also gone hunting inside "getPageContext().getRequest()" but no

I have extensive records containing dialog edited using CKEditor. It translates father's to father’s and this is how it is stored in the table.I am pulling the records to make a web page - hundreds of them at a time. I process several text fields (nsvarchar) such as:<cfset a = '<blockquote class="dkpurplefont"><i>Notes for birth: </i>' & #GetData.BirthNotes# & '</blockquote>'><cffile action="append" file="#fname#" output="#a#" addnewline="yes">I was using <cfset a = '<blockquote class="dkpurplefont"><i>Notes for birth: </i> #GetData.BirthNotes#</blockquote>'> which should work. I switched it thinking I might solve the issue.60% of the time I will see "father's" on the completed web page. 40% of the time I see "father?s"I infer that the engine is choking on the ’ as it processes #GetData.BirthNotes#  and I'm guessing it is a speed issue - it is being processed faster that it can interpret.

I have an application that is on 2 servers where form data from server #1 populates and creates a fill-in PDF on server #2Server #1  - Railo server  (Cant do PDF stuff)Enter Info into Form  > Submit Form to Server #2Server #2 -Windows server with CF16 on itGets form field info and creates a PDF.Now I want that PDF to be copied back to server #1.How can I do that?Do I save it on server #2 and then do some file transfer or can I save it back to server #1?

We are trying to use CFPDF merge and having issues having all the merged documents come out the same width.  currently some are slightly larger than others but enough to make it annoying.  have verified the orientation of all docs are the same, and have already attempted to use the getinfo action to determine document widths, but apparently CF is "optimizing" these at runtime to what it "thinks" it should be thus throwing off the proportions to use in hscale & vscale attributes.    Anyone have this issue and found a solution?

After verifying database, when I am going to database on localhost 8500 it says database could not be created.Please help for this issue.

Adobe ColdFusion（2016 リリース）の無料のデベロッパー版またはトライアル版は現在入手可能でしょうか。2018リリース体験版は入手できるのですが、2016リリースを手に入れたいです。

I want to use cfspreadsheet to update the data in an xlsm file.From the docs, it seems that cfspreadsheet can handle the "updating"... does anyone know if it has a problem with xlsm files in excel?

Hi, we have a CF2018 Standard Server installed in a windows box.We installed PMT into another server and after the install no CF instance gets detected, even entering the CF server details (ip, port) doesnt work in order to get the CF instance detected by PMT.We only have one application in that CF server and no J2EEAny help on setting that monitoring toolset up will be most welcome.Thanks in advance.

I'm running an old CF 9 server and application where it calls out to a remote web service every half hour between the hours of 7:30 am and 11:00 pm every day through the job scheduler. At the 7:30 am run, it always re-compiles the web service stubs every day.  This generates a GET when it is requesting the fresh WSDL from the remote endpoint, and then it generates a POST when it is invoking the normal method it uses to pass data.  Subsequent calls to this remote endpoint do not cause the stubs to re-compile, and the GET is subsequently also not generated, that is, until 7:30 am the next day.  The problem is that I am trying to get rid of that first GET at 7:30 am, which is another way of saying I don't want the system to re-compile the stubs every day.I have checked the code, and ancient though it is, it uses cfinvoke webservice="https://someendpoint.asmx?wsdl" method="SomeMethod" returnvariable="returnXML".  I'm not sure if the refreshWSDL attribute existed in CF 9

Hi,I am trying to set the content-type for a cfhttp request like this (on coldfusion 9):<cfhttp redirect="no" method="get" timeout="120" url="http://10.0.0.1/test2.cfm">    <cfhttpparam type="HEADER" name="Content-Type" value="application/json; charset=utf-8"></cfhttp>// coding on test2.cfm:<cfset x = GetHttpRequestData()><cfdump var=#x#>// Output on test2.cfmcontent [empty string] headersstructAccept-Encoding deflate, gzip, x-gzip, compress, x-compress Connection TE Host 10.0.0.1:80 Proxy-Connection close TE trailers, deflate, gzip, compress User-Agent ColdFusion X-REWRITE-URL http://10.0.0.1:80/test2.cfm method GET protocol HTTP/1.1 As you can see no content-type is send through. I also tried the sniffer.exe:GET http://10.0.0.1:80/test2.cfm HTTP/1.1Host: 127.0.0.1Proxy-Connection: closeConnection: TETE: trailers, deflate, gzip, compressUser-Agent: ColdFusionAccept-Encoding: deflate, gzip, x-gzip, compress, x-compressHere you can also see t

Hi We're in the process of setting up our new Windows 2016 server running ColdFusion 2018 with Update 1 installed. We run MySQL 8 and are using the most current Connector (mysql-connector-java-8.0.13.jar).We're having a problem with a SELECT statement when the only field chosen is a DATETIME field that is only being used for the time section. The returned value from the database is '0000-00-00 00:01:00' (ie 1 hour). SELECT Employee_LunchBreak_Length FROM t_EmployeeWHERE t_Employee_ID = '1'The query above returns a 500 error and creates the following entry in the Application log."Error Executing Database Query.Zero date value prohibited The specific sequence of files included or processed is: (*path to template*)"The query works in both MySQL Workbench and in PHP without issue. It also works on our previous CF10 / MySQL 5.6 server.On both the new server (CF18) and old server (CF10) we're setting a connection string on the DSN of zeroDateTimeBehavior=CONVERT_TO_NULL&characterEncoding

Hello,We are having an issue with CPU loading on our server.  It has to do with Client Storage Purge. I see where this issue has been around for a while but could not find a solid solution.  Our sever is running Windows Server 2003 Standard and ColdFusion 8.  There is only one ecommerence website utilizing CF and the database is MSSQL.The server average CPU usage is between 5% and 10%.  Then this appears in the log; 03/30 05:56:34 Information [scheduler-3] - Run Client Storage Purge.  The CPU usage jumps to 50% to 80% for about 4 to 5 hours.  Then after it settles back down, with in the next few hours it starts over again.Settings,ColdFusion Administrator > Server Settings > Client VariablesSelect Default Storage Mechanism for Client Sessions is set to RegistryPurge Interval is set to 1 hour and 7 minutes.Now, my working knowledge of ColdFusion is not at an expert level.  I really do not know what Client Storage Purge is doing, what client varia

I have a mortgage site that I inherited. I can enter the down payment at a certain dollar value.  The owner wants to add the ability to either enter down payment (currently I have in site) or enter the percentage of a down payment.  Below is where I need to add the code and what was in there to start.  <tr>                    <td valign="middle"><div align="right">Down Payment:</div></td>                    <td valign="middle"><span class="style6"></span></td><td valign="middle"><span class="style6">                      <cfinput name="dPayment" type="text" tabindex="23" size="15" required="yes" message="Please e

I have three queries on my page:1) Query #1: calculates a leave time value (ex 100)2) Query #2: calculates a used time value: (ex 😎3) Query #3 is a query of queries that should calculate the difference between the first two values.First two are working fine, but QoQ is giving me the following error:The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code.Null Pointers are another name for undefined values.What is the issue here?<!---Create "Accrued Leave Time" (for current year) Dataset ---><cfquery name="rsAvailableLeaveTime" datasource="care">SELECT     COALESCE(SUM(tblleavetime.ltHours),0) AS Accrued_LeaveTime, ltUserFROM      tblleavetime LEFT OUTER JOIN tblusers ON tblusers.username = tblleavetime.ltUserWHERE tblleavetime.ltUser = <cfqueryparam value="#SESSION.kt_login_user#" cfsqltype="cf_sql_clob" maxlength="255">AND YEAR(tblleave

I'm running CF 10 Developer (64-bit) (using IIS) on top of Windows 2008R2 (64-bit). This server is running in a Virtualbox VM on my Windows 7 Pro (64-bit) workstation.Everytime I attempt to add a RESTful service (even the most minimalistic), I get an error.For instance, this very simple CFC:/RestExample/HelloWorld.cfc <cfcomponent rest="true" restPath="/hello">        <cffunction name="sayHello" access="remote" returnType="String" httpMethod="GET">                 <cfset res="Hello World">                 <cfreturn res>        </cffunction></cfcomponent>I then proceed to register the service in CF admin:Root Path: C:/websites/test/RestExample/Service Mapping: ExampleThis will produce this error:Error registering REST service

Hi,We migrated from CF2011 to CF2018 and then ORM is breaking the EntitySave method and we are getting below error message.Error Message - The root cause of this exception was: coldfusion.orm.hibernate.HibernateSessionException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1.We have 2 classes with one-to-many relationship like Email.cfc(parent) and EmailItems.cfc(child). When we try to save Email.cfc object the hybernate crates a UPDATE query for EmailItems as well and this is happening with CF2018 only.Here is the defined property in Email.cfc.<cfproperty name="EmailItems" lazy="true" fieldtype="one-to-many" inverse="true" fkcolumn="EmailID" cfc="EmailItem" singularName="EmailItem" type="struct" structkeycolumn="EmailItemKey" structkeytype="string" cascade="none"/>We are using inverse and it still create a UPDATE query for child class 'EmailItems' which is the reason for failing EntitySave(Email).Everything works fine with CF2011.Tha

ColdFusion 11 offers a new feature to preserve the case of struct keys during JSON serialization. Trouble is it does not work for me (OSX 10.9.4).The documentation mentions 2 ways to get this working (although it is supposed to be on by default).In application.cfc, set this.serialization.preservecaseforstructkey = trueIn the ColdFusion administrator settings page, check 'Preserve case for Struct keys for Serialization'Neither of these work. Stopping and Starting ColdFusion does not help.No matter what, I always get the keys converted to UPPERCASE, just like in CF10 and earlier.This would be a great feature to have working. Is it a bug? Has anyone else got it working?Andrew Culver

I am showing a datediff using just hours.  Can I show hours and minutes?  I am using CF10, and I am not a programmer.Here is what I am using<cfset cc_TIC_cooler_good_untilDiff = DateDiff("h", Now(), cc_TIC_cooler_good_until)>    cc_TIC_cooler_good_until = date/time stored in database.Thank you

In the past I have always had success connecting data sources.  However, I am really struggling connecting both my Oracle database and my MySQL databases to CF16.  I believe I have the drivers in place but no matter what I do I still am cursed with  the "No suitable driver available" message.Trying to connect to Oracle 12c and MySQL latest version 8.For oracle I am using what i did with CF11 and that is the jdbc oracle thin driver.For MySQL I am using jdbc mysql driver.Both are located in the /cfroot/cfusion/lib directory (or at least I think they are).Any help would be appreciated.ThanksJK

Hi team,i have installed coldfusion 2018 on the server, configured IIS. Now when i visit admin page it shows freezed search bar and i am unable to do anything.

I have an application that allows users to upload multi-worksheet Excel files.  I use CFSpreadsheet to parse these files and import the data.  The processing can take anywhere from a minute to several minutes.  The first worksheet contains data that dictates which additional worksheets require processing during the import.While doing some load testing, I noticed that if two users upload files, the second user has to wait for the first user process to finish before it works.  I have added CFLOG statements throughout my application, and done some simplified test scenarios (where I just read one worksheet and dump the result) that prove to me there is a blocking situation.  Has anyone else seen this situation?  Is there a way around this?

I have function that will generate cfdocument pdf file. Then I would like to return the document and server to the browser. Here is example of the function that generates the pdf file.<cftry>      <cfdocument format="PDF" filename="file.pdf" overwrite="Yes">           <table>                <tr>                     <td>Test</td>                </tr>           </table>      </cfdocument>       <cfset local.fnResults = {file: //Here I'm not sure what I should return}>       <cfcatch type="any">    &nb