ColdFusion

I’ve been a long-time advocate for ColdFusion. There have been several threads prematurely referencing ColdFusion’s demise that I have chimed in. But now in dealing with our Adobe account management representative, I am left dumbfounded.Background: We have purchased and are using 40+ Standard CF licenses. These license purchases and use started with CF5 when Allaire still owned CF and have been upgraded to mostly CF9 but just starting CF11 -- and then the wheels fell off.Like idiots, we wanted to determine if Enterprise pricing might now work for us as were starting to incorporate a VM environment (from an all pizza box environment). In asking some simple questions our sales rep is now claiming that we are violating the acceptable usage portion of their license agreement:2.6.4 Prohibited Use. Except as expressly authorized through a separate custom hosting agreement, Licensee is prohibited from: (a) using the Software on behalf of third parties; (b) renting, leasing, lending, or granti

hello ,Iam workıng at local database.I add a new database.ıts workıng.but ı dont know that how can ı connect ıt?Are there any wrong at code?table name: KAYITYENDatasource:DENEME <cfquery name="ADD_BUDGET" datasource="#DENEME#">                                               INSERT INTO                                                               KAYITYEN               &nb

I need to combine  form and query codes but I couldnt make it.This is my CFML codes<cfform name="ADDADA" method="post" ><table border="3"><tr><td><strong>Musteri ID: </strong></td><td><input type="text" name="MHid" ></td></tr><br><tr><td><strong>Musteri Hareket Aciklama: </strong></td><td><input type="text" name="MHaciklama"> </td></tr><br><tr><td><strong>Musteri Tipi: </strong></td><td><input type= "text" name="Mtipi"></td></tr></table><br><input type="submit" name="Kaydet" value="KAYDET"></cfform><cfif IsDefined("form.MHid") and IsDefined("from.MHaciklama")><cfquery NAME="ADD" datasource= "DENEME" >INSERT INTO musterihareketleri (MusteriID,Aciklama,MusteriTipi)values (<cfqueryparam cfsqltype="cf_sql_integer" value="#cfform.MHid#">,<cfqueryparam cfsqlty

Is it possible to connect to an external instance of CF 2018 from the Coldfusion Performance Monitoring Toolset? We have our usual internal servers that have been picked up across the subnet. We also have 1 external server outside of this network that we would like to monitor on the same toolset. Can this be done? Assuming ports are opened etc. Dont seem to be able to set an external IP as the host for the datastore either. Initially trying it does not seem to work. Either more ports need to be opened that I am not aware of or it is not possible.  

ColdFusion and REST REST-assured, REST integration in ColdFusion is as easy as it gets! Build a simple web service from scratch and test the APIs in the REST Playground app. See the recording here. Get started with ColdFusion API Manager Monitor, measure, secure, and monetize your APIs using the Adobe ColdFusion API Manager. API Manager is a full-featured management tool that integrates all aspects of development and management processes for your API needs. See the recording here. Performance Monitoring Toolset Identify performance bottlenecks, leverage information from thread dumps, run code profiler, run memory profiler, auto-tune connectors, and much more. See the three-part webinar- Overview, Scenarios, and Troublehooting. We have more great webinars! Check out the full list at ColdFusion webinars. We have more webinars in the pipeline. Register now. Did you register for the ColdFusion Summit 2019 yet?  Now is as good time as any.   

Brand new blank system, W2K16.  Followed the lockdown guide - i.e. added IIS, required options, installed CF2018, set permissions etc.  I can access the CF Administrator but when I run the wsconfig to connect to IIS it tells me to enable the ISAPI options (Asp.net, CGI, ISAPI Extensions, ISAPI Filter).  I doubled checked my server setup and all have been selected, server has been restarted etc.   The only odd thing that differed from the documents I read was that the CF2018 installer never asked if I wanted stand alone server or J2EE installation.  It goes right from Serial Number to Select ColdFusion Server Profile.

ıam making a alittle project.ı had a sql database and tables.but ı need some information too.Iam writting code .ıts not workıng.ıs ıt true or?<cfquery name="ADD_BUDGET" datasource="#dsn#">INSERT INTOKAYITYEN(AD,SOYAD)VALUES(<cfqueryparam cfsqltype="cf_sql_varchar" value="#attributes.AD#">,<cfqueryparam cfsqltype="cf_sql_varchar" value="#attributes.SOYAD#">)</cfquery>

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?