Re: cfquery returns db tinyint(1) as boolean

hi dave. yeah we just found that it is a previously submitted bug for mysql jconnector which we use in dreamweaver. to get around it we just changed those columns to smallint(1) thanks after lots of problematic select statements we have realised I don't know if this is a problem specific

RE: cfquery returns db tinyint(1) as boolean

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

Re: cfquery returns db tinyint(1) as boolean

iirc, this is not a cfquery doing, but rather the mysql jdbc driver's. there is some setting for the connector-j and/or in mysql server config file that changes this behaviour, but you will have to look it up in the mysql reference manual - i do not remember the details of this setting... Azadi

Re: cfquery returns db tinyint(1) as boolean

oh i see, i didnt think they had fixed it yet, ok thanks ill look into the config - thanks azadi iirc, this is not a cfquery doing, but rather the mysql jdbc driver's. there is some setting for the connector-j and/or in mysql server config file that changes this behaviour, but you will have to