[Kamailio-Users] avp_db_query to SELECT a DOUBLE colomn

Alex Balashov abalashov at evaristesys.com
Wed Sep 16 09:07:28 CEST 2009


Bear in mind that neither the avpops module nor the newer sqlops 
module (in 1.5.x releases) can handle many idiosyncratic datatypes. 
They pretty much deal with INTEGERs and VARCHARs.  Everything else is 
a tossup.  For example, a PostgreSQL BIGINT is unintelligible to 
sqlops, I found out.

BERGANZ François wrote:

> 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 <mailto: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 <mailto:Users at lists.kamailio.org>
> http://lists.kamailio.org/cgi-bin/mailman/listinfo/users
> http://lists.openser-project.org/cgi-bin/mailman/listinfo/users
> 
>  
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> 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


-- 
Alex Balashov - Principal
Evariste Systems
Web     : http://www.evaristesys.com/
Tel     : (+1) (678) 954-0670
Direct  : (+1) (678) 954-0671



More information about the Users mailing list