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
TABLES doesn't permit column aliasing. The column name generated by the
code example below ends up being
TABLES_IN_LIVESTATS (SERVER%_DEMOGRAPHICS)
<cfquery datasource="livestats" name="q">
SHOW TABLES like 'server%_demographics'
</cfquery>
<cfoutput>
Query Columns: #q.ColumnList#
<cfloop query="q">
<cfset tblname = Evaluate("q." & q.columnList)>
#tblname#<br>
</cfloop>
</cfoutput>
The error I receive from CF is:
---------------------------------------------------------------------
An error occurred while evaluating the expression:
tblname = Evaluate("q." & q.columnList)
Error near line 23, column 9. An error has occurred while processing the
expression:
q.TABLES_IN_LIVESTATS (SERVER%_DEMOGRAPHICS)
Invalid token found on line 1 at position 30. ColdFusion was looking at
the following text:
%Invalid expression element. The usual cause of this error is a
misspelling in the expression text.
---------------------------------------------------------------------
Is there an alternative method for addressing query columns, say, similar
to using array notation when addressing the rows of a query?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:205294
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
