If you are using SQL Server check out the system stored procedures
sp_tables (returns view or tables)
sp_columns
sp_stored_procedures
sp_helplogins
Haven't got time to get into the SQLDMO stuff
~ Justin
>-----Original Message-----
>From: Clint Tredway [mailto:[EMAIL PROTECTED]]
>Sent: Monday, January 15, 2001 4:46 PM
>To: CF-Talk
>Subject: cfobject question
>
>
>I need to find out if cfboject can an equivalent to this ASP code:
>With dmoServer.Databases(strDb)
> Select Case strEntityType
> Case "Tables":
> Set dmoCollection = .Tables
> strImage = "images/table.gif"
> if strEntityName <> "" then
> set dmoEntities =
>dmoCollection(strEntityName).Columns
> end if
> Case "Views":
> Set dmoCollection = .Views
> strImage = "images/view.gif"
> Case "Stored_Procedures":
> Set dmoCollection = .StoredProcedures
> strImage = "images/sp.gif"
> Case "Users":
> Set dmoCollection = .Users
> strImage = "images/user.gif"
> End Select
>Basically what this is doing is using the SQLDMO object to get a list of
>tables,views,sprocs,or users depending on what the strEntityName is. I
>cannot reproduce this in CF. Can someone help me?
>
>-Clint
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
