Category Archives: Code

looping over column names

Posted on 07/07/2010 by eSearing

Occasionally I just need a dump of results from a query columns and values. I have two methods for this. The SQL (cfquery name=”myquery”) Select TOP 1 * from contacts   The simple method allows me to output the column … Continue reading →

Posted in Code | Comments Off on looping over column names

cfselect and bind

Posted on 07/06/2010 by eSearing

I got to use more binding this week. Oh what a joy. Just don’t have any errors in your SQL, your CFC, or your cfselect formpage.cfm cfselect name=”partnum” bind=”cfc:part_functions.getPartnum()” value=”partnum” bindonload=”yes” part_functions.cfc – Note brackets removed due to coding issues. … Continue reading →

Posted in Code, Coldfusion | Comments Off on cfselect and bind

cfdiv and bind

Posted on 07/02/2010 by eSearing

I have been using the CFDIV and BIND attribute since we switched to Coldfusion 8. This week it really came in handy. I helped a co-worker create a dropdown list that changes based on year selected. Some options were not … Continue reading →

Posted in Code, Coldfusion | Comments Off on cfdiv and bind

ColdFusion ReReplace

Posted on 06/25/2010 by eSearing

Avery useful function for dealing with strings. Uses a regular expression (RE) to search a string for a string pattern and replace it with another. The search is case-sensitive, and it has attributes you can set to control case. REReplace(string, … Continue reading →

Posted in Code, Coldfusion, Snippets | Comments Off on ColdFusion ReReplace

MS SQL, ColdFusion, and Form Naming Issues

Posted on 06/24/2010 by eSearing

I had a bug in one of my bits of code earlier this week discovered during migrating an application from a Sybase database to MSSQL database. The bug deals with how a Form element was named and called using Coldfusion. … Continue reading →

Posted in Code | Comments Off on MS SQL, ColdFusion, and Form Naming Issues