<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=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.
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.
