> after lots of problematic select statements we have realised 
> that if a db column has a type of tinyint(1) and that column 
> in the mysql db has '2' stored in it, then running a cfquery 
> will only return 0 or 1
> so we realise that cfquery must convert tinyint(1) columns to boolean
> we couldn't believe that a the same select statement directly 
> in mysql returned a value of 2 but a cfquery returned the 
> value 1 - on the tinyint(1) column
> is this right?, is this a bug? or is there a way we can turn 
> this conversion to a boolean off? or will we have to change 
> any tinyint(1) columns to smallint(1)

I don't know if this is a problem specific to MySQL or the MySQL JDBC

You might work around this by simply casting within your SQL.

Dave Watts, CTO, Fig Leaf Software

Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our training centers in Washington DC, Atlanta,
Chicago, Baltimore, Northern Virginia, or on-site at your location.
Visit http://training.figleaf.com/ for more information!

Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
Get the Free Trial

Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm

Reply via email to