I expect that your same query when executed directly on MySQL console executes successfully ! Normally errors in DB queries are printed on CLI but apparently there is nothing wrong.<br><br><div class="gmail_quote">On Wed, Sep 14, 2011 at 5:51 PM, Jonas Kellens <span dir="ltr"><<a href="mailto:jonas.kellens@telenet.be">jonas.kellens@telenet.be</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><u></u>
<div text="#000000" bgcolor="#ffffff">
<font face="Helvetica, Arial, sans-serif">Hello,<br>
<br>
I do the following in a macro in the dialplan :<br>
<br>
exten => s,n,MYSQL(Connect connid localhost user password
AsteriskDB)<br>
exten => s,n,MYSQL(Query resultid ${connid} UPDATE custDB SET
active=1 WHERE routeID=${ARG1} AND nr=1)<br>
exten => s,n,MYSQL(Disconnect ${connid})<br>
<br>
But nothing changes in my database...<br>
<br>
This is the CLI :<br>
<br>
[Sep 14 16:41:04] -- Executing [s@macro-bal:15]
MYSQL("SIP/vc5-0000000b", "Connect connid localhost user password
AsteriskDB") in new stack<br>
[Sep 14 16:41:04] -- Executing [s@macro-bal:16]
MYSQL("SIP/vc5-0000000b", "Query resultid 15 UPDATE </font><font face="Helvetica, Arial, sans-serif">custDB</font><font face="Helvetica, Arial, sans-serif"> SET active=1 WHERE
routeID=195 AND nr=1") in new stack<br>
[Sep 14 16:41:04] -- Executing [s@macro-bal:17]
MYSQL("SIP/vc5-0000000b", "Disconnect 15") in new stack<br>
<br>
Seems OK, no warnings. But the update has not taken place.<br>
<br>
<br>
Kind regards,<br><font color="#888888">
Jonas.<br>
</font></font>
</div>
<br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</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" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br>