Questions

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

So, I work on a legacy CF web site and there are numerous SELECT * FROM USERS_TABLE queries all over the site.Well, we changed the structure of said table in the database on our Testing and Staging sites, with no issues.When we pushed up to our production environment and changed the structure of the production DB table, the server kept kicking back "Value can not be converted to requested type."After doing some searching out there, it looks like CF caches the structure of the table, and you either have to restart CF to clear it, or rename and then name-back the DSN to fix the issue.http://www.bennadel.com/blog/194-ColdFusion-Query-Error-Value-Can-Not-Be-Converted-To-Requested-Type.htmThat said, this doesn't happen in our testing and staging environments - so what would be the difference?Is there some setting I need to change in the CF Admin to keep this from happening again?

After applying the security patch 12-26 I am getting the error "Could not access a java object field called allowAppDataInServContext".  When I removed the update the error goes away.  When I read the update it returns.The error states it occurred in the following line: cfapplication name="somename" clientmanagement="No" sessionmanagement="Yes" setclientcookies="Yes"

Hi, I am having an issue with a timeout occurring on my website.We upgraded to ColdFusion 8 in September and our application can only be used in Internet Explorer. After the upgrade we started receiving complaints of a timeout. It doesn’t’ happen for every user and we cannot replicate the issue. Our website timeouts after 30 minutes, we then let the user login by clicking a link and we set the timeout session variable to “Y” to let us know that they are currently logged in. They are then able to access the site but only for one page. Once they click to any other page they are returned to the timeout page. I have noticed that the CFID and CFToken change after they view a page, which would indicate that somehow it is losing the session. To fix the problem I instruct the user to clear their cookies and temporary internet files in Internet Explorer. Once they do this they no longer see the problem. I would rather not have someone clear their cache. Has anyone seen this issue before? Any su

We are having a problem with OpenOffice that throws com.sun.star.task.ErrorCodeIOException exception while converting some .doc files into .pdf. Most of the .doc files are being converted normally so does the  .rtf and .docx files. But few .doc files permanently throw this exception. What might be wrong with those files? Did anyone had this problem? We are using the most simple code:<cfdocument format="pdf"srcfile="C:\Temp\555.doc"filename="C:\Temp\New555.pdf"></cfdocument> What should we look at?Thank you!

This question was posted in response to the following article: http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7d52.html

HeiI don know whats is wrong with this query. it give error when run on cfm. but runs fine in sql server.please look what is the problem.I have used the same query withMaalgruppe in('barnehage', 'småskoletrinnet') but it give error. please look why.Maalgruppe ='barnehage' , Maalgruppe ='småskoletrinnet' , Maalgruppe ='mellomtrinnet' , Maalgruppe ='ungdomstrinnet' , Maalgruppe ='videregående og høgskole' , Maalgruppe ='skognæringen' ,SELECT Id, Navn, isbn, Pris, Varenr, Ingress, Tekst, Aktiv, Fradato, Tema, Undergruppe, Miniatyr, Lagerstatus, Maalgruppe, Vekt, Type, h, b, d FROM Varer WHERE Tema = 'Lære med skogen' and aktiv =1 and ( Maalgruppe ='barnehage' or Maalgruppe ='småskoletrinnet' or Maalgruppe ='mellomtrinnet' or Maalgruppe ='ungdomstrinnet' or Maalgruppe ='videregående og høgskole' or Maalgruppe ='skognæringen' ) ORDER BY Navn Error Executing Database Query.structCausestructErrorCode102Message[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'barnehage'.SQLS