asterisk users - Apr 2007 - MySQL query from extensions?

What wrong with this:

[get-dnisinfo]
; sub-routine to get owner's password
exten => s,1,Verbose(  == )
exten => s,n,MYSQL(Connect connid localhost root password dax)
exten => s,n,MYSQL(Query resultid ${connid} SELECT\ password\ FROM\ 
dnislookup\ WHERE\ dnis=\'${IVR-Exten}\')
exten => s,n,MYSQL(Fetch fetchid ${password} password)
exten => s,n,Verbose(  == Password found was 
[${password}]-[${connid}]-[${fetchid}]-[${resultid}] )
exten => s,n,MYSQL(Clear ${password})
exten => s,n,MYSQL(Disconnect ${connid})
exten => s,n,return

I found no less than 15 ways to write this query on the net searches 
(with and without escapes and quotes), now I give up and ask here.  I 
can do this query from the command and get the correct results.

any ideas?

Thanks, Bart

Barton Fisher wrote:
> What wrong with this:
>
> [get-dnisinfo]
> ; sub-routine to get owner's password
> exten => s,1,Verbose(  == )
> exten => s,n,MYSQL(Connect connid localhost root password dax)
> exten => s,n,MYSQL(Query resultid ${connid} SELECT\ password\ FROM\ 
> dnislookup\ WHERE\ dnis=\'${IVR-Exten}\')
> exten => s,n,MYSQL(Fetch fetchid ${password} password)
> exten => s,n,Verbose(  == Password found was 
> [${password}]-[${connid}]-[${fetchid}]-[${resultid}] )
> exten => s,n,MYSQL(Clear ${password})
> exten => s,n,MYSQL(Disconnect ${connid})
> exten => s,n,return
This is what I do for our speed dialing, it would appear that the 
problem is in your fetch:

; *******************************************************
; Set speed.dial name and number from the database entry 
; *******************************************************

exten => s,4,MYSQL(Connect connid 192.168.101.25 anonymous ''
speeddials)
exten => s,5,MYSQL(Query resultid ${connid} SELECT phone \, name FROM 
company WHERE number = ${ARG1})
exten => s,6,MYSQL(Fetch fetchid ${resultid} speed.dial speed.name)
exten => s,7,MYSQL(Disconnect ${connid})
exten => s,8,MYSQL(Clear ${resultid})


Doug

-- 
 
Ben Franklin quote:

"Those who would give up Essential Liberty to purchase a little Temporary
Safety, deserve neither Liberty nor Safety."

On Fri, 13 Apr 2007, Barton Fisher said something to this effect:
> What wrong with this:
   Well... what is wrong with it?  :-)

   I'm not trying to be funny, but, what are the symptoms that it
doesn't
work?  Error output on Asterisk console?  Logs?  Anything you can provide 
would be helpful.

-- Alex

--
Alex Balashov <sasha@presidium.org>