Thanks, Tom! Rick
> -----Original Message----- > From: Tom Donovan [mailto:[EMAIL PROTECTED] > Sent: Monday, October 15, 2007 1:44 PM > To: CF-Talk > Subject: Re: Why would this query not return the correct data? > > When accessing MySQL 5 from Java (i.e. when using JDBC) all TINYINT(1) > fields are converted to > Boolean values. > > Documented here: http://dev.mysql.com/doc/refman/5.0/en/connector-j- > reference-type-conversions.html > > You can prevent this behavior by adding a "Connection String" to your > ColdFusion datasource (in > Advanced Settings): > > tinyInt1isBit=false > > This will cause the JDBC driver to treat TINYINT(1) the way you want it > to - as tiny little integers > instead of boolean true/false values. > > -tom- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291151 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
