ColdFusion

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

Hi all,I just recently got back into doing ColdFusion and I am looking at CFWheels right now as a framework choice?  Any thoughts would be appreciated.  By the way if anybody is looking for a CFDeveloper just let me know.  Also, started working with jQuery, thats pretty kool too!

I was looking to update my installation with Hotfix 2 for Codfusion 9.  However, the link http://helpx.adobe.com/coldfusion/kb/cumulative-hot-fix-2-coldfusion-1.html is broken (404), and has been for the past week.  I have a couple of security updates I wanted to install, and wanted to get the hotfix installed first to bring everthing up to date.Any idea why the link is broken?  Is it bad?  The hotfix can still be loaded through Google's page cache!!

I have a query that I am adding to a spreadhseet object that seems to error when the query has an unweildly amount of rows (18583 in this example). The exact error is as follows:java.lang.ArrayIndexOutOfBoundsException: -32735 at java.util.ArrayList.get(ArrayList.java:324) at org.apache.poi.hssf.model.WorkbookRecordList.get(WorkbookRecordList.java:50) at org.apache.poi.hssf.model.Workbook.getExFormatAt(Workbook.java:787) at org.apache.poi.hssf.usermodel.HSSFCell.getCellStyle(HSSFCell.java:901) at org.apache.poi.hssf.usermodel.HSSFSheet.autoSizeColumn(HSSFSheet.java:1727) at coldfusion.excel.Excel.autoResize(Excel.java:1246) at coldfusion.excel.Excel.autoResize(Excel.java:1240) at coldfusion.excel.Excel.addRows(Excel.java:1214) at coldfusion.runtime.CFPage.SpreadSheetAddRows(CFPage.java:7089) at coldfusion.runtime.CFPage.SpreadSheetAddRows(CFPage.java:7076) Here's the relevant code:<cfset xls = spreadsheetNew()><cfset spreadsheetAddRow(xls, arrayToList( qryTest.getMeta().getCol

Hi,I have the search page for user to search the purNO and display resutls in the list.  I am tring to do the paging but keep got an error for cf 7 not supported the PAGESIZE,BIND.  Please advice with the code below to have it works in colfusion 7.Thanks<!---form---><cfparam name="variables.row_per_page_default" default="15"> <cfform name="tableform"><cfgrid format="html" name="grid_Tables"pagesize="#variables.row_per_page_default#" selectmode="row"bind="cfc:cfc.query.pur{purNO},{cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})"><cfgridcolumn name="purNO" display="Purchase No"/><cfgridcolumn name="date_modified" header="Date Modified" ></cfgrid></cfform><!---cfc---><cffunction name="purNo" returntype="query" access="public"><cfargument name="purNO" required="yes" type="numeric" /><cfargument name="page" required="yes"><cfargument name="pageSize" required="yes"><cfargument na

If I load a jquery page by itself, it works fine.  If I load it into a cflayoutarea I get a bunch of errors and it won't work.  How do you load a page that has jquery scripts into a cflayoutarea?  I know if you are using CFML's built in ajax you have to do cfajaximport.  Is there a command to load jquery and custom scripts?

Hi all,we are currently upgrading a SLES 11 Server to CF10 64bit.Last week we spend 2 days to eliminate a problem with the connector.Apache refused to deliver CF-Pages. The log file said that mod_jk could not connect to the cfusion instance - Error 503...We finally fixed this by copying a mod_jk binary from a working CF10 Server to this one.Now Apache (2.2.23) serves all CF pages flawlessly.What I just discovered was a problem, when a client doesn't accept cookies and J2EE-Sessions are turned on.A URL with the sessionid appended (as for example cflocation creates it) results in a 404 error:http://xxxxx.xxxxxx.com/login.cfm;jsessionid=xyxxyxyxyxyxyxyI remember such a problem from a CF6/7 install, but that was IIS on Windows.I'm just stuck with this one.Can somebody please help?RegardsJoerg

Im having a problem attaching to Windows server 2008 with the exchange tags in coldfusion 9. We took the username and password out and we get a access denied error. We put them in and we get the following screenshot error. Here is the code I am working with<CFEXCHANGECONNECTION  action="open"  username="windowsusername"  password="windowspassword"  server="10.10.10.6"  connection="conn1"> <!--- Create a structure with the task fields. ---> <CFSET stask = StructNew()><CFSET stask.Priority = "high"><CFSET stask.Status = "Not_Started"><CFSET stask.DueDate = MakeODBCDate("08/10/2012")><CFSET stask.Subject = "Johns Task Test"><CFSET stask.PercentCompleted = 0><CFSET Message = "Hello John!"> <!--- Create the task by using a transient connection. ---> <cfexchangetask action = "create"  connection="#conn1#"  task = "#stask#"  result = "theUID"> <CFEXCHANGECONNECTION  action="close"

Hi,i am want to send from error@domain.com to the debugging team debug@domain.com using this simple code<cfmail to="debug@domain.com" from="error@domain.com" subject="sending error message plz respond!" username="sender@domain.com" password="password-correct" server="mail.domain.com" type="html">          bla bla bla bla blga     </cfmail>  the issue is that if the from is not an existed email account i get a verification error on mail log of coldfusion althouth the username is correct...  This used to work in cf8, did they now changed it?

I have a parameter in my mssql databse with a type of nvarchar. When I try to insert a character chr(228)äI get the ? in my database instead of äAny one who can help.Thanks in advance for your response.