Shannon, You can run sp_columns *tablename* on the table. It returns a query with a datatype column. Here's a sample UDF that may help a little. It uses the "DATA_TYPE" column from the stored proc. It could just as easiy be written to use the "TYPE_NAME" column (that would have made it more readable. I use this function to set the correct type in <cfqueryparam> (as in <cfqueryparam cfsqltype="#converdatatype(intDattype)#" value="#blah#">). This UDF doesn't cover all the types (it was written for a specific ap and set of tables) but you get the idea.
function convertDataType(intDtype) { var strReturn = ''; SWITCH(intDtype) { CASE '4': { strReturn = 'CF_SQL_INTEGER'; break; } CASE '1': { strReturn = 'CF_SQL_CHAR'; break; } CASE '11': { strReturn = 'CF_SQL_DATE'; break; } CASE '3': { strReturn = 'CF_SQL_DECIMAL'; break; } CASE '2': { strReturn = 'CF_SQL_NUMERIC'; break; } CASE '6': { strReturn = 'CF_SQL_FLOAT'; break; } } return strReturn; } -mk -----Original Message----- From: Shannon Carr [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 9:56 AM To: CF-Talk 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists