Sorry,
From the logs I see:

Apr 13 13:32:06 WARNING[19854] app_addon_sql_mysql.c: Identifier 0, identifier_type 2 not found in identifier list Apr 13 13:32:06 WARNING[19854] app_addon_sql_mysql.c: aMYSQL_fetch: Invalid result identifier 0 passed

Using this:

exten => s,1,Noop()
exten => s,n,MYSQL(Connect connid localhost root passw0rd 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,MYSQL(Clear ${password})
exten => s,n,MYSQL(Disconnect ${connid})
exten => s,n,return

Bart

Alex Balashov wrote:
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 <[EMAIL PROTECTED]>
_______________________________________________
--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



__________ NOD32 2187 (20070413) Information __________

This message was checked by NOD32 antivirus system.
http://www.eset.com






_______________________________________________
--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

Reply via email to