Donna, Here's an old code snippet from CF4/SQL7 days - may still work - if you're using MSSQL. Just an example of how to get at datatypes.
Mark <!--- using the sp_columnlist proc built into SQL Server ---> <CFSET TableName = #TableName#> <CFSTOREDPROC PROCEDURE="sp_columns" DATASOURCE="#DataSource#"> <CFPROCPARAM TYPE="In" CFSQLTYPE="CF_SQL_VARCHAR" DBVARNAME="@table_name" VALUE="#TableName#" NULL="No"> <CFPROCRESULT NAME="First" RESULTSET="1"> </CFSTOREDPROC> <TABLE> <CFOUTPUT QUERY="First"> <TR><TD>#Column_Name#</TD> <TD>#Type_Name#</TD> <TD>#Length#</TD> <TD>#Nullable#</TD> <TD>#Column_def#</TD> </TR> </CFOUTPUT> Donna French <[EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> om> cc: Subject: Another data type question 11/03/2004 03:06 PM Please respond to cf-talk Okay, so I've got a SELECT menu that allows the user to choose which DB field they'd like to see results on, then a text box to allow them to enter the appropriate data for the SELECT choice. Now I'm wondering if I should add some sort of CFIF to show the appropriate SELECT for the 2nd portion instead of the text box b/c I'm having problems with it recognizing the datatype on my query to show results. Or is there a way to detect which datatype within my query - possibly CFIF datatype1 > use this code, etc.???? Some of the SELECT drop downs are text in my db, some are checkboxes and some True/False. Any insight or feedback would be greatly appreciated. TIA, Donna -- ------------------------ Donna French [EMAIL PROTECTED] Blog: http://dgfrench.blogspot.com Site: http://www.dgfrenchdesigns.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.houseoffusion.com/banners/view.cfm?bannerid=11 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183310 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54