Can't figure out how, or if, it's possible to alias the table name. The SQL statement is
SHOW CREATE TABLE tablename But queryName["CREATE TABLE"][1] worked. Thanks! ----- Original Message ----- From: "Kwang Suh" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, July 25, 2003 10:17 PM Subject: Re: Column names with spaces > 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 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
