ColdFusion

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.

Hi allAfter migrating from CF7 to CF 10 we are getting this error "Unable to add text to HTML HEAD tag.ColdFusion was unable to add the text you specified to the output stream.  This is probably because you have already used a CFFLUSH tag in your template or buffered output is turned off. The specific sequence of files included or processed is:"Javascript code  is available in  script.cfm page.We are referencing the Script .cfm in admin .cfm using CFInclude and CFFLUSH is nowhere avaialable but still it throws the error.Only thing is we are referencing the script.cfm page more than once in admin.cfm.PLease how to get ride of this error.Thanks in advance.Naresh.

I just wrote my first Ajax code, and am looking for a more elegant way to retrieve the callback from the ColdFusion server page.  My callback page returns this data:  <html><body><div>6</div></body></html>  Right now I am using this Javascript to retrieve the 6 from inside the div:  (data = string sent by server page) var divloc = data.indexOf('div'); var callback = data.substr(divloc+4,1);  Is there a better way to retrieve the 6 from those HTML tags, or could I get the server page to pass just the 6, without the HTML, back to the calling page?

I reset this thing over and over but I constantly get Invalid Password. Please try again. Any thoughts.

I am trying to greate a poll for my website.  I am getting this error when they user trys to vote and I dont understand why.  The error appears to be on the processing page when trying to add votes.  I get the total votes from the database then add 1 and then update the database.  THat is when I get there error.  can anyone help? Thanks.CODE:<!---BEGIN COLDFUSION CODE FOR POLL---><CFAPPLICATION NAME="Cookies" sessionManagement = "Yes"setDomainCookies = "Yes" setClientCookies = "Yes"><!---GET CURRENT POLL ID---><cfquery datasource="xxxxx" name="currentpollID" >          SELECT *    FROM OAREI_poll    WHERE start_date <= <cfqueryparam cfsqltype="cf_sql_date"value=#Now()#> and end_date >= <cfqueryparam cfsqltype="cf_sql_date"value=#Now()#></cfquery><cfset SESSION.display = #currentpollID.poll_ID#><!---END CURRENT POLL ID---><!--

Due to a bug in either FF 17.0 or ckeditor a dangerous, I dare say vulnerability, is made available to users using FF 17.0.  The behavior is described here:https://support.mozilla.org/en-US/questions/942438?page=2A workaround is available, but I didn't pursue, which requires editing of some portion of fckeditor browser checking.  My workaround was to force users to update to a version of Firefox other than 17.0.  I preferably directed them to the Extended Support Release version using javascript since we are an enterprise environment.I plan to pursue update to CKEditor, meanwhile what options do I have to verify that for any update to a web browser I'm not exposing my edit enabled pages to source code changes?

What is the best solution to send e-mails to a list of recipients for only certain Ticket Types?- I've already created a table/form that connects each User/Email to the Ticket Types (see image below)- My problem is how to create the Query that will "filter" and create the list of email address?     - Every new ticket gets assigned a TicketType..     - Every user has been setup ahead of time with the appropriate types checked..     - But each user only wants their emails and NOT any unchecked types?- Here is my idea of a tblEmailAction that indicates which Ticket Types a recipient is interested in and then it saves the ID of that ticket type into the table. Now just need to match up the  values in the original ticket and generate the email list..?

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

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

My application generates dynamic reports in PDF format.  The reports can vary from 50K and up to over 300K. I get the message above ONLY when the PDF output is greater than 221K in IE (7,8 & 9). Anything less than 221K displays fine. Anything above it displays fine in Chrome and FF, just not IE. I have tried various combinations, but the only thing that seems constant is the size limit. It also happens if I use Flashpaper. Any ideas? Thanks!

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