Hai
Mysql - Zquery - sum(field) return stringfield resutl, suppose to be numeric type result ?
Muthu
sum of return stringfield as result
Moderators: gto, cipto_kh, EgonHugeist
-
mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
Hi Muthu,
I don't know what version you use. It sounds like you have trouble with a mysql5 server returning a new decimal type that wasn't supported by zeos. By now this should be fixed in the 'releases' Ive build and published on http://users.telenet.be/mdaems or in the SVN repository (testing branch).
If I'm wrong about that mysql thing, let us know what you're trying to do on what configuration.
Mark
I don't know what version you use. It sounds like you have trouble with a mysql5 server returning a new decimal type that wasn't supported by zeos. By now this should be fixed in the 'releases' Ive build and published on http://users.telenet.be/mdaems or in the SVN repository (testing branch).
If I'm wrong about that mysql thing, let us know what you're trying to do on what configuration.
Mark
zquery return TstrinField instead TfloatField
Hai
i am using zeos latest source (thru svn updated ) , mysql ver 5 (but i chked with old ver of mysql also )
select sum(qty) as ttlqty from table1
return like this
ZQuery1ttlqty: TStringField;
but normlay like postgresql & others return as TFloatfield
is this bug or problem of mysql ?
Muthu
i am using zeos latest source (thru svn updated ) , mysql ver 5 (but i chked with old ver of mysql also )
select sum(qty) as ttlqty from table1
return like this
ZQuery1ttlqty: TStringField;
but normlay like postgresql & others return as TFloatfield
is this bug or problem of mysql ?
Muthu