I have columns in MySQL database containing boolean values, using a data type of unsigned tinyint. Would the cfsqltype of cf_sql_tinyint or cf_sql_bit be best to use? If using cf_sql_bit what does cfqueryparam do in that case with values such as "-1" or "3" - will it cast them to 1/0, or will it throw an error?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313287 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4