[Kamailio-Users] avp_db_query to SELECT a DOUBLE colomn

[BERGANZ François]

I am using kamailio 1.4.3-notls

 

 

Cordialement,

BERGANZ François

 

P Pensez à l'Environnement, n'imprimez ce mail que si nécessaire.

 

De : Brandon Armstead [mailto:brandon at cryy.com] 
Envoyé : mardi 15 septembre 2009 19:07
À : BERGANZ François
Cc : users at lists.kamailio.org
Objet : Re: [Kamailio-Users] avp_db_query to SELECT a DOUBLE colomn

 

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

 

cid:image001.gif at 01C8F7CD.6BC1D2C0

 <http://www.acropolistelecom.net/> 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/20090916/283ee548/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/20090916/283ee548/attachment.gif>