You put into script what I was doing with SQL - my query is a stored proc that does much of what yours does, and I didn't want to muddy the waters.
Excellent.
>I haven't been following this discussion so far, but this is a useful little
>snippet for checking out your user tables from CF:
>
><cfquery name="GetSQLInfo"
> datasource="#YourDSN#">
> SELECT objs.Name AS TableName, cols.Name AS ColumnName, cols.Length,
>typs.Name as DataType
> FROM sysobjects objs, syscolumns cols, systypes typs
> WHERE objs.id = cols.id
> AND cols.xtype = typs.xtype
> AND objs.xtype = 'U'
> ORDER BY objs.name, cols.name
></cfquery>
>
>HTH->
>
>Tyler
>
> _____
>
>From: [EMAIL PROTECTED] [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Sent: Thursday, October 02, 2003 12:24 PM
>To: CF-Talk
>Subject: Re:How do I tell what fields are in my tables...
>
>
>There is another way to do much of this in SQL Server:
>
>Use the following two queries and do a cfdump on them:
>
>-- To get all tables in a database, just do:
>
>SELECT * from sysobjects where type='u'
>(the type='u' means just show USER tables, not system tables)
>
>-- To get info on table, including datatypes etc, use the following SQL
>Server stored proc (comes with database):
>
>sp_help [yourTableName]
>Will return seven result sets; the second one is the interesting one - run
>it is query analyzer to see what you can get from it. I use this instead of
>Enterprise Manager, for the most part - Query Analyzer is much lower
>overhead and faster.
>
>
>
>>Thanks Critz!
>>
>>This worked like a charm.
>>
>>
>>I'm alos going to look at what you recomended Philip.
>>
>>
>>Thanks to all!
>>
>>Brian
>>
>>
>>oi cf!!
>>
>>select top 10 * from table
>><cfdump var="#query#">
>>
>>or output query.columnlist
>>
>>
> _____
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
