[Users] Help in avp query

[Daniel-Constantin Mierla]

On 09/14/06 11:20, Michel Zenone wrote:
> Hi!
> In the log it can be read:
>
> Sep 13 18:11:51 localhost /usr/local/sbin/openser[5661]: db_raw_query:
> Error while submitting query 
> Sep 13 18:11:51 localhost /usr/local/sbin/openser[5661]:
> avpops:db_query_avp: error - cannot do the query 
>
>
> Then, $avp(i:30) has a right value but $avp(i:50) seems to have no
> value: <null>.
that's very odd, I tested by myself and got :

 0(5425) avpops:ops_dbquery_avps: query [select round(320/100)]
 0(5425) SCRIPT: avp(i:30)=320 avp(i:50)=3

The config snippet I used is:

    avp_write("i:320", "$avp(i:30)");
    avp_db_query("select round($avp(i:30)/100)","$avp(i:50)");
    xlog("SCRIPT: avp(i:30)=$avp(i:30) avp(i:50)=$avp(i:50)\n");

Please run openser in higher debug level: debug=7 for example.

Cheers,
Daniel

> Regards,
>
> Michel
>
>
> On Wed, 2006-09-13 at 19:37 +0300, Daniel-Constantin Mierla wrote:
>   
>> Hello,
>>
>> do you get any error in the log? Did you try to print $avp(i:50)  just 
>> after the avp_db_query()?
>>
>> Cheers,
>> Daniel
>>
>>
>> On 09/13/06 16:46, Michel Zenone wrote:
>>     
>>> Hi!
>>> I try to make the following query but it doesn't work...
>>>
>>> 	avp_db_query("select round($avp(i:30)/100)","$avp(i:50)");
>>>
>>> As the Mysql server can do the query, I suppose that I made a syntax
>>> error in the openser.cfg.
>>>
>>> Does somebody know what is wrong?
>>>
>>> Thanks,
>>>
>>> Michel
>>>
>>>
>>> _______________________________________________
>>> Users mailing list
>>> Users at openser.org
>>> http://openser.org/cgi-bin/mailman/listinfo/users
>>>
>>>   
>>>       
>
>
>