[Kamailio-Users] avp_db_query to SELECT a DOUBLE colomn

[Brandon Armstead]

Hello,

    CAST the result as a CHAR/VARCHAR.  Also what version of kamailio are
you running?

On Tue, Sep 15, 2009 at 6:53 AM, BERGANZ François <
francois at acropolistelecom.net> wrote:

>  Hello,
>
>
>
> I need help.
>
> I try to select a DOUBLE(10,4).
>
> Kamailio report <null>.
>
>
>
> Example:
>
> avp_db_query("select CREDIT from subscriber where client='$avp(s:679)'",
> "$avp(i:513)");
>
>
>
> $avp(i:513) is null!
>
> But in my database, it is 15.0000
>
>
>
>
>
> Know you how to do ?
>
>
>
>
>
>
>
>
>
> Cordialement,
>
> BERGANZ François
>
>
>
> [image: cid:image001.gif at 01C8F7CD.6BC1D2C0]
>
> http://www.acropolistelecom.net
>
> P Pensez à l'Environnement, n'imprimez ce mail que si nécessaire.
>
>
>
> _______________________________________________
> Kamailio (OpenSER) - Users mailing list
> Users at lists.kamailio.org
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
> http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20090915/638b8b16/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/gif
Size: 3150 bytes
Desc: not available
URL: <http://lists.sip-router.org/pipermail/sr-users/attachments/20090915/638b8b16/attachment.gif>