Are you getting a result set, inserting, or updating data?
-----Original Message----- From: Shannon Carr [mailto:[EMAIL PROTECTED]] Sent: Thursday, June 20, 2002 10: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/[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
