<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
</head>
<body 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>
Jonas.<br>
</font>
</body>
</html>