Category Archives: Snippets

quick code tips for single elements, attributes, or details

Remove dollar formatting

Posted on 08/26/2014 by eSearing

Sometimes users will not follow instructions and will include $ signs and dollar formatting when providing dollar amounts.  Here is the fix. #rereplace(new_value, “[^\d.]”, “”, “ALL”)#

Posted in Code, Coldfusion, Snippets | Tagged , | Comments Off on Remove dollar formatting

HTTP Header Variables

Posted on 08/19/2014 by eSearing

The company passes certain header variables to my website that I can use for security and tracking of users. I needed a way to see these values on a test page.  Fortunately there is a simple dump of header variables … Continue reading →

Posted in Code, Coldfusion, Snippets | Comments Off on HTTP Header Variables

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 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