Thank everyone who helped me with this question. I really appreciate your help!
Nathan
Peter Stolz wrote:
> Or :
>
> <CFQUERY NAME="tables" DATASOURCE="#DSN#">
> SELECT TABLE_NAME
> FROM INFORMATION_SCHEMA.TABLES
> WHERE TABLE_TYPE ='BASE TABLE'
> </CFQUERY>
>
> P.
>
> -----Original Message-----
> From: Gunawan [mailto:[EMAIL PROTECTED]]
> Sent: Monday, September 25, 2000 12:58 AM
> To: CF-Talk
> Subject: Re: display a list of table names
>
> ----- Original Message -----
> From: "Jared Clinton" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, September 25, 2000 12:03 PM
> Subject: RE: display a list of table names
>
> > To query for a list of table names : run the 'sp_helpdb' system stored
> > procedure. (MSSQL only)
> >
> > Look at the system stored procedures entry in SQL server books online. It
> > is helpful.
> >
> > Jared.
> >
> > > -----Original Message-----
> > > From: Michael 'Maxx' Porter [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, September 25, 2000 1:59 PM
> > > To: CF-Talk
> > > Subject: Re: display a list of table names
> > >
> > >
> > > <cfoutput>#queryname.ColumnList#</cfoutput>
> > >
> > >
> > > At 08:29 PM 9/24/00 -0700, you wrote:
> > > >Justin,
> > > >I am using MS SQL 7 and I want to do it remotely using cf
> > > page. Thanks.
> > > >Nathan
> > > >
> > > >
> > > >JustinMacCarthy wrote:
> > > >
> > > > > What DB nathan ???
> > > > >
> > > > > In MsSql you can use a StoredProc called sp_tables
> > > witch will return all
> > > > > the tables in a DB including the sys tables
> > > > >
> > > > > In Access you can get at the table names from a systable
> > > but I can remember
> > > > > which one... hold on it's called MsysObjects ,but it has
> > > alot of other
> > > > stuff
> > > > > in there. To view the table in access go to
> > > tools->options->view and tick
> > > > > hidden objects and system objects
> > > > >
> > > > > or use ado (search for ADO in the Allaire Forums)
> > > > >
> > > > > ~JustinMacCarthy
> > > > >
> > > > > ----- Original Message -----
> > > > > From: "Nathan Chen" <[EMAIL PROTECTED]>
> > > > > To: "CF-Talk" <[EMAIL PROTECTED]>
> > > > > Sent: Saturday, September 23, 2000 1:09 AM
> > > > > Subject: display a list of table names
> > > > >
> > > > > > Hi everyone,
> > > > > >
> > > > > > For some reason I remember there is a CF tag that
> > > allows to display all
> > > > > > the table names in a database. Is there a such tag or
> > > is just my
> > > > > > imagination?
> > > > > >
> > > > > > Nathan Chen
> > > > > >
> > > >
> > > --------------------------------------------------------------
> > > ------------
> > > > > ----
> > > > > > Archives: http://www.mail-archive.com/[email protected]/
> > > > > > To Unsubscribe visit
> > > > >
> > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> > s/cf_talk or
> > > > send a message to [EMAIL PROTECTED] with 'unsubscribe'
> > in
> > > > the body.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > --------------------------------------------------------------------------
> --
> > --
> > > > Archives: http://www.mail-archive.com/[email protected]/
> > > > To Unsubscribe visit
> > > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> > > or send a message to [EMAIL PROTECTED] with
> 'unsubscribe'
> > > in the body.
> >
> >---------------------------------------------------------------------------
> > ---
> > >Archives: http://www.mail-archive.com/[email protected]/
> > >To Unsubscribe visit
> > >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> > >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> > >the body.
> >
> > end
> >
> ****************************************************************************
> > *************
> > Every child is an artist. The problem is how to remain an artist once he
> > grows up. -Pablo Picasso, painter and sculptor (1881-1973)
> >
> ****************************************************************************
> > *************
> > Michael "Maxx" Porter
> > Vice President
> > Paradox Studios Inc.
> > 847-869-3673
> > mailto:[EMAIL PROTECTED]
> >
> > --------------------------------------------------------------------------
> --
> > --
> > Archives: http://www.mail-archive.com/[email protected]/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> > the body.
> > --------------------------------------------------------------------------
> ----
> > Archives: http://www.mail-archive.com/[email protected]/
> > To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> ----------------------------------------------------------------------------
> --
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
