In SQL Server, you can use the sp_help stored proc to give you a list of all the datatypes of a table's columns.
----- Original Message ----- From: Shannon Carr <[EMAIL PROTECTED]> Date: Thursday, June 20, 2002 8:56 am Subject: Getting datatype before SELECT > Does anyone know of a way to determine the datatype of a column in > a SQL > database before running a cfquery? > > I have created a dynamic query and need to determine the datatype of > ColumnList fields before executing a query. If a person enters > text and the > table column is an integer the page breaks and visa-versa. > > > Thanks, > Shannon Carr > [EMAIL PROTECTED] > > 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 > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
