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
