Contact Me
Resources
-
Category Archives: Code
Javascript and form style
You can control some form elements CSS style attributes using Javascript. This comes in handy when trying to highlight errors or disabled fields. You can use a select onChange event to disable/enable form fields. The style attributes I find most … Continue reading
Posted in Code, CSS, Javascript
Comments Off on Javascript and form style
CFTextarea maxlength validation onblur
Here is a nifty little trick. If you have a cftextarea and you want to let users know when they have exceeded the length allowed in the database you can use the maxlength plus validation attributes. You can use validateat … Continue reading
Posted in Code, Coldfusion, Snippets
Comments Off on CFTextarea maxlength validation onblur
CFTry and CFCatch to test database connection
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
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
