[OpenSER-Users] ERROR:avpops:check_avp: value types don't match

[Bogdan-Andrei Iancu]

Hi Jayesh,

try to use the avp_print() debug function to see what avps you have 
loaded after the avp_db_query() and check the type. Note you need to use 
debug=6 .

http://www.openser.org/docs/modules/1.3.x/avpops.html#AEN611

regards,
bogdan

Jayesh Nambiar wrote:
> Hi All,
> I am using the function avp_db_query to query a table and fetch few 
> values. The query is as follows:
> "select subscriptionid, ip, media_status from domestic where 
> prefix=$rU", "$avp(i:101), $avp(i:102), $avp(i:103)".
>  
> Now the media_status column is a column with datatype as integer which 
> will contain either 0 or 1. I need to check the value in this column 
> so I use the following:
>  
> if(avp_check("$avp(i:103)", "eq/0/i")) {
>     do certain things;
> } else {
>     do certain things;
> };
>  
> Even when the value at media_status column is 0 it does not get into 
> that condition, it always executes the else condition and I see the 
> following in the logs:
> ERROR:avpops:check_avp: value types don't match
>  
> Can someone please help me to overcome this error. When I keep the 
> datatype of media_status column as varchar it works fine, but I dont 
> want to do that as that column is going to conatin only integer values.
>  
> Thanks in advance.
>  
> w/regards,
> Jayesh
>  
>
> ------------------------------------------------------------------------
> Forgot the famous last words? Access your message archive online. 
> Click here. 
> <http://in.rd.yahoo.com/tagline_webmessenger_4/*http://in.messenger.yahoo.com/webmessengerpromo.php> 
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Users mailing list
> Users at lists.openser.org
> http://lists.openser.org/cgi-bin/mailman/listinfo/users
>