You can alias the table name in the select statement, or you might be able to do:
queryName["CREATE TABLE"][1] ----- Original Message ----- From: "Jim McAtee" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, July 25, 2003 9:34 PM 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
