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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=35 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183308 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54