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
Now you can chat without downloading messenger. Go to
http://in.messenger.yahoo.com/webmessengerpromo.php