Category Archives: Coldfusion

Temp tables and bad habits

Posted on 05/20/2010 by eSearing

We often have need to hold the results of a query in a temporary table so we can join or perform other tasks in later queries. <cfquery name=”Q1″ datasource=”myDsn”> select * into ##temp1 from mytable </cfquery> It is nice that … Continue reading →

Posted in Code, Coldfusion, SQL | Comments Off on Temp tables and bad habits

Coldfusion Wheels Framework

Posted on 05/17/2010 by eSearing

Every developer eventually begins to see the pitfalls of large applications and trying to manage all the files and processes that make up that application. At work, I am dealing with a large existing CFML application with hundreds of cfm … Continue reading →

Posted in Applications, Coldfusion, Products | 2 Comments

Applications

Posted on 05/12/2010 by eSearing

I have finally put out my first application – CF Directory. it is a simple database application that houses contact information. Uses a little Ajax + Jquery + Coldfusion to dynamically display the contacts info. See the applications tab at … Continue reading →

Posted in Applications, Coldfusion, JQuery | Comments Off on Applications

isNull

Posted on 05/07/2010 by eSearing

Occasionally a field is blank but we have to sometimes have to show a default value or a value from another field. SQL gives us a nice tag to use: isnull(field1, field2) as name or isnull(field1, ‘n/a’) as name or … Continue reading →

Posted in Code, Coldfusion, Snippets, SQL | Comments Off on isNull

Coldfusion output value formats

Posted on 05/06/2010 by eSearing

a library of things I use regularly but can never find when I need them. I will add to it over time. #datetime(fieldname, “mm/dd/yyyy”)# #DOLLARFORMAT(fieldname)# Excel formatting: color alternating rows <tr bgcolor=”###iif(currentrow MOD 2,DE(‘ffffff’),DE(‘ffff99’))#”> number as text in excel <td … Continue reading →

Posted in Code, Coldfusion, Snippets | Comments Off on Coldfusion output value formats