The problem is the OP never performs a Fetch of the data returned by the
Query...
From the VoIP-info page for Cmd MYSQL
MYSQL(Query resultid ${connid} query-string)
Executes standard MySQL query contained in query-string using established
connection identified by ${connid}. Result of query is stored in ${resultid}.
MYSQL(Fetch fetchid ${resultid} var1\ var2\ ...\ varN)
If any rows are available to select, ${fetchid} is set to 1 and a single row is
fetched from a result set contained in ${resultid}. The return fields are
assigned to ${var1}, ${var2} ... ${varN} respectively. If no rows are left to
select, ${fetchid} is set to 0 and ${var1}, ${var2} ... ${varN} remain
unchanged. --
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
