not sure you can? although, maybe its possible...in sql server i dont think you can, but maybe in mysql you can, good luck!!
tony -----Original Message----- From: Jim McAtee [mailto:[EMAIL PROTECTED] Sent: Friday, July 25, 2003 11:34 PM To: CF-Talk Subject: Column names with spaces How do you display a query column that has a space within its name? I'm executing a MySQL "SHOW CREATE" statement, which returns a one row data set with two columns named "TABLE" and "CREATE TABLE", but I'll be hanged if I can figure out how to get CF to reference the latter. Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4