Hi all,
I'm needing to get a list of the datatypes and maxlength properties of
the columns of an empty table (I'd like to auto generate the
<cfqueryparam> tags).  SQL_VARIANT_PROPERTY does the trick on a
non-empty table but I'm not working with populated tables.  Any ideas?
I'm using SQL Server 2000.  

Thanks,
Bill
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to