Very difficult to read your sql stmt. One option would be like this (aliasing column name containing # sign). e.g. Select [column a with # sign] as col1 >From myTBL ....
e.g. -- s step further with the above idea using CASE ... WHEN ... ELSE ... END as well >I have a sql query (SQL Server 2000) for CFMX: > >SELECT @Col_with_No_Pound = @Col_with_No_Pound + CASE >@Col_with_No_Pound WHEN '' THEN '' ELSE ',' END + COLUMN_NAME, > @Col_with_Pound = @Col_with_Pound + CASE @Col_with_Pound >WHEN '' THEN '#' ELSE '#,#' END + COLUMN_NAME >.... > >Obviously, # is causing the error whereas I need to # sign there. > >======= Error Message ====== > >The CFML compiler was processing: > >An expression that began on line 27, column 99. >Your expression might be missing an ending "#" (it might look like #expr ). >The body of a cfquery tag beginning on line 20, column 2. > >27 : @Col_with_Pound = @Col_with_Pound + CASE >@Col_with_Pound WHEN '' THEN '#' ELSE '#,#' END + COLUMN_NAME > > >How do you get around this error? I need to use a single # in the >query for the output. > >thx much ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297529 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4