ColdFusion

I am trying to create a page that gives users the option to view or download excel files stored in SQL Server database as varbinary(max)I have googled and searched and figured out how  output images that are stored as binary. I have not been successful yet with excel spreadhseets and I want to be able to do pdf. and word also.  Our DBA will not change the datatype. Any help would be awesome.Thank you - JimCode So far:<cfquery  name="getBinaryXLS" datasource="rapImageTest">          select scopechange_data, contentType, contractID         from Contract_ScopeChanges           where ContractScopeChangeID in (11,12)</cfquery>       <cfset i = 0>     <table>    <cfoutput query="getBinaryXLS">    <tr>        &n

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSAC308487-F029-4f89-BAFB-B410E145E86E.html

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WS371453EC-36D5-44ce-BF1E-750E3016BBD6.html

Hi thereI’m wondering if someone might be able to help with a query I have regarding instance installations. The development agency I have been working for have used ColdFusion for around 10 years and in the last 3 years, started to use a multi instances scenario for their hosting.Each CF (Coldfusion 9 Enterprise) server we have holds and runs multiple sites. These sites range from 250,000+ hits per month sites to some small 10,000 hits per month sites. Our largest server, which my question is regarding, currently has around 70 sites. This server is a virtual windows 2008 datacentre box, with 4 virtual CPU’s and 14GB of RAM. I have currently set this server to have 3 instances in a single cluster, with a sticky session and round robin setup. Each instance, plus cfusion and admin instances, is running from the same jvm.config with the following args (through trial and error):java.args=-Xmx1540M -Xms512m -server -Dsun.io.useCanonCaches=false -XX:PermSize=512m -XX:MaxPermSize=1024m -Dsun.

Lets say I have a numeric list like this.mylist ="1,5,11,17,19"Now I need to remove just 11 from the mylist. (delete_value = 11)How do I  remove the delete_value from mylistIts like the opposite of ListAppend?So I need the new list to be ("1,5,17,19")

Ok here's the problem I have some generated PDFs that contain sensitive information that can't live in the web root.I allow users to view them via a secured admin interface using the following code:<cfheader name="Content-Disposition" value="inline; filename=Export.pdf"><cfcontent type="application/pdf" file="#pdfFile#" />Works fine except when users are running IE8 on XP SP3, these users get a blank screen and nothing happens. Yes, they have acrobat, and so far it has failed on two versions 9 and 10.So I started to check for browsers and added the following if IE8:<cfheader name="Content-Disposition" value="attachment; filename=Export.pdf"><cfcontent type="application/octet-stream" file="#pdfFile#" />and again it works fine everywhere but IE8 on XP. So I tried mimicing a PHP script using the following:<cfsetting enablecfoutputonly="yes"><cffile action="READ" file="#pdfFile#" variable="FileData"><cfheader NAME="Expires" value="Thu, 19 Nov 1981 08:

I have the following 2 files.mycfc.cfc<cfcomponent  output="false">          <cffunction name="set" output="true" returntype="void">                    <cfargument name="text1" type="string" required="true">                    <cfargument name="something" type="any" required="true">                    <cfdump var="#arguments#">          </cffunction></cfcomponent>mycfc.cfm<cfscript>          test = {firstName="Bob in line 2"};          i=1;      &n

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/9.0/Admin/WSfd7453be0f56bba4-2a6b48f122a6582c7f-7ffe.html

The Coldfusion 9.0 Update 2 release document (http://helpx.adobe.com/coldfusion/release-note/coldfusion-9-0-update-2.html) states "do not install ColdFusion 9.0.2 alongside an existing ColdFusion 9.0 or ColdFusion 9.0.1 installation".   Does that mean I cannot install the update to go from v9.01 to v9.02?

We are on our way to launch an application globally that we expect to become very, very large already during 2013. It is totally Cloud based.Can any of you recommend a ColdFusion provider who  can scale and deliver from very small to  extremely large demands from new customers?We come from PHP, have no previous experience with ColdFusion, so we also need a provider with extremely good support. We have just signed up with Hostec.com only to  find that their support is nearly non-existent and that their own software has serious flaws. (I could not sign up this morning because they did not recognize my password. A New password request presented the wrong question combined with the answer from another question).When this takes off it is of  extreme importance that the provider both can scale and deliver quick  and correct support.If you do not want to publish an answer on the web you can send me a private email to tore.john.helle@epicss.comMessage was edited by: To

Yes, that's right. Adobe provides free support for product installation. To make use of this all you need to is reach out to cf.install@adobe.com with your installation issue.If you also face any issue with the updates that we release, you can reach out to this email alias for support.Note, support is limited to product installation only and installation does not include network installations, silent installs to a network environment, database configuration, clustering, distributed set-up of servers, or any other similar set-up or activities.

The new cumulative hotfix for ColdFusion 9.0, 9.0.1, 9.0.2 includes support for Google Maps JavaScript API v3 and JDK 1.7 Update 15.These Cumulative Hotfixes consists of previously released cumulative hotfixes and security updates.Details of cumulative hotfixes are here - 9.0, 9.0.1, 9.0.2ColdFusion 10 Update 8 includes support for Google Maps JavaScript API v3, Mac OS X Mountain Lion 10.8 and JDK 1.7 Update 15. It includes all the bug fixes from previous updates of ColdFusion 10. You apply this update using the update mechanism within ColdFusion 10 Administrator.For more details about the update, refer the link here.

Noob.. installing CF10, Developer, says I don't have permissions to for my Startup Items folder, but I'm the only user. Is it because my MacOSX password is (purposely) blank?Also.. "Enter the username and password for remote start/stop administration." ... does this mean create one or that I should have one (from where?).  I do use a CF host (YoHost) ... is it that info?Like I said... Noob!Just trying to deploy a new app and use my Mac to test... is this possible or is a remote server a required component?- Rand

Where can I find the ColdFusion 8.0.1 Updater?I can see hotfixes for 8.0.0 and 8.0.1, but nothing to take me from 8.0.0 to 8.0.1......

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/Installing/WSc3ff6d0ea77859461172e0811cdec18a15-7ff0.html

Where can I download coldfusion Builder 2.0.1 plug-in

I have a CF site I am transfering to a new hosting company. I'm having trouble connecting to the db. I did not develope this site. It seems the developer used a configuration.txt file to connect to the database. See below. The part that stands out is that there is no username and password. What is the attribute name for the username and password. I tried username: and password: but they do not work.# The following is the configuration file for the CMS.  Lines starting with a pound sign are ignored.# The format is: <Attribute Name>:<Attribute Value>##############################################################webSiteName:MySitewebSiteEmail:no-reply@mysite.comwebSiteFormRecipient:cgriffin@mysite.comwebSiteLogo:/images/logo.pngwebSiteLogoHeight:124# If cobrandLogo is set then an additional logo will be shown.  This is used for allowing clients to brand the CMS.cobrandLogo:images/mysite.com############################################################### The following v

Since applying the latest security patch I am receiving the below events and it has broken two of our apps.03/15 11:54:38 error ROOT CAUSE: coldfusion.filter.FormScope$PostParametersLimitExceededException: POST parameters exceeds the maximum limit specified in the server.    at coldfusion.filter.FormScope.parseQueryString(FormScope.java:397)    at coldfusion.filter.FormScope.parsePostData(FormScope.java:346)    at coldfusion.filter.FormScope.fillForm(FormScope.java:296)    at coldfusion.filter.FusionContext.SymTab_initForRequest(FusionContext.java:377)    at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:33)    at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)    at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)    at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:126)    at coldf

I raised bug 3119991 (coldfusion.util.key leaks) against CF9.01 and CF10.The bug is marked as "Fixed in build 281656".  We have upgraded our production servers to 9.02 and it appears that the bug has returned.  I decompiled the cFusion.Jar's for 9.02 and it's using HardReferences for the key cache. The fix for 3119991 used SoftReferences so I suspect the fix never made it to 9.02.The problem is that we can't apply the hotfix (hf901-3119991.jar) to 9.02.  When we try, it does not appear in the applied hotfixes area of CFAdmin. When we copy the .jar to the /lib/updates folder & cycle the CF service the OS never takes a lock on the .jar file and we still have that exact same memory leak - which makes me think it isn't being picked up.What can we do to get the HotFix working with 9.02?

GreetingsI apologize in advance if this seems too easy to do- but I am missing something.I have 8000 records in an Access DB (I know- it's going into SQL soon) in which all  the departmental office IDs need to be updated.The column in the main table  is named "q_office_ID".The user table includes  user_ID &  office_ID.The office table also includes office_ID.This UPDATE sets all the values to the number 10?:<cfquery name="update" datasource="#Request.BaseDSN#">SELECT     queue_ID, q_user_ID, user_ID, office_ID FROM     main_helpdesk, lookup_userWHERE  q_user_ID = user_ID</cfquery><cfloop query="update"><cfquery name="updatedata" datasource="#Request.BaseDSN#">UPDATE main_helpdeskSET q_office_ID = #office_ID#</cfquery></cfloop>I know there is something obviously wrong with the update- any help would be greatly appreciated.Thank You

Hi All,I am new to CF. Just i started working with CFSpreadsheet.I have one xlsheet which conatins the row header and i am reading xlsheet with query.what i want is i dont want to read 1st row(Header row).I tried with all options but i am not getting the things.Please help me.even though i update to my CF to  9.0.1.Please find the follwing the code snippet.<cfspreadsheet action="read"  src="#GetTempDirectory()#/msepdata_test1.xls"  excludeHeaderRow = "false"  sheet="1" query="queryData" />RegardsSateesh

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/Developing/WSe61e35da8d3185183e145c0d1353e31f559-7ff8.html

Does anyone know how I can convert wav to mp3 using CF9 or custom tag to do so please?

I have a form that is running on a CF10 server. On some not all machines  the user gets 500 error wants they log in.  The form is using a ColdFusion cookies.  If the user does not have cookies turned on will they get a 500 error? or is that something else?  Thanks. in advance. 

As part of the "Adobe ColdFusion 9 Server Lockdown Guide," Adobe recommends blocking /CFIDE requests (pages 9 and 10).  After adding a <denyUrlSequences> block to the applicationHost.config file, located in the \windows\system32\inetsrv\config directory, the instructions say,Next, you must allow access to the /CFIDE/administrator URI in the cfadmin website.  Create a file called web.config in the web root with the following content: . <configuration>     <system.webServer>          <security>               <requestFiltering>                    <denyUrlSequences>                         <remove