Hello,<br><br> CAST the result as a CHAR/VARCHAR. Also what version of kamailio are you running?<br><br><div class="gmail_quote">On Tue, Sep 15, 2009 at 6:53 AM, BERGANZ François <span dir="ltr"><<a href="mailto:francois@acropolistelecom.net">francois@acropolistelecom.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div link="blue" vlink="purple" lang="FR">
<div>
<p>Hello,</p>
<p> </p>
<p><span lang="EN-US">I need help.</span></p>
<p><span lang="EN-US">I try to select a DOUBLE(10,4).</span></p>
<p><span lang="EN-US">Kamailio report <null>.</span></p>
<p><span lang="EN-US"> </span></p>
<p><span lang="EN-US">Example:</span></p>
<p><span lang="EN-US">avp_db_query("select CREDIT from
subscriber where client='$avp(s:679)'", "$avp(i:513)");</span></p>
<p><span lang="EN-US"> </span></p>
<p><span lang="EN-US">$avp(i:513) is null!</span></p>
<p><span lang="EN-US">But in my database, it is 15.0000</span></p>
<p><span lang="EN-US"> </span></p>
<p><span lang="EN-US"> </span></p>
<p><span lang="EN-US">Know you how to do ?</span></p>
<p><span lang="EN-US"> </span></p>
<p><span lang="EN-US"> </span></p>
<p><span lang="EN-US"> </span></p>
<p><span style="font-size: 10pt;" lang="EN-US"> </span></p>
<p><span style="font-size: 10.5pt; font-family: Consolas;" lang="EN-US">Cordialement,</span></p>
<p><span style="font-size: 10.5pt; font-family: Consolas;" lang="EN-US">BERGANZ
François</span></p>
<p><span style="font-size: 10.5pt; font-family: Consolas; color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p><span style="font-size: 10.5pt; font-family: Consolas; color: navy;"><img src="cid:image001.gif@01CA361C.A5A9E700" alt="cid:image001.gif@01C8F7CD.6BC1D2C0" height="74" width="119"></span></p>
<p><span style="font-size: 10.5pt; font-family: Consolas; color: rgb(31, 73, 125);"><a href="http://www.acropolistelecom.net/" target="_blank"><span style="color: rgb(153, 51, 0);">http://www.acropolistelecom.net</span></a></span></p>
<p><span style="font-size: 16pt; font-family: Webdings; color: rgb(55, 124, 23);">P</span><span style="font-size: 16pt; color: rgb(55, 124, 23);"> </span><span style="font-size: 8.5pt; color: rgb(55, 124, 23);">Pensez
à l'Environnement, n'imprimez ce mail que si nécessaire.</span><span style="font-size: 9pt; color: black;"></span></p>
<p> </p>
</div>
</div>
<br>_______________________________________________<br>
Kamailio (OpenSER) - Users mailing list<br>
<a href="mailto:Users@lists.kamailio.org">Users@lists.kamailio.org</a><br>
<a href="http://lists.kamailio.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.kamailio.org/cgi-bin/mailman/listinfo/users</a><br>
<a href="http://lists.openser-project.org/cgi-bin/mailman/listinfo/users" target="_blank">http://lists.openser-project.org/cgi-bin/mailman/listinfo/users</a><br></blockquote></div><br>