In one of our older database tables we have a field named “ROLLUP”.
\nFor SQL SERVER 2008 this is a reserved word. When writing dynamic SQL with group by statements using the column name “rollup” coldfusion will throw a syntax error indicating there is a problem near “rollup” or “,”.<\/p>\n
The solution is to replace the keyword with the keyword in brackets.<\/p>\n
Example<\/strong> Query: Yields In one of our older database tables we have a field named “ROLLUP”. For SQL SERVER 2008 this is a reserved word. When writing dynamic SQL with group by statements using the column name “rollup” coldfusion will throw a syntax … Continue reading
\nCFSET mylist = “rollup,column2,column3,column4”
\n* this may come from form elements passed or other selections that make it a dynamic list<\/p>\n
\nSelect #mylist#
\n, sum myValue
\nfrom myTable
\nwhere 1=1
\ngroup by #rereplace(mylist, “rollup”, “[rollup]”, “1”)#
\norder by #mylist#<\/p>\n
\ngroup by [rollup],column2,column3,column4<\/p>\n","protected":false},"excerpt":{"rendered":"