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

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 Sa

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 specifi

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 > > w