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">&lt;<a href="mailto:francois@acropolistelecom.net">francois@acropolistelecom.net</a>&gt;</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 &lt;null&gt;.</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(&quot;select CREDIT from
subscriber where client=&#39;$avp(s:679)&#39;&quot;, &quot;$avp(i:513)&quot;);</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&#39;Environnement, n&#39;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>