RE: [KCFusion] SQL table listing - Access

2001-05-17 Thread Nathan T Haley
Cute, but not the right kind of virus. Got it sorted, thanks. -Original Message- From: Daryl Banttari [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 2:37 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] SQL table listing - Access http://www.google.com/search?q=sri+lanka+virus

Re: [KCFusion] SQL table listing - Access

2001-05-17 Thread Daryl Banttari
http://www.google.com/search?q=sri+lanka+virus - Original Message - From: "Nathan T Haley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 17, 2001 2:13 PM Subject: RE: [KCFusion] SQL table listing - Access Hey, Does anyone know about a virus

RE: [KCFusion] SQL table listing

2001-05-17 Thread Chris
Ryan, Depending on how often you run update stats on the SQL database you might be able to use this. This will loop through all databases on sysdatabases and then get all the tables in the database and finally list all of the columns in the order they should be. DECLARE @ls_db varchar(255),

RE: [KCFusion] SQL table listing - Access

2001-05-17 Thread Nathan T Haley
Hey, Does anyone know about a virus having to do with "Sri Lanka"? -Original Message- From: Ryan Block [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 2:13 PM To: '[EMAIL PROTECTED]' Subject: RE: [KCFusion] SQL table listing - Access But I still need to be

RE: [KCFusion] SQL table listing - Access

2001-05-17 Thread Ryan Block
But I still need to be able to access those columns to input data, even though they are empty. >>Why don't you do a count on the number of records in the table first. If >>the recordcount = 0 don't run the CF ColumnList program. Ryan _

RE: [KCFusion] SQL table listing - Access

2001-05-17 Thread Ryan Hartwich
Why don't you do a count on the number of records in the table first. If the recordcount = 0 don't run the CF ColumnList program. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives..

RE: [KCFusion] SQL table listing - Access

2001-05-17 Thread Ryan Block
laire.com/developer/gallery/info.cfm?ID=CA347125-2830-11D4-AA 9700508B94F380&method=Full url's will probably wrap Bryan - Original Message - From: "Ryan Block" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 17, 2001 11:35 AM Subject: RE: [KCFusi

RE: [KCFusion] SQL table listing

2001-05-17 Thread Ryan Block
ow is a list of tables in the #datasource# database. #name# -Original Message- From: Ryan Hartwich [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 17, 2001 1:45 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] SQL table listing Chris, Your SQL code to do a table lookup and extract t

RE: [KCFusion] SQL table listing

2001-05-17 Thread Ryan Hartwich
Chris, Your SQL code to do a table lookup and extract the column names works on SQL 7 also. Thanks a lot! Any permutations to do output all the table names in a database/datasource? Ryan __ The KCFusion.org list and webs

RE: [KCFusion] SQL table listing

2001-05-17 Thread Chris
Ryan, This works on SQL Server 2000. You can get a specific table or set it up to look through them dynamically. select O.name, C.name from sysobjects O join syscolumns C ON C.id = O.id where O.xtype = 'U' and O.name = 'your table name here' order by C.colorder Good luck! Chris --- Ryan Hart

Re: [KCFusion] SQL table listing

2001-05-17 Thread Daryl Banttari
Look into the sp_tables and sp_columns stored procedures. - Original Message - From: "Ryan Hartwich" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 17, 2001 12:57 PM Subject: RE: [KCFusion] SQL table listing Bryan & Chris, You have given us

RE: [KCFusion] SQL table listing

2001-05-17 Thread Ryan Hartwich
Bryan & Chris, You have given us great insight into finding table & column names in Access. Do you have a way in SQL Server? I tried looking at some of the sysobjects type tables but they are pretty heavily populated with strange data. Ryan _

Re: [KCFusion] SQL table listing

2001-05-17 Thread Bryan LaPlante
lery/info.cfm?ID=CA347125-2830-11D4-AA 9700508B94F380&method=Full url's will probably wrap Bryan - Original Message - From: "Ryan Block" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 17, 2001 11:35 AM Subject: RE: [KCFusion] SQL table listin

RE: [KCFusion] SQL table listing

2001-05-17 Thread Ryan Block
ColumnName# -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 11:48 AM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] SQL table listing If you want to look at all the object in the DB here i

RE: [KCFusion] SQL table listing

2001-05-15 Thread Ryan Block
Thanks. That works great. -Original Message- From: Bryan LaPlante [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 11:48 AM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] SQL table listing If you want to look at all the object in the DB here is a little dynamic table for doing

Re: [KCFusion] SQL table listing

2001-05-15 Thread Bryan LaPlante
AIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 15, 2001 11:01 AM Subject: [KCFusion] SQL table listing > I can't remember how to query a database to just return the names of the > tables in a database (just using Access for now). I know that I have seen > t

Re: [KCFusion] SQL table listing

2001-05-15 Thread Bryan LaPlante
Bryan - Original Message - From: "Ryan Block" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 15, 2001 11:01 AM Subject: [KCFusion] SQL table listing > I can't remember how to query a database to just return the names of the > tables in a datab

[KCFusion] SQL table listing

2001-05-15 Thread Ryan Block
I can't remember how to query a database to just return the names of the tables in a database (just using Access for now). I know that I have seen the syntax to do this somewhere, but can't find it. Thanks in advance. Ryan Block ___