ColdFusion

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?

I have not found the combination for adding a new Coldfusion Server in Flash Builder 4.7 or Coldfusion Builder 2.01 with Coldfusion 10. I am running windows 7 64bit. on IIS 7. Coldfusion 10 is running fine. All was well with Coldfusion 9 Flash Builder 4.6 and Coldfusion Builder 2.0. Local Server Settings for CF9 were Server Home C:\Coldfusion9Document Root   C:\inetpub\wwwrootVersion: 9.0.xNow as soon as I put in C:\Coldfusion10 or C:\Coldfusion10\cfusion I get an error "Server home is not valid".Any hints on getting this going.

Hello, all,According to Adobe documentation, REreplace() (ergo, REreplaceNoCase(), too) requires three arguments: the target string; the regex match; and the value to replace that match with.  The docs also state that the third argument is a string.  Nothing is mentioned of using a function for the third argument.But in JavaScript (ex: str.replace(x,y)), while the prefix str is the target string, the two arguments that go inside the parenthesis are the regex or substring match, and the replacement - which can be either a string, or a function.The reason I bring this to attention is because in the past I have needed (and now would like) to write something that will convert HTML entities into the character said entity is supposed to represent.  But I have had no success by using just a string as the replacement.For example:  Say I have a string, such as "This is a test&#59; this is only a test."  (Yeah, I know, VERY basic.)  Well, I don't always know tha

Hi,I have ran into a problem, fresh after migrating  to IIS 8.5 (from IIS 6), CF 11.07-ent.Does this make any sense to the pros out there?Here is what I would see:In taskman, as SOON as the Max JVM Heap memory was reached (for coldfusion.exe), CF would become partially or fully unresponsive.I understand about connector tuning, and that is not the problem here. Here are the isapi_redirect log lines:----------------This first line shown below is the LAST line in the log having to do with connections (as you can see, I am a long way from maxing out. Also, my server.xml file's MaxThreads and Timeout are set to 1600 and 60000 and I only use one wsconfig/x, and one application pool, for a total of 1600 connections. I was very stable with these same numbers in IIS6)[1532:3796] [info] ajp_process_callback::jk_ajp_common.c (2244): (cfusion) current reuse count is 91 of max reuse connection 800 and total endpoint count 1600then hits error condition[1532:3796] [info] jk_open_socket::jk_conne

I have this cfhttp tag.I want to log the URL to see if it's actually having all the correct parameters because it's not working.<cfhttp result="objRequest" url="#UrlDecode( strTargetURL )#" method="#CGI.request_method#" useragent="#CGI.http_user_agent#" timeout="15">

Guys,I've got a SOAP request that is requiring me to use MTOM attachments (to pass along the credentials). I was wondering if anyone has seen/read a tutorial as to how best to do this?  I'm not seeing a whole lot of documentation in CF10 for this feature.  Any help would be much appreciated. Best,Nadav

Hi,We are getting frequent hanging issue of Coldfusion 11 on Windows Server 2008 R2 Enterprise. In this case we are unable to track down the root cause of the problem to address it.Currently we need to manually restart Coldfusion 11 service in such situation and in some cases when the service fails to restart, machine need to be restarted.Coldfusion 11 is installed in integrated way with IIS. At the time when Coldfusion service gets hanged, all other IIS applications are running smooth without any trouble. During hanged state, request to Coldfusion pages either die out after a while or gets an error message like services not available.We need help in tracking down the root cause and to address it.Recent error log is as follows. At this time, service was restarted manually from Windows Services. There are no relevant logs prior to service hanging or during the time when service was hanged.Windows Application Log:Time: 11-02-2016 10:29:12Event ID: 263Level: ErrorSource: Coldfusion 11 App

Hi there,I'm upgrading both my CF from 9 to 11 and my server, from a self hosted on premise server to a VM cloud based solution.Current server is running CF9 in production and I cannot shut it down until cloud environment is fully set up and tested.Security audit won't be executed on a trial/developer edition so that I need to have both server (on prem and cloud) running simultaneously with a production version of CF for a while (say 2 weeks).Am I allowed (terms of license) to do so ?If I run the upgrade process (from CF11 trial/dev edition) on the new (cloud) server using my CF9 serial, will it deactivate the license from the other (on prem - CF 9) ?Is there a specific action I can have to be 100% sure the current production server (on prem CF9) won't be affected ?Any official answer from Adobe greatly appreciated, also users' experience welcome !BR, thanks in advanceAntoine.Ce message a été modifié par : Antoine BAPST - Reason : seems no one at ColdFusion level is able to answer this

Brand new CF 11 install on Windows 2012 R2.  I have a cluster of servers running so I disable the client variable purge process on ALL serves.  Although the purge process is disabled I still see "Run Client Storage Purge" messages in the coldfusion-out.log.  I want to ensure client variable purge is NOT running on each server.