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
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
