[Users] acc module db_extra accounting issue

[Glenn Dalgliesh]

Not sure if this should be necessary but adding "as char(10)" to the select
fixed the problem. 

avp_db_query("select cast(id as char(10)) from customers where gateway1 =
'$si' or gateway2 = '$si'","$avp($outbound_cust_id)");

avp_db_query("select cast(cust_id as char(10)) from customer_dids where did
= '$tU'","$avp($inbound_cust_id)");

-----Original Message-----
From: users-bounces at openser.org [mailto:users-bounces at openser.org] On Behalf
Of Glenn Dalgliesh
Sent: Friday, April 21, 2006 12:51 PM
To: users at openser.org
Subject: RE: [Users] acc module db_extra accounting issue


Sorry yesterdays cvs version
-----Original Message-----
From: users-bounces at openser.org [mailto:users-bounces at openser.org] On Behalf
Of Glenn Dalgliesh
Sent: Friday, April 21, 2006 12:44 PM
To: users at openser.org
Subject: [Users] acc module db_extra accounting issue

I am having issues with avp's as part of db_extra. In the below scenario
which ever avp value is listed first in the db_extra statement ends up in
both fields in the table that involve avp's. The Pseudo-variables seem to
get populated correctly.

 I have verified that the values are correct in the avp's via the xlog
statement but the sql insert has the wrong values when I send ngrep it.

modparam("avpops","avp_aliases","outbound_cust_id=i:5024;inbound_cust_id=i:5
025")

modparam("acc", "db_extra", "inbound_cust_id=$avp($inbound_cust_id);
src_ip=$si; recv_ip=$Ri; outbound_cust_id=$avp($outbound_cust_id)")

avp_db_query("select id from customers where gateway1 = '$si' or gateway2 =
'$si'","$avp($outbound_cust_id)");

avp_db_query("select cust_id from customer_dids where did =
'$tU'","$avp($inbound_cust_id)");

xlog("L_ERR", "AVP outbound_cust_id [$avp($outbound_cust_id)]\n");
xlog("L_ERR", "AVP inbound_cust_id [$avp($inbound_cust_id)]\n");


_______________________________________________
Users mailing list
Users at openser.org
http://openser.org/cgi-bin/mailman/listinfo/users


_______________________________________________
Users mailing list
Users at openser.org
http://openser.org/cgi-bin/mailman/listinfo/users