hi,
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
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
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
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
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
5 matches
Mail list logo