ColdFusion

I'm trying to improve the performance of my ColdFusion 10 application by making better use of caching.  I have a particular DAO/Gateway CFC that queries a particular database.  I added query caching to the query in this CFC and it made a huge difference.Since this database is outside my control for edits/updates, I need to be able to initiate flushing of the cached queries for this database only.  I don't believe the built-in ColdFusion ehcache query cache allows for granular control of flushing - in CF Administrator you pretty much can only flush the entire cache.So I figured the only solution was to create my own cache region that would be associated with just this database, and manually cache the queries into that region.  Then I can flush just that region without impacting any other cached queries.So here's my difficulty:  I believe that Internally, ColdFusion caches queries using a hash of the generated SQL.  I'm thinking I'll store my queries in cach

trying to install ColdFusion 10 Mandatory Updateon mac 10.8newbie at terminal - need helpI have the  file cf10_mdt_updt.jartried this... for mac stanalonetyped = java -jar cf10_mdt_updt.jarUnable to access jarfile cf10_mdt_updt.jarprobably needs a path top the file - what do I type to get this working?http://help.adobe.com/en_US/ColdFusion/10.0/Admin/WSe61e35da8d318518-33adffe0134c60cd31c-7ffe.htmlhttp://helpx.adobe.com/coldfusion/kb/coldfusion-10-mandatory-update.htmlhttp://help.adobe.com/en_US/ColdFusion/10.0/Admin/WSe61e35da8d318518-33adffe0134c60cd31c-7ffe.html

I have a form which has a drop-down select box. What I want to do is send the value from the select list to a CFC which runs some SQL code and returns a recordset. I then want to use this recordset on my original CFM page that has the form on it.Is it possible to do this without refreshing the page through some kind of AJAX? Apologies I am a newbie at AJAX but I did manage to write a bit of code that uses <cfdiv> to bind to a URL that does the database work and returns some HTML. But really I just want the database recordset and not sure how to get it?

Any ideas about whats going on here?The value of the TYPE attribute, which is currently ”CORBA”, must be one of the values: CORBA,COM,COMPONENT,JAVA,DOTNET,WEBSERVICE,.NET.

Hello my friend , im using coldfusion 9;Firstly How can i enabled ORM ?im have application.cfm file and i convert application.cfm file to application.cfc code is below,Application.cfc<cfcomponent output="false">          <cfscript>                    this.name = "test";                    this.sessionManagement = "Yes";                    this.sessionTimeout = CreateTimeSpan(0,0,20,0);                    this.setClientCookies = "Yes";                    this.clien

Hello.I'm using ColdFusion 9 and I have a question.When we have a form with required fields coded like this:<cfinput ... required="yes" message="Enter a value 1" /><cfinput ... required="yes" message="Enter a value 2" /><cfinput ... required="yes" message="Enter a value 3" />When user sumbits this form he will se an alert window:Enter a value 1Enter a value 2Enter a value 3How can I make it other way so then one single message is outputted like:"Enter values for all required fields"Not one message for each required field.Sorry for my imperfect English. Thank you.

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-6de0.html

After installing CF 9.0.2 on Windows Server 2008 with IIS7, I'm getting a 500 error back from all my web sites.  I made sure to change the permissions to the C:\ColdFusion9 folder to Full Control for psaadm and psacln.  I made sure that CGI, ISAPI extensions and ISAPI filters are installed.  I rebooted.  I can access the CF administrator on the server, but all my web sites generate 500 errors on remote browsers.  Uninstalling doesn't fix the problem.  Please help.  What can I do?

I am trying to run an update query and I am getting an error on the last cfqueryparam.  The error is "There is an error in the syntax of the query. Does anyone see the problem with this query.CODE: <!---Insert record into table OAREI_results--->      <cfquery datasource="xxx" name="addResult">                  INSERT INTO OAREI_results {poll_ID, question_ID, answer_text, votes)            VALUES (<cfqueryparam value="#FORM.QuestionID#" cfsqltype="cf_sql_varchar" />,                                <cfqueryparam value="#FORM.QuestionID#" cfsqltype="cf_sql_varchar" />,             &

Hi,i have the simple form for user to enter in PurNo.  Results is displayed fine with next and previous navigation.  without order by from the query, the next/previous worked fine.  However, afer i added  order by PurNo, NesID into my query then navigation didn't work as expected.  for example, when i click next, i see it changed for message and date added column but not for Pur No.  Can any one tell me what's wrong ?Thanks<!---cfc---><cffunction name="sale" returntype="query" access="public"> <cfargument name="PurNo" required="yes" type="numeric" />    <cfquery name="qsale" datasource="#variables.dsn#">     SELECT *    FROM tblsale    WHERE PurNo = <cfqueryparam  value="#arguments.so#" cfsqltype="cf_sql_integer" />    order by PurNo, NesID    </cfquery>    <cfreturn qsale /></cffunction><!--

Hi I'm getting this error reported here http://www.raymondcamden.com/index.cfm/2008/8/25/Bug-with-Ajax-HTML-Grid-and-File-Upload-Forms . I am using versaion 9.02. Can anyone tell me if this bug has been fixed yet?I have read in various places semi-colons can cause problems, but I don;t have any semi-colons on my grid....Thanks,Ian.

I have a form post that is occuring via ajax to a cf script.  One of the variables is a multi-dimensional array.  I can't seem to be able to get access to the values of the array.  When I do a dump on Form, I get keys that look like this:<CFDUMP var="#FORM#" />The result(keys):data[var1], data[var2], data[var3]########################################When I try to acess the vars though, all I get is errors:FORM.data["var1"] .....shows an errorFORM.data.var1 ......shows an errorOn the other elements that are not an array from the form post, I can access those values just fine:FORM.var4 .....displays valueFORM.var5 ..... displays valueWhat am I doing wrong here?

Hi,I have code the works in one environment, but the exact same code does not work in another environment.Both environments reside on the same server with Cold Fusion 9 Enterprise.The code contains: <CFIF   >     <CFelseif   >     <cfelse    ></CFIF >There are 5 nested CFelseif's within the <CFIF  > </CFIF>. Also, there are 3 sets <CFIF  >  </CFIF> of code 5 nested CFelseifs.When I seperated the code into seperate <CFIF  >    </CFIF>, the code works in the environment where the CFelseif does not work.Is there some limit of CFelseif? Or is there a patch that needs to be installed?Mike

Hello!The Jrun service give regular and random error 503 (timeout).I have one web-project run on the server. The Event viewer is clean. CF server monitor also not show any errors.CF+SQL together use 5% resources of server.Whats wrong?CPU: 2x Dual-Core Xeon RAM: 16GB ECC Registered OS:   Windows Server 2003 x84 (with PAE)CF:    CF 9,0,1,274733  Enterprise, IIS configuration x84 DB:    MS SQL 2008 WebEditionWeb:  IIS

Hi,Recent pen testing has discovered that it is possible to bypass logging in to gain access to the cfcexplorer with the following steps:1.) Go to the COLDFUSION cfcexplorerhttp://<domain-name>/CFIDE/componentutils/cfcexplorer.cfc2.) Click login without specifying a password     When this is done an page displaying an error message results: and a ? is then appended to the url 3.) Press the browser back button and manually add the ? to the url and click login again.http://<domain-name>/CFIDE/componentutils/cfcexplorer.cfc? You will now gain access to the cfc explorer.Is this a known problem that has a patch?

Sorry for this total newb question that's probably been covered a bazillion times, but I'm having some trouble getting things to work.  I should know all this stuff, as I've taken the CF9 advanced training, but when you have 60,000 pages worth of content back at the office waiting to be converted to a new design, there isn't much time to practice what you learned in class.A lot of my office's website is leftover from when we were running CF 6.1, so everything uses Application.cfm files.  Now that we're running CF8 (and may soon move to something even newer), I'd like to get everything modernized, including getting my Application.cfm stuff into an Application.cfc file.  One of the reasons I want to do this is because I have a few apps that I want to use OnRequestStart() methods for.My problem stems from the fact that our Application.cfm file does a lot of things like setting global variables, doing queries, and other things that I can't seem to get to work inside an Appli

I am trying to set up a dealer locater on our site.  My understanding is this is all math but I am confused.  I have db1 with all the zipcode information for the US in it, with the corresponding lat/long.  DB2 will have all information of my dealers in it and their location based on lat/long.  I do not understand how to take in a user supplied mileage number (5 miles, 10 miles, 25 miles, etc) and zipcode, query db1 to get the appropriate ranges that I need to query in DB2.  Please help, I have looked online and I am very confused.

Where can I find info on APSB12-26 Security update: Hotfix available for ColdFusion 10 and earlierfor ColdFusion 8?Tech support had no info.

When I click  Help > Install New Software....  Nothing happens. I even uninstalled ColdFusion Builder 2 and reinstalled it. The first time I installed it with as un administrator. Then ColdFusion Builder would say to run as Administrator. I did but still no install update wizard. Then I reinstalled as Administrator and and still nothing. Anyone have this issue?

For years, I've used <cfhttp url="http://myserver.com/myFile.cfm?#session.urlToken#"> to do screengrabs and use the currently-logged-in user's session scope.  This has not been a problem under CF8/IIS6 environment.  I've recently moved the application to a CF10/IIS7 environment and it does not like this call.  The entire application is managed by cflogin, so it just returns my login screen.  After doing some digging, I can tell that the jsessionID the cfhttp response header contains is not the same jsessionID I am sending via the url.  Of course, this causes the server to think it's a new session and return the login screen.I know setting this up with SSL is a pain and I've wrestled with it a lot in the past, but this setup is strictly http over port 80.Things I've tried:* uncheck "Use UUID for cftoken" in cf admin* uncheck "Enable Global Script Protection"* parsed the session.urlToken variable to send each variable (CFID, CFTOKEN, JSESSIONID) as a url/co

Hey,     Either I am going complete nuts and not seing the most obvious mistake or there is really a bug, hope someone can help.  I have a herirachical xml document that I would like to flatten out.  I wrote a cfm code and it works perfectly, but when I put them logic in cfscript it does not work.   From what I can tell, when recursion returns back, and continues on, the old value in the loop is overwritten (counter value is not what it should be when the state was saved and recursion took place). I don't know how else to explain this.   Here is code in cfm and in cfscript, can you see something I am not?  function flattenXML works just fine, but flattenXML2 does not.[code]<cfset xmlfile = "/xDocs/TAXONOMY_XMLDOC_131.xml" /><cfset myDoc = xmlParse(xmlfile) /><cfset theRootElement = myDoc.XmlRoot><cfdump var="#theRootElement.XMLChildren[1]#"/><cfset st = flatternXML2(theRootElement, "", structNew())/>&l

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/10.0/Developing/WSe61e35da8d318518-5719eac51353e6bb244-8000.html

Hi AllI am trying to add an image in an excel spreadsheet using SpreadsheetAddImage, but there seems to be a problem with this function. Using it seems to clear the entire spreadsheet of all existing images, even ones that have just been added, thus resulting in only one image displaying in the final excel document. Is this a bug? Is there a workaround for this problem?My stripped-down code:</cfscript>     var sheet = SpreadSheetRead(xxxxxxx.xls');</cfscript><cfloop from="1" to="#athletesLen#" index="i">               <cfloop from="1" to="#chartsLen#" index="chartsIndex">                        <cfchart                          &n

I have been working for days trying to figure out this web service header issue.Format I need to send Header in:<soap:Header> <wsse:Security soap:mustUnderstand="1">  <wsse:UsernameToken namespaces>            <wsse:Username>username</wsse:Username>            <wsse:Password Type="type info">password</wsse:Password>            <wsse:Nonce>nonce</wsse:Nonce>            <wsu:Created>date created</wsu:Created>        </wsse:UsernameToken>    <wsse:Security></soap:Header>What I have<cfsavecontent variable="soapHeader">    <cfoutput>    <soap:Header>       

When I read in a spreadsheet using cfspreadsheet in ColdFusion 9, the query data somtimes contains double quote characters around it.  This appears to happen when the data contains certain characters, like commas.  Why doesn't cfspreadsheet removed these double quotes when generating the query?Thanks... Dave Taenzer