ColdFusion

Hi,I'm kinna new to this i'm trying to create a little system for my son lawn mowing business.i have field that have services and prices for itservices1 price1services2 price2When he enters the data for the price i want to prevent him from using commas and dollar sign so when he submits field i'm trying to use this to modify it on the inserting pageprice_f1 is the form field so if he puts in 450,50$   <cfset price1 = ReReplace(price_f1, "[^\d.]", "","ALL") ><cfoutput>#price1#</cfoutput>  it comes out 45050 i want 450.50 how can i do that ?And once that works how can i enter it into the database i have tryed to get it in using<cfinsert datasource="mydatasource" tablename="thetablename" formfields="ID, firstname, lastname...., services1,  price1"></cfinsert>All the data enters but not my price1 at 45050 it stays NULL any suggestion why that is and yes i do set my var before the insert.Thank you

After using the ActivePDF Toolkit function "Get_OutputByteStream" to put the manipulated PDF into a binary data variable (variable name "pdf"), I then pass that variable into CFCONTENT to display it in the user's browser.<cfcontent type="application/pdf" variable="#pdf#">However, the result is now a CF error page which says:"[S is not a supported variable type. The variable is expected to contain binary data."We tried everything suggested incfcontent no longer works with ActivePDF in CF2016 [dealbreaker]        I would like to know whether we could get some assistance with regards to this issue. We are able to provide you with evaluation key of ActivePDF toolkit and the script that we have trouble with. So far, we have tested with Classic ASP as well ASP.net and C# applications. They all work. The issue is with ColdFusion.

For a Customer, we need to install an application running perfectly Under CF9.Then we are looking to buy a CF9   (cf9.1 or cf9.2) standard edition licence.Thanks for any help.CF8 is not suffisant, and CF10 is too much.

Hello, all,Just a heads-up.  US-CERT (US Computer Emergency Readiness Team) has announced that there is a vulnerability in IIS 6.0.  Excerpt below.National Cyber Awareness System:Internet Information Services (IIS) 6.0 Vulnerability03/30/2017 05:48 PM EDTOriginal release date: March 30, 2017US-CERT is aware of active exploitation of a vulnerability in Windows Server 2003 Operating System Internet Information Services (IIS) 6.0. Exploitation of this vulnerability may allow a remote attacker to take control of an affected system.On June 15, 2015, Microsoft ended support for Windows Server 2003 Operating System, which includes its Internet Information Services (IIS) 6.0 web server. Computers running Windows Server 2003 Operating System and its associated programs will continue to work even after support ends. However, using unsupported software may increase the risks of viruses and other security threats.US-CERT encourages users and administrators to review the National Vulnerab

Hey All,I'm pretty new to CF, but learning more every day. I'm using cfdocument to serve up a PDF in the browser when the user clicks on a 'print' button in my app. That works fine, but what I'd really like is for the document to come up in the browser AND the print dialog to come up with it, as if the user had clicked the print icon after the document loaded.The reason I want this behavior is that to get to this point, the user has already clicked a 'Print' button in my web app. I don't want them to have to click that, then see the file, then have to click print again, then have to click print yet again on the print dialog.Here's a link to a PDF that I found that exhibits the behavior I want. http://www.fpdf.org/en/script/ex36.pdf .Here's the code I'm using to generate the PDF:<cfdocument format="PDF" orientation="landscape">    <cfoutput>        <h1>This is a test.</h1>       

Firefox 52x is not rendering pdf's generated from cfdocument pdf page.Instead, I get a prompt to download the page as a cfm file. Works fine in IE and Chrome.Any help would be appreciated.

That's it.  I've finally joined the Creative Cloud.  However, I'm not sure if I'm in the right place.  I signed up for Dreamweaver only for now.  However, my problems don't seem to go away as a direct result.  I recently upgraded from Cold Fusion 9 to CF 2016.  I'm having problems stemming from the incompatibility of my various softwares such as CS5.5(DW, FW, FL, etc.).  Cold Fusion Builder 2016 was free.  Can I use CF Builder 2016 instead of Dreamweaver for a while ??  I still want Flash and the other nice packages that come in the cloud.  But, right now I have so many issues because I haven't upgraded in a while.  It's hard when it finally hits. One community member advised not to use CFFORM because it uses an outdated Ext.js  My website has a form page on it and the text fields are gone from the form page(tedmachine.com/quote.cfm).  As a result the form page is useless and the submit button doesn't do anything.  L

We have a Coldfusion 10 Application that is calling a .NET Class Library (Framework 4.0) which exposes a Base64 String as a Property. On the Coldfusion end, we are converting the Base64 string to PDF and it is being rendered to the users. The issue we are noticing is that the Coldfusion is getting a partial / truncated Base64 string.We have created a test ASP.NET application that mimics the same behaviour of the Coldfusion application and we are getting the complete Base64 string without truncation. Also, the same Coldfusion application works on other internal Webserver without any truncation. Are we missing some setting? 

I have a form fields that allows admins to update the headers & Footers of their site and for the most part it works awesome.Where is falls apart is anytime there is a double apostrophe with no space.Here is the stock Tag Manager:<!-- Google Tag Manager --><script>(function(w,d,s,l,i){w=w||[];w.push({'gtm.start':new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0],j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src='https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f);})(window,document,'script','dataLayer','GTM-WN42FJV');</script><!-- End Google Tag Manager -->On this line:j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src=Google has: +l:'';j.asyncThe 2 apostrophes, when saved in SQL come back as 1 - somewhere in the SQL process one of them is being stripped?This only happens when there are 2 apostrophes in a row with nothing between them.How do I fix this?

Bonjour,Quand je veux redimensionner une image (.jpg), j'ai le message suivant :The  ServerFile image format is not supported on this operating systemmais quand je n'utilise pas cette fonction, le serveur accepte !<cfimage action="resize" source="File.ServerFile" height="300" width="200" name="resized">Merci d'avance pour votre aide

Hello there,I updated my CF server with the latest update and FCK editor does not work anymore. When page is generated, it has<script type="text/javascript" src="/CFIDE/scripts/ajax/ckeditor/ckeditor.js"></script>line, but, I think, it should be<script type="text/javascript" src="/CFIDE/scripts/ajax/fckeditor/fckeditor.js"></script>How can this be sorted?Thank you,Anton

Need some help... Thanks.. I have installed ColdFusion 8 64 bit version onto Windows 2008 Server and am trying to uninstall it, but it won't uninstall. I am using Windows 2008 - Control Panel - Programs and Features area and choose Uninstall. I get an error: Fatal Application Error This Application has Unexpetedly Quit, when I click for details I get... ZeroGr8: C:\ColdFusion8\uninstall\resource\iawin32.dll not found at ZeroGak.a(DashoA8113) at ZeroGak.b(DashoA8113) at com.zerog.ia.installer.LifeCycleManager.b(DashoA8113) at com.zerog.ia.installer.LifeCycleManager.a(DashoA8113) at com.zerog.ia.installer.Main.main(DashoA8113) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.zerog.lax.LAX.launch(DashoA8113) at com.zerog.lax.LAX.main(D

Hello, all,I know that CF has CFDBINFO, but it doesn't return the information I am looking for.The hosting service that I am using for a personal project (hostek.com) puts a limit of 250M on their databases; but you can have an unlimited number of databases.I would like to check the size of a database before uploading files to it.  Basically, if the database is at or near the 250M limit, I want to export some data to an archive table, then finish the upload into the original table.Is this possible in CF??V/r,^_^

We have a little report that writes new data to a pre-existing Excel file that has been working for a while.  Recently upgraded to 2016 and apparently didn't test this report! <cfspreadsheet action="read"        src="#application.loadpath#\#Session.NewWorking#"        name="sObj"        SHEET="2" /><cfscript>spreadsheetSetCellValue(sObj,#val(RA)#,2,2);spreadsheetSetCellValue(sObj,#val(AP)#,3,2);spreadsheetSetCellValue(sObj,#val(GetCHAP.showvalue)#,4,2);spreadsheetSetCellValue(sObj,#val(GetFP.showvalue)#,5,2);spreadsheetSetCellValue(sObj,#val(getrad.showvalue)#,6,2);spreadsheetSetCellValue(sObj,#val(GetClosed.showvalue)#,7,2);</cfscript><cfspreadsheet action="write" overwrite="true"        filename="#application.loadpath#\#Session.NewWorking#"        name="sObj" />Previously it would up

The HTML used to generate a PDF has a reference to the CSS style with font-family Garamond and it is not coming out as the font.Then the Footer added via cfhtmltopdfitem seems to be one font and one only.  Meaning, as a programmer I seem to have no control over the outputed font of the text in the footer cfhtmltopdfitem.Is there something in the jetty engine that can be done to correct this?  We are running CF 11 update 11.  I have installed/confirmed installed the Garamond font is showing in the font management via the CF Admin screens as well.any suggestions are welcome but to use another PDF engine is not an option.  One would expect control over the output of PDF typeface in any system to generate a PDF.Please advise.

Hello,We got a message from out IT department that our SQL Server 2000 databases will get decommissioned. They wanted us to migrate to 2014, but according to the CF9 support matrix https://www.adobe.com/content/dam/Adobe/en/products/coldfusion/pdfs/coldfusion9-support-matrix-4-ue.pdf, CF9 is compatible only up to 2008.So they created a 2008 R2 database server, but when I'm trying to connect to it through the CF9 admin screen I get the following:Connection verification failed for data source: test java.sql.SQLException: Timed out trying to establish connection The root cause was that: java.sql.SQLException: Timed out trying to establish connectionI have no idea what's going on and I'm looking for help. Does it seems like a problem with a firewall? Not sure. Any help is appreciated. Thank you.Edwin

Hi,I want to implement a custom tag for <cfset. I am able to implement but facing issue that i cannot use dot(.) operator in variable nameFor e.g.<cf_set url.value="123"> is not allowed and it gives following error:coldfusion.compiler.TokenMgrError: Invalid token . found on line 8 at column 27. at coldfusion.compiler.cfml40TokenManager.getNextToken(cfml40TokenManager.java:6658) at coldfusion.compiler.cfml40.jj_ntk(cfml40.java:13711) at coldfusion.compiler.cfml40.TagAttribute(cfml40.java:5488) at coldfusion.compiler.cfml40.attribute_list_aux(cfml40.java:5356) at coldfusion.compiler.cfml40.attribute_list(cfml40.java:5334) at coldfusion.compiler.cfml40.cftag(cfml40.java:224)but "." operator is allowed with <cfset url.value and it works fine.Please provide thoughts to resolve it for use of "." with custom tag variable name

HiIs there any way to prevent a XSS attacks in cold fusion in already established project?I used encodeForHTML(url.NewValue) for an input but applying this to every input of Form of all the pages in the project won't be possible.Is there a way to do this from single location without affecting rest of the code in project?

I'm trying to get a silent install package working and while the install completes correctly, running any updates for CF result in a 500 error that I cant resolve.  It does this whether I install the hotfixes through CF admin or manuallyI can reproduce this in my lab every time, but found that if I install CF interactively, everything works great and the updates are successfulI'm not sure what I might be missing in the silent install thats causing this behavior.  VC++2012 is already installed, and thats the only difference I noticed between the twoThe error I'm seeing after updating to hf-11-0011 is below (this is just from CFAdmin).  The update log shows everything is SUCCESSFULHTTP Status 500 - type Exception reportmessage description The server encountered an internal error that prevented it from fulfilling this request.exception java.lang.NullPointerException coldfusion.monitor.error.RequestErrorMonitorEventHandler.onRequestEnd(RequestErrorMonitorEventHandler.java:31

Hi All,I'm trying to edit this piece of code to allow me to edit more than just one field within a multi-record update. However, when I add a second field to the SET, I get this error:"Invalid list index 5. In function ListGetAt(list, index [, delimiters]), the value of index, 5, is not a valid as the first argument (this list has 4 elements). Valid indexes are in the range 1 through the number of elements in the list. The error occurred on line 120." (Line 120 is BESFollowUpStatus)<CFSET Form.totRecords = Val(Form.totRecords) ><CFOUTPUT ><cfloop from="1" to="#form.totRecords#" index="ct">  <cfquery name="Recordset2_UPDATE" datasource="Incident_Reporting">        UPDATE dbo.tbl_P1        SET          AllDocumentsAttached = '#listgetat(form.AllDocumentsAttached,ct)#',        BESFollowUpStatus   = '#listget

I need to install CF11 developer edition on my Linux machine to do a task for the office.  This task involves running a script that auto-generates several thousand HTML tables.My Linux machine currently has Apache2 2.4 installed, and any version of CF below 11 needs 2.2, which I haven't been able to install.When I try to download CF11DE on the Adobe site, that Akamai download manager thing stalls (both on Linux and Windows, on Chrome and Firefox), so despite trying all morning I still can't download it.  Is there any way to get a direct link rather than having to use the silly, unnecessarily complicated way?

Hello, all,It has recently been brought to my attention that someone in Germany has been trying some pretty weird things with our public-facing website, and I'm inclined to believe that these actors are just trying to fuzz our servers.  Pen testing in the wild, so to speak.But then there's that paranoid part of me that is thinking this could be something else, something malicious.This/these person(s) are flooding our web servers with GET requests that are odd:GET/60,83,84,89,76,69,62,108,105,32,123,108,105,115,116,45,115,116,121,108,101,45,105,109,97,103,101,58,32,117,114,108,40,34,106,97,118,97,115,99,114,105,112,116,58,106,97,118,97,115,99,114,105,112,116,58,56,55,56,48,53,52,97,101,48,100,52,54,54,52,100,53,53,98,48,101,49,98,55,50,53,98,51,48,101,57,50,57,34,41,59,125,60,47,83,84,89,76,69,62,60,85,76,62,60,76,73,62,88 HTTP/1.1Someone here managed to decode this:<STYLE>li {list-style-image:url("javascript:javascript:878054ae0d4664d55b0e1b725b30e929");}</STYLE><UL

Will newer versions of CF (cf11 or CF2016) allow you to use Oracle's ojdbc thin drivers (12g) along with REF CURSOR? I know ojdbc drivers did not allow CF ref cursors in older versions... We must use ojdbc drivers:The Oracle JDBC thin driver oracle.jdbc.thin works fine with proxy authentication. But doesn't work with stored procedure REF CURSOR parameters. The ColdFusion documentation for cfprocresult​ states "You cannot use [REF CURSORS] with Oracle’s ThinClient JDBC drivers." Is this statement up-tod-date? Does it apply to the current v11/12 Oracle JDBC driver? Is there any workaround that allows REF CURSOR parameters?

Will newer versions of CF (cf11 or CF2016) allow you to use Oracle's ojdbc thin drivers (12g) along with REF CURSOR? I know ojdbc drivers did not allow CF ref cursors in older versions... We must use ojdbc drivers:The Oracle JDBC thin driver oracle.jdbc.thin works fine with proxy authentication. But doesn't work with stored procedure REF CURSOR parameters. The ColdFusion documentation for cfprocresult​ states "You cannot use [REF CURSORS] with Oracle’s ThinClient JDBC drivers." Is this statement up-tod-date? Does it apply to the current v11/12 Oracle JDBC driver? Is there any workaround that allows REF CURSOR parameters?

0down votefavoriteHi we are using coldfusion10 enterprice edition in our environment, we initiated to move our database to oracle 11g RAC cluster with 3 Nodes (configured TAF). our application is connecting fine to database using SERVICE NAME instead of SID. But where the database failover is not working.when ever a node goes down the connection between application and database is lost, and it is taking several minutes to reconnect.> Tried connecting to RAC using macromedia driver and ojdbc driver's too. > Used Ora Client 11.2.2 to connect but no use, Failover is not working.Please help.