[asterisk-users] What is wrong in m

[Sherwood McGowan]

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. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110607/674e382c/attachment.htm>