ColdFusion

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.

I am stuck on how to connect coldfusion 11 with Oracle RAC any body can help on this.ThanksNAF

My Company has been stuck on CF9 for a while now due to some Informix database issues caused by the switch to Tomcat instead of JRun in CF10.  We finally have gotten a work around for the problem from IBM and I am working on getting stuff migrated to CF2016.  There are quite a few issues to work through because of the large version change, but I've ran into two problems that I simply cannot find a way to resolve myself and neither comes up with many results on the web.First off the less important issue, but something I'd still like to figure out.  If I'm using the built in tomcat server, and navigating to a local CF2016 server at port 8600, I get dropped connection issues or something.  The error I'm seeing is:GET http://localhost:8600/emr/ net::ERR_INCOMPLETE_CHUNKED_ENCODINGI cannot find any reason for this to be happening...  I've completely blown away the entire server configuration reconfigured it from scratch multiple times and continue to see this error

I'm using CF10.I want to output a count of events by the month they happened each.Each month will always have at least 1 event, so I'm not worried about months with 0.This is showing me the 12 months in order, but adding them up.The query is retrieving records back through the last 3 years.Where did I go wrong?I want to show the months in order for the last three years.<cfquery Name="OccOpenChart" datasource="#APPLICATION.DSN#">SELECT  COUNT(OccurrenceNumber) As OccTotal,    year(DateofReport) as OccYear,    month(DateofReport) as Occmonth  FROM OccurrenceDateTracking  WHERE Year(DateofReport) > #thisyear#  GROUP BY year(DateofReport), month(DateofReport)</cfquery><cfchart  format="png"  chartwidth="750"  chartheight="500"  showlegend="yes"  xaxistitle="Year of Report"  yaxistitle="Occurrence Count"  show3d="no"  tipstyle="none"  fontsize="12">    &nbs

Hello all,I'd like to ask you if there is CF 10 Installer compatible with WS 2012 R2 anywhere? We have our CF 10 license bought few years ago and now CF 10 server running on the old machine running Windows 7 and now I have to migrate this "server" to the new virtual machine running 2012 R2 but installer on CD doesn't work on this system (there is some error with Java if I understand well).So I was looking for newer installer on the web but it is nowhere to find. There are just some Update packages, but these are for nothing to me if I couldn't install the basic version.Could anybody PLEASE provide me any download link to some new Installer of CF 10 for Win Server 2012 R2?I tried even unpacking installer and changing the java package, but it keeps showing the same error, and all the answers on the web to this error are "Install newer version of CF" so ... I'm clueless.Thanks in advance

Hello, all,I am trying to re-write part of an application that loads images from a database into a carousel.Currently, the logic grabs the BLOBs from the database, saves them to a folder, and then displays the images.I'd like to grab the BLOBs and directly display them on the page without saving them to a folder.  However, after all the Google search attempts, I have not found a solution - they all want to use CFIMAGE action="writeToBrowser".Unfortunately, the directory that these images are saved to with writeToBrowser action is blocked by network admins and the people who control the CF server.  So I _can't_ use CFIMAGE.Is there a way to take the BLOB images direct from database to browser without using CFIMAGE??V/r,^_^UPDATE: We need to be able to support IE9+, possibly IE8, and FireFox v42+.

Hello CF Community,I recently upgraded from ColdFusion 10 to ColdFusion 2016 and I noticed that I can no longer access any pages that live in any folder named /api/.For example: www.mysite.com/api/index.cfm now returns a 500 error "Application could not be found".  See the following screenshot:http://i.imgur.com/axFVekv.png Note: when I installed ColdFusion 2016 I didn't select to install the API Manager service nor do I need it.  Thanks for your help!

Hi,I'm trying to convert some "manual" soap request to the cfinvoke/createObject method, and i find strange to have to do the thing i did ^^Here is the previous code:<cfxml variable="LOCAL.SOAP_Request"><cfoutput><?xml version="1.0" encoding="UTF-8"?><soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">  <soap:Header>    <AuthenticationHeader xmlns="https://soap.namebay.com/">      <sLogin>#variables.login#</sLogin>      <sPassword>#variables.password#</sPassword>    </AuthenticationHeader>  </soap:Header>  <soap:Body>    <oGetAutoRenew xmlns="https://soap.namebay.com/">      <P_sDomainName>#ndd.domain()#</P_sDomainName>    </o

We are migrating from CF9 to CF11.CF11 clears client variables (other than the reserved) in new application, unlike CF9 which retains all client variables.  Is there a patch to fix this bug?

I know with CFCONTENT TYPE tag I can convert my data to excel format. Is there a way to convert database tables, certain records to a dbf format?

I have been evaluating CF 2016 before purchasing to upgrade our server.One of the key interactions we have always had was between CF and ActivePDF Toolkit.I have spoken with ActivePDF support, and they have recreated the same issue I am reporting here with CF 2016.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."It has been verified that Get_OutputByteStream in ActivePDF is creating a good PDF by writing the variable named "pdf" to a pdf file on the server.As a side note, I also noticed and verified with ActivePDF that CF 2016 cannot seem to handle COM properly, so I have to used the .NET integration in working with Active

CFers,It's possible get what is region, country or city using the setLocale from ColdFusion Server?For me the more important is get the city where the user live.Best,Fabiano Magno Pechibella

Is there a way in ColdFusion to resize images to a specific size and show them in browser, without a need to store the resized images in folder. So the concept is only storing the original image file and show the other (resized) images without storing any where in the server.Any help!!

I need to move a web service from an old ColdFusion 8 server (running from SQL 2005) to a new ColdFusion 2016 (running from SQL 2016).The web service is just a basic .CFC file which is coded like this:<cfcomponent output="false">   <cffunction name="getinfo" returntype="query" output="no" access="remote">      <cfargument name="variable1" type="string">       <cfargument name="variable2" type="string">       <cfargument name="variable3" type="string">              <cfquery name="qryName" datasource="database_name"> select columns from table      </cfquery>        <cfreturn qryName>    </cffunction> </cfcomponent>My vendor using the web service is receiving this error:Unable to generate a temporary class (result=1). error CS02

Just installed 2016 on a test server ... it had 10 before. After install, brought up Admin panel ... it did its thing. But all I get is an error below. Checked for CFIDE and jakarta ... usual mapping.  They were gone. Added their directories in Windows IIS. Made sure CF10 shut down, 2016 running. yes. Ok, what am I missing?The service is unavailable.Service Temporary Unavailable!The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.   Jakarta/ISAPI/isapi_redirector/1.2.32 () Copyright © 1999-2011 Apache Software FoundationAll Rights Reserved

Been using this version for 3 years ... it's always been very reliable ... as in not crashing. Using it on a 7 year old laptop.  Apple Mac running WindowsSuddenly ... in the past two weeks it starts crashing.  Once a day ... then twice a day. I have changed nothing.  Except added more and more code. Am replacing laptop next week in case hard drive going.  But are other having this problem?It happens at any time ... typing, idling, then BOOM!