[OpenSIPS-Users] querying float point values in opensips-1.9 gives error

[Jayesh Nambiar]

Hi,
I am testing out Opensips-1.9 currently. While I was using opensips-1.8.2,
I used avp_db_query to query some values from database tables which were
float point values and used those values to insert into acc table.
Obviously for billing reasons. But after upgrading to 1.9 it gives error.
Eg: I am querying a table containing values 1.0000, 0.0123 etc. and storing
it into AVPs. But the 1.9 version gives the following error:
ERROR:core:db_str2int: Unexpected characters: [.0000]
ERROR:db_mysql:db_mysql_str2val: error while converting integer value from
string

Can someone help me to take corrective actions inorder to avoid these
errors. Any help is much appreciated.

Thanks,

--- Jayesh
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20130312/133b8c26/attachment.htm>