You're using MS Access, if I recall correctly. Here's how to get the
table names. (This is based on previous responses by others to the same
question).
First go to Tools -> Options -> click on Hidden Objects and System
Objects,
then go back to Tools -> Security -> User and Group permissions ->
highlight
the MSSysObjects table and then check the Read Data check box, then click
OK.
<cfquery datasource="myDatasource" name="qTables">
SELECT MSysObjects.Name FROM MSysObjects
WHERE (((MSysObjects.Flags)=0) AND ((MSysObjects.Type)=1))
ORDER BY MSysObjects.Name
</cfquery>
Another variant of the SQL is:
SELECT name
FROM MSysObjects
WHERE TYPE=1 and
left(MSysObjects.name,4) <> 'MSys'
FYI, here's what that "type" means:
Type 1 = Table
Type 6 = Attached Tables
Type -32768 = Forms
Type 5 = Queries
Type -32764 = Reports
Type -32761 = Modules
On Wed, 15 Nov 2000 09:43:26 +0100 "Dominic J. Doucet-Lorang"
<[EMAIL PROTECTED]> writes:
> I was wondering if anyone new of a easy way in CF to get a list of
> all
> variables in a database and output that list.
>
> Dominic
________________________________________________________________
YOU'RE PAYING TOO MUCH FOR THE INTERNET!
Juno now offers FREE Internet Access!
Try it today - there's no risk! For your FREE software, visit:
http://dl.www.juno.com/get/tagj.
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
