Monthly Archives: September 2010

CFTry and CFCatch to test database connection

Posted on 09/28/2010 by eSearing

Every once in a while our database server will be down, but the website server is fine. However, without a database, our application is not very useful. So I use this little snippet to output a custom message. I use … Continue reading →

Posted in Code, Coldfusion, Problems & Fixes, Snippets | Comments Off on CFTry and CFCatch to test database connection

Twelve Things I like about Coldfusion

Posted on 09/23/2010 by eSearing

1) CFIF/CFELSEIF/CFELSE logic – Being able to control actions/output based on variables or values. 2) CFEmail – I know it is a pain sometimes but dynamically outputting a message when an event occurs is a bonus. 3) Bind – Binding … Continue reading →

Posted in Coldfusion | Comments Off on Twelve Things I like about Coldfusion

CFSelect Multiple and ListQualify

Posted on 09/22/2010 by eSearing

If you need a multiple selection list and need to display its values dynamically from a query you can do this in one line of code within your form. <cfquery name=”getstatus” datasource=”myDSN”> select All as status from orderstable UNION ALL … Continue reading →

Posted in Code, Coldfusion, Snippets, SQL | Comments Off on CFSelect Multiple and ListQualify

coldfusion result attributes

Posted on 09/14/2010 by eSearing

During my exploration of the previous article I needed to view the SQL statement that was being dynamically generated. Fortunately Coldfusion has add the “result” attribute to cfquery. This allows you to see things like execution time, sql, sql arguments, … Continue reading →

Posted in Code, Coldfusion, Snippets | Comments Off on coldfusion result attributes

Coldfusion list to Modal Window Select to Javascript to Coldusion variable.

Posted on 09/13/2010 by eSearing

I think I have accomplished what was once thought impossible or at least improbable. I have passed variables to a Modal window, allowed the user to execute a form there, passed the variable back to the parent page using javascript, … Continue reading →

Posted in Code, Coldfusion, Javascript, SQL | Comments Off on Coldfusion list to Modal Window Select to Javascript to Coldusion variable.