Re: display a list of table names

2000-09-26 Thread Nathan Chen 

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/cf-talk@houseoffusion.com/
  To Unsubscribe visit

   http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=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?

display a list of table names

2000-09-24 Thread Nathan Chen 

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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: display a list of table names

2000-09-24 Thread JustinMacCarthy 

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=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: display a list of table names

2000-09-24 Thread Nathan Chen 

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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: display a list of table names

2000-09-24 Thread Michael 'Maxx' Porter 

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=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: display a list of table names

2000-09-24 Thread Jared Clinton 

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=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: display a list of table names

2000-09-24 Thread Michael 'Maxx' Porter 

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=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Re: display a list of table names

2000-09-24 Thread Gunawan 


- 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/cf-talk@houseoffusion.com/
 To Unsubscribe visit
   
  http://www.houseoffusion.com/index.cfm?sidebar=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.