Following up on this:
I didn't see any MS Access system table with knowledge of the columns of
each table. Here's what you could do, but it will only work on tables
with at least one row of data.
Loop over the results of the "qTables" query (i.e. cfoutput
query="qTables"). Inside the loop, do a query of that table, such as
"select top 1 from #qTables.Name#" and output that query's ColumnList
property.
-David
On Wed, 15 Nov 2000 05:54:00 -0800 David Shadovitz <[EMAIL PROTECTED]>
writes:
> 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]
