Or maybe even better, you could set a column in the query as the tablename SELECT TableName.*, 'TableName' AS TableName FROM Table
Then you get a column called 'TableName' whith the value of the name of the table Steve -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stuart Kidd Sent: Thursday, 10 July 2003 7:58 PM To: CFAussie Mailing List Subject: [cfaussie] RE: Pulling Table Name from a Query Thanks Mark. When I've found out which <cfif> is chosen then right below the query (because there are separate queries for each table) I'll have a <cfset tablenamedetails = "Entertainment">. I didn't think of that, thanks! :) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Stanton Sent: Thursday, 10 July 2003 10:39 AM To: CFAussie Mailing List Subject: [cfaussie] RE: Pulling Table Name from a Query 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/ --- 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/ --- 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/
