Category Archives: Coldfusion

Twelve Things I like about Coldfusion

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

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

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.

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.

Reserved words and Coldfusion

I ran into an interesting issue today. I had form variables whose names ended in _date. When i was testing I output the form variables using CFDUMP and they appeared in the list of variables passed. However when trying to … Continue reading

Posted in Code, Coldfusion, Problems & Fixes | Comments Off on Reserved words and Coldfusion