Dealing with unworkable query column names

I'm trying to query a MySQL 3.23 database to get table names that match a naming pattern. Unfortunately, there doesn't seem to be any way to alias the column name returned, plus the name contains both a space and the percent sign used in my original SQL statement. Also, the syntax of SHOW

Re: Dealing with unworkable query column names

Ouch... I'm glad I don't have to deal with that schema... But you don't want to use evaluate anyway... plus, unless the table only has one column, this won't work anyway: tblname = Evaluate(q. q.columnList) -- q.columnlist is a comma delimited list of the column names, so you would be trying to

Re: Dealing with unworkable query column names

- Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, May 02, 2005 1:00 PM Subject: Re: Dealing with unworkable query column names Ouch... I'm glad I don't have to deal with that schema... But you don't want to use evaluate

Re: Dealing with unworkable query column names

- Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Monday, May 02, 2005 1:00 PM Subject: Re: Dealing with unworkable query column names Ouch... I'm glad I don't have to deal with that schema... But you don't want to use