Re: [asterisk-users] What is wrong in m

2011-06-07 Thread 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

Re: [asterisk-users] What is wrong in m

2011-06-07 Thread Steve Edwards
On Tue, 7 Jun 2011, Bruce B wrote: What is wrong in below asterisk application? The output should be content of field booth_status from table booths: I don't see 'booth_status' or 'booths' anywhere below. [extension-status] exten => _X.,1,MYSQL(Connect connid 127.0.0.1 root password my-exten

[asterisk-users] What is wrong in m

2011-06-07 Thread Bruce B
Hi everyone, What is wrong in below asterisk application? The output should be content of field booth_status from table booths: [extension-status] exten => _X.,1,MYSQL(Connect connid 127.0.0.1 root password my-extensions) exten => _X.,n,MYSQL(Query allow_call ${connid} SELECT extension_status FR