Category Archives: Coldfusion

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

CFC Bind errors

Posted on 07/08/2014 by eSearing

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 , , | Comments Off on CFC Bind errors

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

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