Author Archives: eSearing

About eSearing

Webdeveloper, Photographer, political junkie.

Coldfusion working around SQL Server Key words

Posted on 06/10/2014 by eSearing

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

Posted on 03/22/2013 by eSearing

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 , | Comments Off on Coldfusion, MSIE9, Excel Output Error !BUG

Apple convert

Posted on 03/06/2013 by eSearing

In the last few months I have become an Apple user and convert. Once you begin to lose the Window mindset and look at function + style it isn’t a difficult leap. For Christmas I purshased an IPAD for the … Continue reading →

Posted in Products | Comments Off on Apple convert

Coldfusion Error – value cannot be converted to a number

Posted on 03/01/2013 by eSearing

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

CFEmail – Alternatives for the user

Posted on 02/19/2013 by eSearing

For those times when CFMail Just won’t cooperate, rather than throwing only an error message, give your user a chance to send the email from their own mail client on their PC/device. If CFMail fails the user is provided a … Continue reading →

Posted in Code, Coldfusion, Problems & Fixes, Snippets | Tagged , , , | Comments Off on CFEmail – Alternatives for the user