Hi,Suzanne,
Thank you, It works!!!!!!
>From: Suzanne Capener <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Server <[EMAIL PROTECTED]>
>Subject: Re: SQL database table type
>Date: Tue, 10 Jul 2001 09:37:03 -0700 (PDT)
>
>Yinghui,
>YES, it is possible. You would use a SQL Server
>system stored procedure called sp_columns and pass it
>the name of the table that you want to see the
>datatypes of.
>
>ColdFusion EXAMPLE:
>
>(The following example retrieves the column names and
>datatypes from the orders table in the sample
>northwind database that is installed with SQL Server)
>
><CFQUERY name="getdatatype" datasource="Northwind">
> exec sp_columns orders
></CFQUERY>
><table>
><tr><th>Column Name</th> <th>Type Name</th></tr>
><cfoutput query="getdatatype">
>
><tr><td>#column_name#</td>
><td><strong>#Type_Name#</strong></td></tr>
>
></cfoutput>
></table>
>(I ran this on CF Server 5.0 with an odbc connection
>to sql server 7.0)
>
>--- yinghui cao <[EMAIL PROTECTED]> wrote:
> > Hi, everybody,
> > our website is hosted in remote site, I want to know
> > our SQL database
> > specific table's date type,how Can i query it
> > through Coldfusion code.
> > Any help will be appreciated.
> > Thanks
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
