Here's the deal: I've got MySQL running on Win2000 - and I'm trying to set up some PHP and ColdFusion pages - but I'm encountering something strange when my ColdFusion templates make queries to the MySQL database. For example, the following query:
SELECT t.field
FROM table t
will return the column name as "t.field" instead of "field." I assume that this must be some sort of setting in MySQL - if anybody understands what I'm talking about and can offer some help - I'd greatly appreciate it! Thanks!
