<div>That's the correct syntax:</div>
<div>
<p>exten => s,1,Noop()<br>exten => s,n,MYSQL(Connect connid localhost root passw0rd dax)</p>
<p>exten => s,n,MYSQL(Query resultid ${connid} SELECT\ password\ FROM\ dnislookup\ WHERE\ dnis=${IVR-Exten})<br>exten => s,n,MYSQL(Fetch fetchid ${resultid} password)</p>
<p>exten => s,n,MYSQL(Clear ${password})<br>exten => s,n,MYSQL(Disconnect ${connid})<br>exten => s,n,returnpes</p></div>
<div><span class="gmail_quote">On 4/14/07, <b class="gmail_sendername">Barton Fisher</b> <<a href="mailto:bhfisher@icpage.com">bhfisher@icpage.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Sorry,<br>From the logs I see:<br><br>Apr 13 13:32:06 WARNING[19854] app_addon_sql_mysql.c: Identifier 0,<br>
identifier_type 2 not found in identifier list<br>Apr 13 13:32:06 WARNING[19854] app_addon_sql_mysql.c: aMYSQL_fetch:<br>Invalid result identifier 0 passed<br><br>Using this:<br><br>exten => s,1,Noop()<br>exten => s,n,MYSQL(Connect connid localhost root passw0rd dax)
<br>exten => s,n,MYSQL(Query resultid ${connid} SELECT\ password\ FROM\<br>dnislookup\ WHERE\ dnis=\'${IVR-Exten}\')<br>exten => s,n,MYSQL(Fetch fetchid ${password} password)<br>exten => s,n,MYSQL(Clear ${password})
<br>exten => s,n,MYSQL(Disconnect ${connid})<br>exten => s,n,return<br><br>Bart<br><br>Alex Balashov wrote:<br>> On Fri, 13 Apr 2007, Barton Fisher said something to this effect:<br>><br>>> What wrong with this:
<br>><br>> Well... what is wrong with it? :-)<br>><br>> I'm not trying to be funny, but, what are the symptoms that it<br>> doesn't work? Error output on Asterisk console? Logs? Anything you
<br>> can provide would be helpful.<br>><br>> -- Alex<br>><br>> --<br>> Alex Balashov <<a href="mailto:sasha@presidium.org">sasha@presidium.org</a>><br>> _______________________________________________
<br>> --Bandwidth and Colocation provided by <a href="http://Easynews.com">Easynews.com</a> --<br>><br>> asterisk-users mailing list<br>> To UNSUBSCRIBE or update options visit:<br>> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users">
http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>><br>><br>><br>> __________ NOD32 2187 (20070413) Information __________<br>><br>> This message was checked by NOD32 antivirus system.<br>>
<a href="http://www.eset.com">http://www.eset.com</a><br>><br>><br>><br><br><br><br>_______________________________________________<br>--Bandwidth and Colocation provided by <a href="http://Easynews.com">Easynews.com
</a> --<br><br>asterisk-users mailing list<br>To UNSUBSCRIBE or update options visit:<br> <a href="http://lists.digium.com/mailman/listinfo/asterisk-users">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote>
</div><br>