>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?
I use the tinyint, the cf_sql_bit will throw an error, at least on the versions of MySQL I have used. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:313300 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4