http://blog.garthe.com/index.cfm My random findings during 13 years of using the best programming language in the world. en-us Fri, 03 Sep 2010 19:08:23-0500 Fri, 26 Oct 2007 15:33:00-0500 BlogCFC http://blogs.law.harvard.edu/tech/rss davidgarthe@gmail.com davidgarthe@gmail.com http://blog.garthe.com/index.cfm/2007/10/26/Coldfusion-query-of-queries-with-a-reserved-word-in-SQL My client has a stored procedure that was returning a column named "level". While trying to execute a query of queries on the resultset, I ran into some issues because "Level" is a reserved word in T-SQL. The stored proc simply returns a column aliased as "level". Its not actually that in the table, so this problem wasn't an issue previously. I was going to change the stored procedure itself, but other applications rely on the naming structure already in place. Any change would be a pain. I was able to work with the query of queries by putting brackets around my reserved word column. Now ColdFusion and Sql are quite happy! <code> <cfquery dbtype="query" name="shortenedQuery"> SELECT categoryName, [level], name FROM queryResults </cfquery> </code> coldFusion SQL Fri, 26 Oct 2007 15:33:00-0500 http://blog.garthe.com/index.cfm/2007/10/26/Coldfusion-query-of-queries-with-a-reserved-word-in-SQL