Questions

How does anyone here deal with the cfclasses folder? Our application dynamically generates ColdFusion files and sometimes also deletes them, but ColdFusion never removes any old files from the cfclasses folder. Has anyone come up with any clever solutions on how to resolve this. I've thought about using a scheduled task to remove any class files which may be older than a certain date, knowing full well that they could still be legitimate files. But unfortunately cfdirectory does not allow you to filter on dates or limit the number of rows. Any ideas are welcome. Thanks

I'm using sendgrid's email parser to return the body of an email to my application. The problem is, if the message is a reply it also returns the original message with the reply message. What I'm trying to do is parse out the reply from the original message. To do this I think I need to find the text/characters that each major email client uses between the reply and the original message and remove the original message. What I'm trying to do is use coldfusion to look at the following example text and delete out everything to the right of and including the 'On Fri, Sep 13, 2019' in the following text. This is an example of a gmail reply."here's a test reply with multiple line breaks On Fri, Sep 13, 2019 at 5:56 PM <matt@email.com> wrote: > ---*PLEASE REPLY ABOVE THIS LINE*--- > > This is your confirmation text > I wonder how to keep the line breaks? > > > Thank you!" How would this be possible in CF? If you know of any better way to accomplish th

Hello, all, Despite my derision for this "new platform", I don't have a choice if I need support, so here goes. Using pseudo-code, I've got a query like:SELECT col1 col1, col2 col2, col3 col3, col4 col4 FROM tableA ORDER BY col4 DESC UNION SELECT col5 col1, col6 col2, col7 col3, col8 col4 FROM tableB ORDER BY col4 DESC And I'm getting the error message that the query isn't properly ended.  I've tried with semi-colon, without semi-colon, can't seem to see why this errors in CF, but it works fine in SQL Developer.  (Oracle db).  Any ideas? V/r, ^ _ ^

Hello, We have updated our CentOS ColdFusion 2016, from update 8 to update 11. Installation was successful, and the installation log shows 0 errors. After that, one of our scripts, that generates a thumbnail from a password protected PDF, has stopped working. Our code is  <cfpdf action="thumbnail" source="#data.filename#" password="mypassword" destination="#sPathTemp#" pages="1" scale="30" format="jpeg" resolution="high" overwrite="Yes">  and the error is An error occurred during THUMBNAIL operation in <CFPDF>. Error: The password provided is either wrong or does not have sufficient permission to perform this action. <br>The error occurred on line 1. in more detail coldfusion.pdf.PDFDocOperation$PDFUnAuthorisedOperationException: An error occurred during THUMBNAIL operation in <CFPDF>. at coldfusion.pdf.PDFDocHandler._extractSinglePDFImages(PDFDocHandler.java:4264) at coldfusion.pdf.PDFDocHandler.

Are you finding problems after applying a CF update? The explanation may be someplace you’re not even looking: the update’s “install log”. And the resolution may be just minutes away! Charlie Arehart, he needs no introduction, has written a blog on this. Read all about fixing issues after an update.

Give your ColdFusion career an edge. Adobe ColdFusion Specialist is a blended learning certificate program, comprising 15+ hours of online videos followed by a day-long, hands-on workshop.Register now!

This is the query that I am trying to run and I am getting the above error <CFPARAM NAME="Form.UserLogin" default=" " TYPE="string"><CFPARAM NAME="Form.UserPassword" default=" " TYPE="string"><CFQUERY NAME="GetUser" DATASOURCE="Blinkey">SELECT *FROM OWContactsWHERE UserLogin  = '#Form.UserLogin#'AND UserPassword = '#Form.UserPassword#'</CFQUERY><cfdump var="#GetUser#">This query is for the login page of the intranet system that I am responsible for.I've read several threads trying to figure out the problem and as of yet haven't found a good answer.  The code works in CF9, but I am trying CF2018 on my test server and I keep getting the error.  I've checked the DSN information and the data source that is being called is marked as the default database for the login. 

Hi there, We are using ColdFusion 2018 on Windows Server 2016. I would like to know error handling can be done in ColdFusion. On the server we get a detailed error messages a lot of which is technical. I would like to capture parts of this message and display it to the end users who access the application through a URL in a user friendly manner. Any suggestions on how this can be done ? ThanksIQ

Hello,I am not sure if this is a bug or if I am not using the tag correctly. The following occurs in ColdFusion 2018 release.If I setup a new event with cfexchangecalendar, using the following event parameters, the timezone changes to (UTC+00:00) Monrovia, Reykjavik (and the event time is therefore incorrect):<cfset local.event.Message = "Event Message"><cfset local.event.Subject = "Event Subject"><cfset local.event.AllDayEvent = "no"><cfset local.event.StartTime = createDateTime(2019, 7, 26, 0, 0, 0)><cfset local.event.EndTime = createDateTime(2019, 7, 27, 0, 0, 0)><cfset local.event.IsRecurring = "yes"><cfset local.event.RecurrenceType = "WEEKLY"><cfset local.event.RecurrenceEndDate = createDateTime(2019, 12, 31, 0, 0, 0)><cfset local.event.RecurrenceDays = "MON">Any assistance would be appreciated.Thank you,Robert

Greetings,We are attempting to deploy some code on CF2018, and are receiving a puzzling error.  When we run the code, and then look in the coldfusion-out log, we see several entries of "Exception while fetching the host port of the DB in Configuration for "db name.of.database".  The exception log contains the above error, with the following entry associated with each entry;"java.lang.ClassCastException: class coldfusion.sql.CFDataSourceProxy cannot be cast to class coldfusion.sql.CFDataSource (coldfusion.sql.CFDataSourceProxy and coldfusion.sql.CFDataSource are in unnamed module of loader coldfusion.bootstrap.BootstrapClassLoader @59b32539)"The code is executing a SQL query, which does complete.  The data source is working, because we get data back, as well as it validating connectivity during the data source creation process.  To our knowledge, no proxies are defined for the datas ource connection.We cannot locate specifics on either of the error messages, so any i

I am pulling my hair out over this one. I am trying to run cfquery from this ColdFusion application using SQL 2000 as my Database. I have tried updating to SQL 2000 service pack 4 and installing the latest com.microsoft.jdbc.sqlserver.SQLServerDriver SQL 2000 driver. Nothing seems to work. I am able to create DSN's okay. I tried making an ODBC connection and that did not work either. I have tried connecting ColdFusion to another SQL Server 2000 box and it works fine. Here is the error message I am getting. Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid object name 'TIER1'. The error occurred in D:\cfsites\tms-hq\test.cfm: line 1 1 : <cfquery name="GetTiers" datasource="#application.ds#"> 2 : SELECT * 3 : FROM TIER1 -------------------------------------------------------------------------------- SQL SELECT * FROM TIER1 DATASOURCE TMSMyCFSitePublic VENDORERRORCODE 208 SQLSTATE 42S02 Resources:

Hello,CF newb here. I know how to restrict access to a page based on individual IPs using:<cfif TRUE AND CGI.REMOTE_ADDR NEQ '123.45.67.80' AND #cgi.remote_addr# NEQ '123.45.67.81 AND #cgi.remote_addr# NEQ '123.45.67.84'>But I need to restrict access to a page to just allowing people in my local IP range to see it. Is there a way of excluding all IP except for those in, say, 123.45.67.80 through 123.45.67.99 without having to key in all of them individually?Thanks a lot!!

I have been developing ASP.Net web sites in Visual Studio for years. Now I am trying to learn ColdFusion. I like what I have seen so far. I have tried to take a training class twice this year only to have it cancelled. So I took an Old class online that is obsolete Coldfusion10 and not fully compatible with version I am running "ColdFusion 2016" I am trying to use ColdFusion Builder 2018. I have an issue I can't seem to solve. I have a sample ColdFusion website from the class I took on line and I can open/browse it in IIS. But when I try to open the main page in Builder "Index.cfm" I get this message. "Selected file is not in the document root of the server. it the project is not in the document root, create a linked folder to the document root (selecting Project Properties > ColdFusion Project)."She here is what I did.1. I created a new ColdFusion project.2. One by one I imported the files from my sample website3. Then I click the Run button.I'm sure this sounds small to you but wh

I have a form that submits to itself like this <form action="" method="post"><table >   <tr>  <td width="50"><input type="checkbox" name="client_id_C" value="#client_id#"   ></td>   <td  width="50"><input type="text"  name="#client_id#_Fee"  value="">  </td></tr></table></form>The client_IDs are 101,102,103 etcSo when I fill out the form I get form values like this101_Fee = 1000102_Fee = 2000103_Fee = 3000I also get a list of the client_id's like client_id_C = 20864,21238,21284My question is once the form is submitted and the form reloads.I want the fee values to populate the #client_id#_Fee text boxes, like this <form action="" method="post"><table >   <tr>  <td width="50"><input type="checkbox" name="client_id_C" value="#client_id#"   ></td>   <td  width="50"><input type="tex

I am running ColdFusion 2016 Enterprise on a Windows 2016 Server.I have a few CFM files that are very database intensive (lots of inserts and deletions).I am finding out that when I execute these scripts, ColdFusion is apparently running them over and over again, deleting all records out of a table, then attempt to import data back in.   It does this concurrently;  I haven't been able to time when it begins to restart the script as of yet but I am working on that.Does anyone have an idea as to why it would restart the script multiple times, all of them running concurrently?I am connecting to an Oracle Instance.Message was edited by: Joseph Maitino

Hello all,We are scanning the CF files using Veracode software, and after scanning: Veracode returns some of the files that need to be address thedynamically constructing SQL queries. The below codes is dynamically constructing SQL queries.<cfquery name="qBprfp490" datasource="Hobbes">SELECT mprnoFROM #aPacket[1]#.bprfp490 WHERE mprnoa = <cfqueryparam value="#aValue#" cfsqltype="cf_sql_varchar" ></cfquery>I think by placing aValue inside the <cfqueryparam> tag will resolve the SQL injection. But I think it requires me to fix the line that starts with the word "FROM"The below is the instructions from Veracode regarding how to avoid dynamically constructing SQL queries"Avoid dynamically constructing SQL queries. Instead, use parameterized prepared statements to prevent thedatabase from interpreting the contents of bind variables as part of the query. Always validate untrusted input toensure that it conforms to the expected format, using centralized data validation

Randomly about once every 200 transactions we get the following encryption error:An error occurred while trying to encrypt or decrypt your input string: Given final block not properly padded.At login we create the follow session variables:<cfset session.a= 'AES'><cfset session.e= 'HEX'><cfset session.k=generateSecretKey(session.a)>Then throughout the site we use:<cfscript> encrypted=encrypt(customer.foo, session.k,session.a,session.e); </cfscript><cfscript>url.serial=decrypt(url.foo, session.k,session.a,session.e);   </cfscript>Any suggestions?

Hi all. I am looking for a solution that will allow me to edit content with images, save in database then render as a word doc. I hav tried serveral editors (tiny MCE, Summernote, etc.) and here is what happens.The image is saved along with the content as shown in the CFDUMP above.When I output this content in a cfm doc, it renders on the page.But when I save it as a word doc, I get a broken image:Any ideas of why this is happening?

Our Coldfusion 10 environment(Update 23) has been running for several years without any major issues.  Lately, at about every 60 hours or so, we are this database error: "Error Executing Database Query.[Macromedia][SequeLink JDBC Driver]TCP/IP error, connection refused. The specific sequence of files included or processed is: C:\inetpub\wwwroot\appname\index.cfm, line: 42 "coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query.We are connection to an Actian PSQL 12 Server via ODBC.  It turns out that while stopping the Coldfusion services to investigate, the 'ColdFusion 10 ODBC Server' hung on the stopping command.  I had to go to task manager and end the following tasks: 'DataDirect Sequelink Server'.  Then the ODBC service would stop.  I then delete all of the .trc files in folder C:\ColdFusion10\db\slserver54\tracing.  I could then restart the Coldfusion services and everything works again.  This is great, but after a

Is there a way to install Cold Fusion 2018 on Debian 9 (or other linux/unix) using ssh? My objective is to run Cold Fusion on Debian machine used primarily as a web server.  This debian machine runs several domains.  I need to run Cold Fusion on one of the domains.The problem I have is that machine has no client, so the Cold Fusion installation instructions seem to not apply. I have downloaded Cold Fusion 2018 (file name is ColdFusion_2018_WWEJ_linux64.bin).  All the installations I have done on this Debian machine have been accomplished using the debian package manager, APT.  I do not see any Cold Fusion package for Debian, so I am lost.Any information you can provide will be much appreciated.Thank you.

i was applying the Cold Fusion updates in order from 1 and when I got to 7 the ODBC Server will not start ......I found one fix that said:"file msvcr100.dll from the backup folder CF_HOME/cfusion/hf-updates//backup/db/slserver54/bin to: 1. [CF_HOME]\cfusion\db\slserver54\bin 2. [CF_HOME]\cfusion\db\slserver54\admin If the file does not exist in the backup, download the file and copy it to the locations mentioned above.”followed above and no good .....also uninstalled and that did not work .....im running an ACCESS DB and need ODBC server to run ....the server is Windows 2012 standardthxs

i was applying the Cold Fusion updates in order from 1 and when I got to 7 the ODBC Server will not start ...... I found one fix that said:"file msvcr100.dll from the backup folder CF_HOME/cfusion/hf-updates//backup/db/slserver54/bin to: 1. [CF_HOME]\cfusion\db\slserver54\bin 2. [CF_HOME]\cfusion\db\slserver54\admin If the file does not exist in the backup, download the file and copy it to the locations mentioned above.”followed above and no good ..... also uninstalled and that did not work .....im running an ACCESS DB and need ODBC server to run ....the server is Windows 2012 standardthxs

I have a web page where users submit a form and info is sent to a 3rd party vendor.The issue I have is that it takes a few seconds for the process to complete and my users are hitting the submit button multiple times.and its causing issues with multiple submissions to the 3rd party vendor.QUESTION:Is there a way to send the user to the next page as soon as they hit the submit button while the code processing takes place?So they cant hit the submit button more than onceLike thisSubmit buttonSend the user to the next pageContinue processing code with 3rd part vendor

Hello!I am getting the following error when trying to run ColdFusion 2016 after trying to apply Update 11:Aug 12, 2019 9:35:44 PM org.apache.catalina.core.StandardWrapperValve invokeSEVERE: Servlet.service() for servlet [CfmServlet] in context with path [] threw exception [ROOT CAUSE: coldfusion.server.ServiceFactory$ServiceNotAvailableException: The Monitoring service is not available.    at coldfusion.server.ServiceFactory.getMonitoringService(ServiceFactory.java:223)    at coldfusion.CfmServlet.service(CfmServlet.java:203)    at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)    at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)&nbs

Hi there,I am using CF2018 update 4 and flash player 32.0.0.223.  I have a cfgrid populated from a query.  One of the columns contain single percision floating point values between 2 and 60, usualy up to 5 significant figures.  For example, a value of 7.2 appers as 7.19999980926514 in the flash grid, but appear as 7.2 in html and java grid.  I tried setting a mask of 99.9999 for the column and it appears as 00.0000 for every row!  Any other settings I can use to correct the display issue or is this a bug?Can't use HTML grid until the fix for 4024128 is released so I am stuck with the java grid for the moment.Thanks in advance.