Category Archives: SQL

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

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