You can get a list of all tables in a SQL Server 7 database by querying the
sysobjects table for that DSN like so:
CFQUERY datasource="" name=""
select name from sysobjects
/CFQUERY
this query returns the list of table names.
~Simon
Simon Horwith
Certified ColdFusion Developer
Fig Leaf
Hi Howie, how are things?
Check out http://www.swynk.com/sqlhome/scriptlibrary.asp , they'll have most
of the scripts you are looking for (version 6.5 7 ). You 'll need to be
DBowner or SA for most of them though. Otherwise connect though OleDB would
work ..
Justin MacCarthy
I'm trying to
2 matches
Mail list logo