Access the query using array notation as in: QueryName["Column Name"][RowNumber]
Jim Davis > -----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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
