ColdFusion

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! 

I would like to use cfimage to resize and convert photos on upload for a maintence app (slideshow).  with the new iPhone 11 default to HEIC, people are finding they cannot upload the file and have it processed by my cf app.  Help!!!

Hi everyone, We just recently migrated from ColdFusion 2011 to 2018. Pages on the site frequently encounter the following error: Error Executing Database Query.[Macromedia][Oracle JDBC Driver]No more data available to read. This is usually generated when a page is initally loaded or access after having been idle for an indeterminate time frame. This error was never an issue with our CF 2011 installation. We are using an Oracle backend datasource which is situated in another physcial location from our CF servers. This setup is new to us but I cannot imagine it be the cause of the error. I see that this error has been posted in the past by it was never fully resolved/explained. Any advice/suggestion would be greatly appreciated. 

Hi again,I installed some extensions for ColdFusion in Visual Studio Code, but how can I run the code from a file in the Browser? I can't find that command or it doesn't seem to work...

Prior to upgrading our production servers we wanted to test this process on our UAT server. But this server has not worked for years, and we cannot even fire up the Cold Fusion Admin page (gets a 500 web page error).Should I just try and re-install Cold Fusion over the top OR de-install it first to get a cleaner starting point?If I de-install it, where can I find the licence key, as I don't think there are any remaining records of this outside of the code?  (it is ColdFusion 10)

Hello, I´ve inserted the "quick field" "X of Y" in the page footer of the report. But it only prints on the first page. Can anyone help me with this? Thanks. Manuel

Hi, I'm trying to pass a URL as a string variable to the ebay SOAP webservice. In the WSDL it says that the data type is simple type anyURI, which is part of the standard xml schema. However, when I try to pass the variable in as a string I get an error saying that the webservice with that parameter cannot be found. However, I am able to successfully make the call if I leave the parameter out altogether. Would anyone have any ideas of how I can get Coldfusion to recognise or convert from string to anyURI? Any help would be much appreciated. Tom

Hello all, does anyone know the steps needed to upgrade from Coldfusion 11 to 18. I was told I could bypass the 2016 and install the 2018. Thanks

I've spent 5 days trying to get the "Chart Wizard" to create a simple chart on a report.It simply does not work.There is nothing I can do that does not result in this error message:An error occurred while trying to create a chart on this report. Ensure that the column(s) selected for the chart series are numerical values. Error: The chart could not be generated due to an error in the graphing engine. Resources: Check the ColdFusion documentation to verify that you are using the correct syntax. Search the Knowledge Base to find a solution to your problem. Browser  Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; WOW64; Trident/7.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; GWX:DOWNLOADED)

I want to upload XML data to a DotNet webservice, the access URL ishttp://ap.fishtap.org.tw/breednWebSvc/App/WaterQuality.asmx,and the interface method is uploadSvc(string sXML) the XML data as follow :<?xml version="1.0" encoding="utf-8"?><WQList>  <orgid>402665</orgid>  <change_date>2020/01/28</change_date>  <boxtag>    <boxid>18364</boxid>    <workdetail>      <hhmmss>11:19:04</hhmmss>      <w_no></w_no>      <water_no></water_no>      <warm>22.1</warm>      <ph>8.09</ph>      <dissolve>5.78</dissolve>      <salt>44.1</salt>      <wa01>7.481</wa01>      &

Bonjour,D'après un document PDF, comment le découper en plusieurs enregistrements :1 - titre du chapitre2 - texte du chapitreet cela à partir d'un numéro de page.Merci pour votre aide

I am attempting to run a simple REST api with ColdFusion and receiving same error regardless of attempt. The call works fine in Postman with the 4 params. But cant recreate in ColdFusion 2016 CFHTTP.<cfhttp url="https://api.sandbox.scoutrfp.com/v3/contracts" method="GET" result="ITEM_INFO">        <cfhttpparam type="header" name="X-Api-Key" value="#variables.API_KEY#">        <cfhttpparam type="header" name="X-User-Token" value="#variables.USER_TOKEN#">        <cfhttpparam type="header" name="Content-Type" value="application/vnd.api+json">        <cfhttpparam type="header" name="X-User-Email" value="#variables.USER_EMAIL#"></cfhttp>I have replaced the header with type cgi as<cfhttpparam type="CGI" encoded="false" name="Content_Type" value="application/vnd.api+json">I have added all temp headers that postman

Hi, In one of my project I got a requirement where I need to integrate CF2018 app with RabbitMQ. Have anyone tried it before? If yes can you please share any tutorials or Git hub project. I appreciate your help. Looking at a git project. As it is developed 2 years back it is not supporting the current version of RabbitMQ. https://github.com/lmajano/messaging-polyglot

Has anyone else received this error when migrating from 11 to 2018 with their ORM? java.lang.NullPointerException at com.sun.xml.bind.v2.runtime.unmarshaller.StAXConnector$1.getPublicId(StAXConnector.java:101) The site I am working on is using a manually created hibernate.hbmxmlI found 1 post about this here but no solution: https://community.adobe.com/t5/coldfusion/java-null-pointer-error-while-migrating-to-coldfusion18/td-p/10145708

When trying to access the CFIDE administrator, it shows the error:The getVerityService method was not found.I'm running CF9, and know little of Coldfusion in particular, just savvy reading code on an inherited application.The reason I need to access CFIDE administrator was to configure the custom tags, if it makes sense? Trying to get the cfx_zipman tag to work on a new instance that I'm trying to get running...  Thanks in advance

Since moving to CF2016 I've been seeing quite a lot of the error below in the exception log file. I did some research and can't quite figure out what is going on and if this is indeed having an impact on the end user. I've tested the download link on http://www.hiddentoolbox.com and it appears to work fine"Error","ajp-nio-8016-exec-6","03/26/18","11:55:46","myapp","The cause of this output exception was that: org.apache.catalina.connector.ClientAbortException: java.io.IOException: An established connection was aborted by the software in your host machine. The specific sequence of files included or processed is: C:\ACS\hiddentoolbox\downloadfile.cfm, line: 15 "coldfusion.tagext.OutputException: The cause of this output exception was that: org.apache.catalina.connector.ClientAbortException: java.io.IOException: An established connection was aborted by the software in your host machine.I was wondering if this is as simple as people closing their browser before the download is completed, a

Updating from Server 2008r2 to 2012r2 to keep support. Concerns from previous ITM left the environment on 2008r2 instead of updating. What changes environmental changes will I need to make to allow CF10 to run after updating MS Server to 2012r2? Please Help!

When configuring a username and password for an SMTP mail server, I'd like to know where/how the password is stored on the server. I did find out where the password file is stored for the ColdFusion administrator password: C:\ColdFusion2016\cfusion\lib\password.properties However this isn't the SMTP server's password that we would enter into the password field under ColdFusion Adminstrator's Server Settings > Mail. Is this stored in the same manner-encrypted-or is is stored in a file in plaintext non-encrypted? Thanks,Mikael  

Once upon a time, there used to be a big library of custom tags and things created by the community and made available to browse and download.  Generally speaking, everything I am looking to build, has already been built, in whole or in part, by someone before me.  It was helpful.  Does anything like that exist anywhere today?   Please let me know.

ColdFusion 11 version: 11,0,19,314546Edition: EnterpriseOperating System: Windows Server 2012 R2Java Version: 1.8.0_231 I'm having a problem with <cfexecute> once I enabled Sandbox Security on my CF11 Enterprise installation.  I have one ApacheCXF webservice client that is executed from withint the application.  I've done the following within this sandbox: enabled the cfexecute tag under the sandboxgiven Execute permission on the folder where the client and calling function reside ( same folder )given execute permission to the Windows user account and the service account on this directory.also tried full control access for user account and service account, as well as execute in sandbox for entire diretory. The error I'm getting is:An exception occurred when invoking an external process.The cause of this exception was that: java.security.AccessControlException: access denied ("java.io.FilePermission" "<>" "execute"). Any suggestions?

At sudden i'm getting this error "This page isn't working HTTP ERROR 500 " whle hitting my coldfusion sites which are running on CF2016 and IIS 8.5 Can some one let me kneow the issue.

Hi,I am dealing with someone else's application and it's sort of a mess.They're using built in form validation so the server logs this: Form entries are incomplete or invalid.<ul><li>Data entered in the RATE field must be a number (you entered 'dave') and then returns a scary 500 server error, which doesn't really give the user any opportunity to fix their input. Why won't it just output that error to the browser like every other programming language?

I wanted to reinstall some old software that originally was designed to run on Windows XP 32-bit. Figuring I could also run Coldfusion 4.x through MX 7 (this is something I have reasons for wanting to do—I don't need to be advised to install newer server, thanks), I created a virtual machine and installed Windows XP. All would be fine, except that XP only allows for the creation of one web site under IIS 5.1, and I need to run more than one. So, it's back to the provervial drawing board for me.So, I'm shopping for a new Windows OS. In a Windows help forum where this one web site under IIS issue was discussed, someone suggested installing Windows Server 2003. This gets me off into the weeds. My main concern is that, at some point, my other software, created to run on Wind XP, started getting really funky under new OS's. I bought this software new in 2002, and I kept it through a few PC and OS upgrades. It definitely didn't like Windows 7 Pro, at all. Would run, but with errors, and

I am trying to write a Flex app to launch a PDF.The Flex app is able to grab data from the database ok.... however when I click a button on the Flex app to invoke a CFC to invoke <cfpdffrom>... an error message indicates...     Unable to invoke CFC - the pdf file specified in the cfpdfform tag either does not exist or is not accessible by this tag.When I change the path to the pdf, each subsequent error message shows the correct path to the pdf.  Thus, the path seems to be ok.I am able to launch the pdf ok via a .cfmHelp would be appreciated.--Bill