ColdFusion

The following codes take more then 12 hours to run for only more than 300,000 records in the table. How do I speed up the process? Is there another way to generate the json object and feed into the cfhttp in a faster manner? Thanks.----------------------------------------------------      <cfquery name="getData" datasource="#request.dsn#">          SELECT     District, Route, DateTime, Site, TicketNumber, Tons, CommodityCode, GeneralCommodity, DateCreated                FROM         tSolidResourcesTonnages      </cfquery>      <cfif getData.recordcount gt 0>          <cfloop query="getData">             

First of all, I know nothing about Cold Fusion. Long ago our company had setup a few Cold Fusion web servers using Cold Fusion 8. Our Cold Fusion developer was downsized, but the web sites continued to be used. Well, now we need to upgrade those servers. What is the process for going from Cold Fusion 8 to 2016? We are planning on setting up fresh VMs and installing Cold Fusion 2016 from a fresh Windows install and just moving all the files over. Not knowing anything about Cold Fusion, will this work? These are pretty basic web pages for the most part. There are some forms. Any help to get me started in the right direction would be appreciated.

Hello, all,It seems that the performance issues haxtbh mentioned regarding reverse DNS lookup on CF11 is way worse than I expected, and apparently not a problem in CF10.  OR, it could be a certain unwelcome 'bot'.  Which brings me to another question.Instead of the CF method of reverse DNS (as it pertains to cgi.REMOTE_HOST), is there a way to get Apache to do the reverse DNS lookup and pass that along to CF?! ! ! OR ! ! !Is there a way to cache the reverse DNS value (cgi.REMOTE_HOST) so that it can be fed from memory?I suspect that it is the dreaded LegiStorm bot (legibot) that is causing our issue of our metrics query timing out ("The request has exceeded the allowable time limit Tag: CFQUERY ").  The error email includes the agentstring "LegiStorm Bot (http://www.legistorm.com/legibot.html)".I think the bot is hitting our server hundreds of times a second (just a guess), causing our DNS lookup to do the same, and the target server is blocking the request after x numbe

I wanted to recently switch to apache and leave IIS out of my equation...having nothing to lose, I archived my web sites and removed IIS support, uninstalled CF 11, added apache 2.4, switch to CF 2016 (this is all local only, windows 10 box, fully OS patched) and that was an epic fail.So back to IIS and CF 11...epic fail again.  I can, in both cases, get to the administrator AND the default IIS root (localhost/) but when I create a site in IIS, I get no errors, just a blank site.I have been looking everywhere over the weekend and everything always seems to blame WSConfig or some missing "stuff" in IIS...maybe no jakarta virtual directory, etc., etc...but none of those things seem to be wrong.  WSConfig seems to operate...the configuration directories have the files, IIS sites (all of them by my choice) have cfide and jakarta virtual directories created in them pointing to the right directories...manual checks on mime types, handlers, isapi filters...everything looks as both I

Guys,Anyone know, how can I solve this stub objects problem, follows below:The ws is hosted in a Linux environment.When I put the ws address in the browser, works without problem.Tks,Fabiano Magno Pechibella

Hi-I am trying to crate an api that returns JSON from a set of queries in  function main.cfc when I try to run this main.cfc I get this errorSecurity: The requested template has been denied access to D:/home/windsorparking.com/wwwroot/szh/szh/myapis/toJSON.cfc.The following is the internal exception message: access denied ("java.io.FilePermission" "D:/home/windsorparking.com/wwwroot/szh/szh/myapis/toJSON.cfc" "read") ColdFusion cannot determine the line of the template that caused this error. This is often caused by an error in the exception handling subsystem.My Calling Program getfares.cfm<cfparam name="form.userid" default="4"><cfscript>obj = CreateObject("component","main");qFares = obj.getFares(argumentcollections = form);//mydata = obj.queryToJSON(qFares) ; //myjson = obj.structToJSON(mydata);if(!findnocase("[",qFares))mydata = "[" & replace(qFares,"/","","All") & "]";elsemydata = replace(qFares,"/","","All");</cfscript><cfprocessingdirective sup

Hello,I come here once again seeking help on a problem that I can't find any information about.  I don't have much hope as the last few times I've posted here I have not even gotten a response, but I don't know where else to turn when nothing on web searching is relevant.I'm trying to get my company upgraded to CF2016 from CF9.  I've gotten around a lot of problems so far, but I've ran into another one.  One part of our software needs to use <cfexecute to run some commands on the server.  Specifically, SVN commands for our deploy to production process.  In CF9 we were able to run <cfexecute without any issues.In CF2016, when I try to execute a file I'm getting:An exception occurred when invoking an external process.The cause of this exception was that: java.security.AccessControlException: access denied ("java.io.FilePermission" "/coldfusion_apps/deployer/test.sh" "execute").As you can see here, I've created a simple test.sh file for testing purposes.&nbs

Hi We have ColdFusion set up on two servers through a netscaler.  The IP Address presented back to the CF server is always that of the netscaler, which means we can't enable debugging on a certain IP address, as all users will get the debug messages.We've configured the Netscaler to present the Client IP in a separate header variable (Client-IP).  Is there a way of telling ColdFusion to use this variable for the debugging IPs, rather than (I presume) REMOTE_ADDR ?Thanks

We have a fairly large site that's divided into distinct topics. The site runs off of a single database that contains some page details, like the contact person for that page, along with some other info.Since I don't want to query the entire database every time someone hits a page, I use a cached query, and I do one for each topic (since some topics get a lot of traffic, and some get almost none).What I have looks something like this:<cfset request.qname = request.topicname> (this topic name is set in application.cfc)<cfquery name="#request.qname#" datasource="myDSN" cachedwithin="#createtimespan(0,8,0,0)#">SELECT....FROM...WHERE topicid = <cfqueryparam value="#request.topic_id#" cfsqltype="cf_sql_numeric"> (this topic ID is set in application.cfc)</cfquery>That pulls the info for all pages in the topic and holds it for 8 hrs.  Then for each subsequent page visit in that topic, I have this:<cfquery name="details" dbtype="query">SELECT ...FROM #request

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