Hey Stuart

I'm assuming you're doing a normal sort of SELECT query here. If you do a
CFDUMP of your query:

<cfdump var="#name#">

You will see that there's no information about the table name. There are
certain queries that you can run that will give you this information but
they are pretty database dependant (will be different for SQL Server,
Oracle, MySql, etc...) but I don't think they are what you are after anyway.

The only solution I can see is to modify the structure of your page. You
obviously know the table name when you are running the query. Maybe move the
output logic up there or set a tableName variable at this point?


Cheers

Mark


______________
Mark Stanton
Web Production
Gruden Pty Ltd
Tel: 9956 6388
Mob: 0410 458 201
Fax: 9956 8433
http://www.gruden.com


---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]

MX Downunder AsiaPac DevCon - http://mxdu.com/

Reply via email to