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
_______________________________________________
--Bandwidth and Colocation provided by Easynews.com --
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
