sip-router writes:
I use SQLOPS module to query additional data in MySQL database. Script logic is based on user related DB records existence. I check wether records exist or not simply by assigning variable:
$var(touser) = $dbr(touser=>[0,0]); if ($var(touser) != $null) { [...] } else { [...] }
perhaps better way to check if any records were returned is to test if $dbr(result=>rows) is greater than 0.
-- juha