Displaying 2 results from an estimated 2 matches for "dnislookup".
Did you mean:
dn_lookup
2007 Apr 16
1
Stuck on MySQL UPDATE
...not sure asterisk will allow
using a variable for the field name and if not, I'll attempt to create
an exten for each bin to update.
Here the method I'd like to use:
exten => sav,n,MYSQL(Connect connid localhost root password dax)
exten => sav,n,MYSQL(QUERY resultid ${connid}UPDATE\ dnislookup\ SET\
${BINID}\ =\ ${NEWPHRASENAME}\ WHERE\ dnis\ =\ ${IVR-Exten})
But I've tried this too:
exten => sav,n,MYSQL(Connect connid localhost root password dax)
exten => sav,n,MYSQL(QUERY resultid ${connid}UPDATE\ dnislookup\ SET\
bin2\ =\ ${NEWPHRASENAME}\ WHERE\ dnis\ =\ ${IVR-Exten})...
2007 Apr 13
2
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...