Contact Me
Resources
-
Category Archives: Problems & Fixes
CFC Bind errors
I can never seem to write a componenct without some sort of error in the SQL or in the structure. Here is my list of things to check if I can not find the error. In the bind statement make sure … Continue reading
Posted in Code, Coldfusion, Problems & Fixes
Tagged Ajax, CFC Errors, Coldfusion Errors
Comments Off on CFC Bind errors
Odd SQL Server Error message
This one took me a few minutes to figure out. “Incorrect syntax near ‘@P2’. “. At first I thought my Colfusion server was having an issue with an email address I was inserting but the “P2” was not in the … Continue reading
Posted in Problems & Fixes, SQL
Tagged @p2, incorrect syntax
Comments Off on Odd SQL Server Error message
Coldfusion working around SQL Server Key words
In one of our older database tables we have a field named “ROLLUP”. For SQL SERVER 2008 this is a reserved word. When writing dynamic SQL with group by statements using the column name “rollup” coldfusion will throw a syntax … Continue reading
Posted in Coldfusion, Problems & Fixes, Snippets, SQL
Comments Off on Coldfusion working around SQL Server Key words
Coldfusion, MSIE9, Excel Output Error !BUG
If you are outputting coldfusion query data to a spreadsheet and you have an error on your spreadsheet that affects layout or cell creation you will not be able to open the spreadsheet. The OPEN/SAVE/CANCEL bar at the bottom of … Continue reading
Posted in Problems & Fixes
Tagged Coldfusion output to excel, MSIE 9 BUGS
Comments Off on Coldfusion, MSIE9, Excel Output Error !BUG
Coldfusion Error – value cannot be converted to a number
Here is a message that comes up often in CF error messages that is sometimes tough to figure out. The value ” cannot be converted to a number. This usually indicates that a Null value (ie record is missing a … Continue reading
Posted in Problems & Fixes, Snippets
Comments Off on Coldfusion Error – value cannot be converted to a number
