I don't think MS SQL supports the show command. Instead, they have a set of stored procedures that can give you similar information.
sp_tables
sp_columns
You would run a cfquery in either case (sp_ or show *), and it will return a query that you can step through just loke you would any other query result.
You can use query.columnlist to get the names of the returned columns.
Here is the mySQL doc page for SHOW
http://dev.mysql.com/doc/mysql/en/SHOW.html
Jerry Johnson
>>> [EMAIL PROTECTED] 07/07/04 04:49PM >>>
how do i dump the results to display on the page? Will this only work for mySQL, or for MS SQL as well?
thanks!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
