ColdFusion

I have an application running CF8. One of the CFCs is very large and breaks when trying to upgrade to a newer version of CF.I use the functions in the CFC to build html docs that can be displayed or emailed. How should I go about refactoring this cfc to make it work?Format is currently like this:function - get order     stored procedurefunction - get order details     stored procedurefunction - display order     several hundred lines of html that get pulled back to the web page or emailed

Hi,Since migrating from CFMX7 to CF11 we are experiencing some weird failure with cflogin (using session or cookie storage).Basically when we log-in on the application after a session/client timeout the first login doesn't last for longer than the login submit request.The second login however is OKI made a very simple application.cfc/index.cfm with short timeouts to check this:<cfcomponentoutput="false"hint="I define the application settings and event handlers.">        <!--- Define the application settings. --->        <cfset this.name = hash( getCurrentTemplatePath() ) />        <cfset this.applicationTimeout = createTimeSpan( 0, 0, 10, 0 ) />        <cfset this.sessionTimeout = createTimeSpan( 0, 0, 0, 10 ) />        <!--- Set up the application. --->    &

Hello, all,I've got a project where I need to use a list as part of the WHERE clause for a QoQ, and it's breaking.  I'm not sure what I'm doing incorrectly.For some pseudo-code, pretend I have a full query from a database called "people".  I get a list of values for the QoQ with the first query; the second query is my QoQ: <cfquery name="getDIR" datasource="#request.THISDSN#">     SELECT thisName dir FROM orgs WHERE thisID in (<cfqueryparam value="#form.org#" cfsqltype="cf_sql_varchar" list="yes" />) </cfquery> <cfquery name="people" database="people">     SELECT colA, colB, colC, colD     FROM people     WHERE 1=1         AND (             div IN (<cfqueryparam value="#valueList(getDIR.dir)#" cfsqltype="varchar" list="yes" />)             OR d

HelloWe are using CF 9 Enterprise and use CFCHART for reporting application, we are now getting a message below charts which says "WebCharts3D Invalid License", why is this message appearing ? what's the resolution ?

I have been receiving ORA-28040: No matching authentication protocol in CF11.  I have tried the SQLNET.ALLOWED_LOGON_VERSION = 8.  Our Oracle 12c DB is not a CDB so the changes to listener.ora will not work.  Any other suggestions?

Hi,CF2016 system requirements from here:https://helpx.adobe.com/coldfusion/standard/system-requirements.htmldoes not list Windows 10 support.Will CF2016 be supported on Windows Server 2016 when it releases?Regards, Carl.

Adobe　CC　にログインすると、「414　Request URI too Large」の表示が出てしまい、ログインできない。再起動してもダメでした。使用しているブラウザはIE9

Below is my current code, i recently changed the format set to html from flash to render in html.but i noticed from the time, i changed the format = html, the first and last row columns are not showing or generating,so when i run the below code, im only seeing the Step, Operation, RevCode columns, but not the KeyID or StatusID columns.what am i doing it wrong.But when i set the format = "flash" everything works fine, im able to get all the columns correctly displayed. <cfgrid name="Setup_grid" height="200" width="900" align="LEFT" autoWidth="yes"     query="Finalquery"     insert="No" delete="No" sort="Yes" fontsize="14"     bold="No" italic="No" appendkey="Yes"     griddataalign="LEFT" gridlines="Yes"     rowheaders="Yes" rowheaderalign="CENTER" rowheaderitalic="No" rowheaderbold="No"     colheaders="Yes" colheaderalign="CENTER" colheaderfont="Arial" colheaderfontsize="12"     c

I am trying to create a locked version of spreadsheet before letting users download it. The password function for cfspreadsheet does not seem to work. the basic operation is this: I read an existing spreadsheet, and then I write it to a new file using the password option. But the file is not protected. I have looked at cfspreadsheet password, but that is not giving me any insight to the issue. I have also tried to use spreadsheetfomatcellrange function to lock all of the cells in the sheet, but that didn't work either. On a secondary note, I am seeing some behavior that I wasn't expecting. The Excel file that I am trying to recreate has 3 sheets. When I read the file, I am getting all three sheets and not just the first one. Then when I write the sheet, I am getting all three sheets in the new file. I was expecting to have to read each sheet individually then then write them individually as well.<cfset xfile = '#application.doc_directory_file#' & '#URL.fname#'><cfset new_f

Is it online anywhere?  I was able to upgrade to 12 but it would be nice to have an online reference to the documentation.

I found what I would think is a somewhat big incompatibility between CF11 and all prior CF version: multiple checkbox and select values. If you have multiple checkboxes "checked" that refer to the same variable name, prior to CF11 these came in as a list; in CF11 they come in as an array causing "Complex object types cannot be converted to simple values." My question to Adobe, was this intentional or a bug?

Windows Server 2012 R2 and IIS.I cannot log into CF Administrator after doing a clean install of CF11 with purchased standard license. I was running the trial version before this clean install with no issues. Browser indicates "Waiting for 127.0.0.1.....", both FireFox and IE.CF services are running. A .cfm page of my creation renders fine. Checked the CF log coldfusion-out.log file and shows successful admin login.Tried changing password with passwordreset.bat

I am faced with doing a huge migration, so I am going through history to make sure I capture every change and review it prior to this push.Is there any way to export a list of the History, preferably to a spreadsheet, to make this task easier?RLS

Is there a way to unzip without writing the PDF file inside the zip to disk but directly to the browser for downloading?

Cannot start the Coldfusion 2016 new release on a Mac. The instructions say go to cfusion/bin and type coldfusion start. Go to WHERE in cousin/bin?

My site imports an xml file which is encoded in Cp1252 from a windows machine. But when i try to parse it I get the following error "Invalid encoding name Cp1252". Somehow my site which is a Linux machine can't read it. Does anyone know how to resolve this?My solution was converting it tot UTF-8. Changing the encoding attributes to UTF-8 does the trick but not on all xml files. Every now en then it runs into a character it doesn't know. Does anybody know how tot convert de character tot UTF-8 using coldfusion (11).

This is replicated from StackOverflow's "Server Fault" site. The CF community there is under represented, so I'm posting here too.  Sorry for "cross post".This is on Windows 7 Home Premium edition.I have got two ColdFusion 10 (updater 2) instances: "cfusion" (the default one), and "scratch".I have got a single instance of Apache 2.2 running.Within Apache, I have set up two virtual hosts, each of which needs to be served by a different ColdFusion instance.Each of the CF instances serves files fine via Tomcat's internal web server. Apache serves vanilla HTML files fine too. So both CF instances, and both virtual hosts separately work OK.I can get wsconfig.exe to connect either one of the CF instances to the Apache server, and serve CF files via Apache & that instance.However I cannot find a way of connecting the second CF instance to Apache as well, so that both CF instances are conected, each serving one of the virtual hosts. WSConfig doesn't seem to understand the notion of "m

This is my current and outer cfloop. How many nested cfloops do I need to get to data.current_version.en.text field? My guess is two loops but I'm not sure about specifying the value for the "to" in the cfloop.<cfif structKeyExists(cfData, 'data')>        <cfoutput>            <cfloop index="i" from ="1" to="#arrayLen(cfData.data)#">                            <h1>#cfData.data.searchTitle.en#</h1>            <p>#cfData.data.current_version.en.text#</p>            </cfloop>        </cfoutput>    </cfif>  And this is what the struct looks like.

I have the following custom-application.cfm file and I kept getting the above error when trying to login.<!--- Custom-Application.cfm ---><cfparam name="Cas_Server_Secure" default="https://ash.owl.com/cas"><!--- <cfparam name="ReturnURL" default="http://#cgi.server_name##cgi.script_name#?#cgi.query_string#"> ---><cfparam name="ReturnURL" default="http://#cgi.server_name##cgi.script_name#"><cfparam name="Session.CAS" default=""><cfparam name="tempMember" default=""><cfparam name="strstart" default="0"><cfparam name="strend" default="0"><cfparam name="teststring" default=""><cfparam name="strtotalmember" default=""><cfset session.updatedForGolive = 1 ><!---include adf core---><cfset request.scriptsExecuted = ""><cfinclude template="/ADF/core/load_site_adf.cfm">          <!--- <cfif not IsDefined("url.ticket") >    <cfset ReturnURL = URLEn

It appears that CF11 Update 7 broke the debug output by removing “tagcontext” from the “stacktrace” structure. For pages that are below the top level page all debug output after the “Execution Time” heading disappeared. The fix is simply to remove the string “.tagcontext” from all lines in the debug template. This applies to all templates that I could find. I hope this gets to Adobe.

I have a very simple example for sending an image as an attachment using Coldfusion 11 cfmail tag.<cfmail to="example@domain.com" from="example@domain.com" subject="Test" type="html">     <cfmailparam          file="www.example.com/image.png"          disposition="attachment; filename=""test.png"""></cfmail>I want the attachment to be called "test.png" when it is viewed in the recipients email client.It works fine when I receive the email in Gmail, however Outlook 2013 (and Office 365 web client) retains the "image.png" attachment name.Have I correctly made use of the "disposition" attribute?

Our Oracle DBA is looking at moving us from Oracle 11g to 12c and is asking which sub version of 12c does CF11 support, the 12.1.0.1 or the one that was release this last fall - 12.1.0.2? He, of course, would like to install the latest 12.1.0.2. Thanks!

We are in the midst of a regular maintenance downtime and our systems engineer went through standard tasks to restart the coldfusion application and was not able to. She has restarted the entire server and still is unable to restart the application. She rolled back to her first snapshot when all was working fine and is still not able to restart successfully. As far as we can see, any changes that were made initially should not have impacted anything. But even after she rolled back to the original snapshot, we still can't restart. Any insights? Thanks so much.

Hi all,I am very new to cfscripts.I am having below function  <cffunction name="newReplace" > and whenever I am calling this function I am getting java.lang.StringIndexOutOfBoundsException: String index out of range: -1 error.I think I missed some validation to check the null but unable to identify. <cffunction name="newReplace" returntype="string" description="Replace the original CF9 Replace() and ReplaceNoCase() which don't support some UTF-8 string">  <cfargument name="stg" type="string">  <cfargument name="origStg" >  <cfargument name="rplStg" >  <cfargument name="all" type="boolean" default=true>  <cfargument name="caseSensitive" type="boolean" default=false>  <cfset var result="">  <cfscript>  var oStringBuffer = createObject("java","java.lang.StringBuffer");  var i = 0;  var tmpStg = "";  oStringBuffer = oStringBuffer.init(arguments.stg);  while(i + origStg.len

I migrated a CF site to a server the only supports up to CF8. Does anyone know where I can download CF8 developer edition?