This may work for you..make sure you change the datasource parms..
<CFSTOREDPROC PROCEDURE="sp_help" DATASOURCE="ODBCNAME"
USERNAME="SQL_User#" PASSWORD="SQL_password#">
<CFPROCRESULT NAME="qu_tablenames">
</CFSTOREDPROC>
<cfoutput>
<table>
<cfloop query="qu_tablenames">
<tr>
<td>#qu_tablenames.name#</td>
<td>#qu_tablenames.OBJECT_TYPE#</td>
<td>#qu_tablenames.OWNER#</td>
</tr>
</cfloop>
</table>
</cfoutput>
At 03:03 PM 9/25/00 +1000, you wrote:
>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/cf-talk@houseoffusion.com/
> > > > > 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/cf-talk@houseoffusion.com/
> > > 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/cf-talk@houseoffusion.com/
> >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/cf-talk@houseoffusion.com/
>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/cf-talk@houseoffusion.com/
>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/cf-talk@houseoffusion.com/
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.
