ColdFusion

I have recently move to a new 2003 WIN server running IIS 6.0. Last night the Coldfusion server crashed and when I was checking the c:\Coldfusion\runtime\logs I came across the following error.10/11 18:32:01 Error [jrpp-9620] - Error Executing Database Query.Timed out trying to establish connection The specific sequence of files included or processed is: D:\website_directory\index.cfm, line: 838SQLException while attempting to connect: java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: database name:1433. Reason: Connection timed out: connect.[Macromedia][SQLServer JDBC Driver]Error establishing socket to host and port: xxxxxxxx:1433. Reason: Connection timed out: connectjava.lang.RuntimeException: Request timed out waiting for an available thread to run. You may want to consider increasing the number of active threads in the thread pool.           at jrunx.schedul

Does somebody know how to solve the following problem?Question to ABCpdf.net:I try to generate a PDF from ColdFusion via theABCpdf.dllIt's all 64 bit.And I get the following error:Is it a bug in ABCpdf? I do not use the Get_Units function directly.Answer from ABCpdf.netIn the past other clients have reported something similar. Something occurred on the transition between CF11 and 2016. It used to work, and then somewhere between the two releases, something went wrong in CF.The UnitType code in the V11 namespace is character-for-character identical to the one in the V10 namespace. Indeed it is also identical all the way back to the V8 namespace.I wonder if there might be a UnitType class or enum in Java. If so I wonder if perhaps Java is getting confused about which one is which. A difference might occur if you had one namespace selected but not the other. Similarly there are UnitType enums in both V10 and V11 so perhaps it is confusing those.But... all very speculative. Might I suggest

I haven't modified the code in a long time, but I receive this error:Parameter validation error for the sort function. The function accepts 1 parameter(s)Any ideas?Here is my code:<cfoutput> <CFHTTP url="http://www.zipcodeapi.com/rest/a3Pk3kJ1EvbCMrGPtI2kFH0u27u3i4heyZzsUBPv7XZDwxI0cHef4QqNOKKocXjx/radius.json/#zipradius#/#radius#/mile" method = "get" result="httpResp"> </cfhttp> </cfoutput> <cfset zipCodeJSON='#httpresp.filecontent#'> <cfset zipCodeStructure=#deserializeJSON(zipCodeJSON)#> <cfscript> zipCodeQuery=queryNew("id,city,distance,state,zipCode","Integer,Varchar,Decimal,Varchar,Integer"); for (row=1; row lte arrayLen(zipCodeStructure.zip_codes); row=row+1) { rowdata=[row,zipCodeStructure.zip_codes[row].city,zipCodeStructure.zip_codes[row]. distance,zipCodeStructure.zip_codes[row].state,zipCodeStructure.zip_codes[row].zip_code]; queryAddRow(zipCodeQuery,rowdata); } zipCodeQuery.sort(zipCodeQuery.findColumn("distance"

the application has unexpectedly quit getting error when trying to uninstall colfusion 2018. Can pleas soem one give me work around for this. I need to unstall exisitng in reinstall new CF 2018  

Hello, I have about 500 images that I want to display in rows of 5. Currently, I only know how to display them in 1 vertical column like this: <CFOUTPUT QUERY="List" GROUP="AuthorID"><CFOUTPUT><TR><TD ALIGN="left" VALIGN="top" WIDTH="542" style="padding-left:2em;text-indent:-2em"><A HREF="#request.BaseURL#/book.cfm?-#URL_Title#-&BookID=#BookID#"><img src="#request.BaseURL#/images/#Image#" width="50"></A></TD></TR></CFOUTPUT></CFOUTPUT> Thank you for your help!

I'm working on an SSO solution for a client.  At this time I'm able to encode an authentication message and successfully send it to the ADFS server.  The ADFS server handles my login and then returns to my site with an HTTP-POST response.  In the POST there is an ADFS encoded SAML message I need to decipher.  I found a few samples of code but none have worked.  This one seemed to have the most promise but...<cfscript>// Decode the query string from Base 64    Decoder = CreateObject("Java", "sun.misc.BASE64Decoder").init();  SamlByte = Decoder.decodeBuffer(Form.SAMLResponse);// Create Byte Array used for the inflation, the CF way    ByteClass = CreateObject("Java", "java.lang.Byte").TYPE;  ByteArray = CreateObject("Java", "java.lang.reflect.Array").NewInstance(ByteClass, 1024);// Create Byte Streams needed for inflation  ByteIn   = CreateObject("Java", "java.io.ByteArrayInputStream").init(SamlByte);  ByteOu

Please download the attached file to view this post

Hello guys! I tried to decipher this SAML Response, it worked, it shows the string on the screen. Now I want to to do the opposite, to deflate the response, from string to binary, do I have to change something in the code or use another function? The entire code is here: <!--- We take a base64 encoded, deflated SAML response string ---> <cfset SAMLResponse = "fVPNbtswDL4X6DvwthZwgmB7gCEJCvSSLUA39KzItE1EFj1Stuc9/Sgl3doB3cWwLX7k90M98gw1o0LqEMZIE4oizCznz7c3j+8fwvdY21dysabYvin4oHAiSR3YGVBSGEOi3iWEJj+cIKAqxkQuQEPWBDThYFPYekxIobTr0XcukvYK3EBnVCiV2bqGbx1pBRQhjRIrEPwxkhjPc+Q5YN1ihuTRVpdYlgrmjnxnc5wkrGEmo5eH7KiFnYvt+vbm9uYoOBGPCl+2T1vrPqEmal0ijvoXsmftycOBvPDsJuvh/LkVHk3tw88hsKDA3f7r7uG+OJAxzxTOFJXjK9jWtHESHhY4Cp8Q7p4P2+M9dPmwR6ej4AUtrqbCAhrh/p8wOozFGGc2xbDAp82m2mw2sKAT+xXqCjxHs7m/5mT8Enmzvucag744ZeWGxonDmEetjbMJzifUD8KTcbHMlBJNlJaizBy/Vlfw8LS13I/BRX8GPinK5LLzMGRtFx2BjUHWHjC21lzPS848om0ZDqlTqEfJLPPUj6usAMyFCS2/TIHKqmnKNbY+BWja7IejmLL+MmboFiVfhOXPy4Y1Vttzj6WueePhGg7miSmU6o

Hello,I have time-based tasks stored in a database table. I want to run a scheduled task in CF that runs every 10 min and scans the table for tasks that should have been completed in the last 10 minutes. I'm looking for help writing the CFIF statement for the time range. Something like: If query.time is between Now and LT 10 min Ago Thanks in advance for any suggestions... Gary

Hi All,We use CF 2016 and we moved to Azure over a year ago. We maintain all the Component files under a separate folder. We recently had a code deployment to production and we noticed any changes we make to that components folder is not being seen by the application. We even tried making a simple cfdump to one of the existing components and still that is not being seen by the application. We recently installed CF update 13 as well. Any help is greatly appreciated. Thanks!

We have coldfusion 2018 enterprise on a windows 2016 server. I need to install coldfusion 2018 update 6 and 7. Are the updates cumulative? Can I skip the update 6 and just install update 7? Thanks. William

[Cordova Build] 01/28 at 11:35:37 Executing Command: npm -version[Cordova Build] 01/28 at 11:35:38 6.13.4[Cordova Build] 01/28 at 11:35:38 Cordova build is being created under: C:\Users\a\cordova\primero\[Cordova Build] 01/28 at 11:35:38 Executing Command: cordova -v[Cordova Build] 01/28 at 11:35:39 9.0.0 (cordova-lib@9.0.1)[Cordova Build] 01/28 at 11:35:40 Executing Command: cordova build --debug android[Cordova Build] 01/28 at 11:35:42 Checking Java JDK and Android SDK versions[Cordova Build] 01/28 at 11:35:42 ANDROID_SDK_ROOT=C:\Users\a\AppData\Local\Android (recommended setting)[Cordova Build] 01/28 at 11:35:42 ANDROID_HOME=C:\Users\a\AppData\Local\Android (DEPRECATED)[Cordova Build] 01/28 at 11:35:42 Subproject Path: CordovaLib[Cordova Build] 01/28 at 11:35:42 Subproject Path: app[Cordova Build] 01/28 at 11:35:44 Downloading https://services.gradle.org/distributions/gradle-4.10.3-all.zip[Cordova Build] 01/28 at 11:35:45[Cordova Build] 01/28 at 11:35:45 Exception in thread "main" j

Stored procedures have always given me trouble, I'm not sure why.I want to call an Oracle Stored Procedure from a piece of CFML code.My CFML code:<cfstoredproc datasource="purload" procedure="PUR_XML_LOAD.load_raw" returncode="yes">    <cfprocparam cfsqltype="CF_SQL_FLOAT" value="999" type="out"></cfstoredproc>The error I am getting:[Macromedia][Oracle JDBC Driver][Oracle]ORA-06550: line 1, column 18:PLS-00306: wrong number or types of arguments in call to 'LOAD_RAW'ORA-06550: line 1, column 7:PL/SQL: Statement ignoredTest PL/SQL code that works in Oracle SQL Developer:DECLARE foo NUMBER :=999;begin  PUR_XML_LOAD.load_raw (foo);  dbms_output.put_line('>' || foo || '<');end;The top of the stored procedure:create or replacePACKAGE BODY PUR_XML_load AS   -- *** PROCEDURE: PUR_XML_load ***   -- Loads values from previously-validated XML file   -- into the raw_pur table   PROCEDURE Load_raw (res_val OU

Hi, I need to use ADFS Authentication implementation for Coldfusion, is someone here who can guide me how to implement it? Thank you guys!

Hello, we are working on the mobile app for the store. The ERP software use Cold Fusion to generate PDF the invoice for customer. But ERP database do not store the PDF file. The challenge is we need to send PDF invoice to customer mobile app, like the proven date of purchase and start the warranty period from the date of invoice. Anyone help us to know how to get the PDF after Cold Fusion done in ERP and put it into customer mobile app?

Has anyone built a coldfusion app that integrates with the SLACK API?  We have an inhouse  CRM application built in Coldfusion.  Wanting to add Slack to the app for users.  Any guidance is helpful.

Hello! We recently upgraded a server from Windows 2012R2 to Windows 2016. We are running Coldfusion 2016 update 13Since we upgraded servers, we cannot receive emails. When trying to verify mail server connection, it fails.All services worked on Windows Server 2012R2.Mail log error as follows:"javax.messagingexception: could not connect to SMTP host: xxx.xx.xx.xxx port: 25, response: -1"We are not allowed to use telnet but I ran the following script on ther server:test-netconnection xxx.xx.xx.xxx -port 25 and that returns that he tcp test succeeded=trueWindows firewall is off, defender is off (managed by an enterprise solution)Checked McAfee settings and cannot find that traffic is being blocked.Has anyone run accross this issue?

Has anyone else run into this? The download/update buttons are cut off (for all of the updates) This occurs in Firefox, Chrome and Edge. This is Windows 10 accessed via Remote Desktop. I know that I can download and install the update manually but thought this was odd.  

No text available

Hi everyone, I tried to parse a xml data but i couldnt figure it out.I get this error:Complex object types cannot be converted to simple values. This is my code :<cfset the_url = 'https://www.goodreads.com/author/list/210456?format=xml&key=xxxxxxxxxxxxxxxx' /><cfhttp url="#the_url#" method="get" result="Results" timeout="999"><cfset asd = XmlParse(Results)>  

 1ERE PART - Cutting <CFIF Mode IS "Update"> <CFOUTPUT> <cfset Auteur="Jean-Marc IRLES"> <cfset Titre="Le dernier secret de Julie Finet"> <cfset Destination="#db_dir#\SoLivres\_Ebooks\SoLivres\#Auteur#\#Titre#"> <CFFILE Action="UPLOAD" Filefield="FichWord" Destination="#Destination#" Nameconflict="Overwrite" Accept="application/vnd.openxmlformats-officedocument.wordprocessingml.document"> </CFOUTPUT> <CFOUTPUT>File : "#Destination#/#Titre#.docx"</CFOUTPUT> <CFFILE Action="Read" File="#Destination#/#Titre#.docx" Variable="Fich"> <CFOUTPUT><cfcontent type="application/vnd.openxmlformats-officedocument.wordprocessingml.document" file="#Destination#/#Titre#.docx"></CFOUTPUT> <cfsilent> <cfscript> a = "Fich"; console.log(a); chapterArray = REmatchNoCase("[\t\n\r]+\d{1,3}\s+-\s+[^\t\n\r]+[\t\n\r]{1}",variables.a); titleAndTex

We recently upgraded from CF 11 to CF 2016. Occasionally we are getting this error access denied ("java.io.FilePermission"... when trying to parse an in memory xml string. We have our application sandboxed, so we don't get this error when sandboxing is turned off but we do get when sandboxing is turned on. We are using jre1.8.0_221. Any ideas on what could be causing this and how we can fix it?

I have ColdFusion 2018 running with 8 instances on a virtual 4 core server that has 16gigs of memory. Of those 8 instances, only 4 of those instances are usually being used at a time.  We are having a problem that when one of those instances are being used, it can sometimes use ALL the available resources of the server that it's running on (both the CPU and its memory). Sometimes the actions being done are intensive and can take take a while to finish, but it can make the entire server unresponsive to the point that we can't even get into the ColdFusion Administrator to start and stop the instance. Are there settings someplace that can keep a single instance from overloading a server like this?

Good afternoon all. I am working on a process that pulls in lines from a file one at a time. Each string is basically a list of tilde delimited values. Some of these values can vary in length or be NULL. I need to remove a few of those tildes with NULL values between them. For instace, my string may look something like the line below. I need to remove all but one of the tildes in that group at the end. I have worked with ListDeleteAt() and tried to hit particular position number but that didn't quite work the way I'd hoped. I also worked with RemoveChars() a bit but those tildes are a different spot in each line. I am currently using the following but there may be a string of NULLs before the group I need to remove:           <cfset row = replace(row,"~~~~~~~~~","~","ONE")> Any help would be appreciated.  MEPMD01~2POOP519~03092019113800PM~6480081580~~~1224714818389~OK~E~KWH~~000015~48~03092019124500AM~00~0.3414~00~0.3396

Hi guys, I’m switching to Visual Studio Code in order to develop ColdFusion applications, how can I add a database saved in my computer? Or a database from a URL? Is there an extension that needs to be installed? Thank you!