Contact Me
Resources
Development Tips & Code Library
-
Recent Entries
Blogroll
Category Archives: SQL
Temp tables and bad habits
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
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