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