<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1491" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>I have asterisk-addons compiled properly etc. and
can insert records into a database using;</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>exten => 2982,1,mysql(Connect connid
10.0.0.9 dbuser dbpass dbname)<BR>exten =>
2982,2,noop(${CALLERIDNUM},${UNIQUEID})<BR>exten => 2982,3,mysql(Query res
${connid} 'INSERT INTO caller_id(caller_id_num,caller_id_name,call_time)
VALUES(\${CALLERIDNUM}\,\${CALLERIDNAME},NOW())')<BR>exten =>
2983,4,mysql(Clear ${res})<BR>exten => 2983,5,mysql(Disconnect
${connid})<BR>exten => 2982,6,Hangup</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>But priority 4 gives an error that there is no
${res} (i assume because this is an insert cmd not a retreival cmd) and never
advances to the next priority. This maintains the connection to mysql and
eventually stops allowing additional entries to the db.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Any ideas on why the extension doesnt advance
priority after inserting the values to the db?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I grabbed the above syntax from the archives from a
'working' config. but can't seem to figure this out. I have tried several
variances on this syntax but none seem to work as I would have
thought.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Jason Kawakami</FONT></DIV>
<DIV><FONT face=Arial size=2><A
href="http://www.optellabs.com">www.optellabs.com</A></FONT></DIV>
<DIV><FONT face=Arial size=2>Salt Lake City, UT</DIV></FONT></BODY></HTML>