<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#ffffff">
<font face="Helvetica, Arial, sans-serif">On 09/14/2011 02:51 PM,
Jonas Kellens wrote:</font>
<blockquote cite="mid:4E70A357.3000109@telenet.be" type="cite">
<meta http-equiv="content-type" content="text/html;
charset=ISO-8859-1">
<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>
</font></blockquote>
<font face="Helvetica, Arial, sans-serif"><br>
OK I clearly need to use ", like this :<br>
<br>
</font><font face="Helvetica, Arial, sans-serif"> exten =>
s,n,MYSQL(Query resultid ${connid} UPDATE custDB SET active='1'
WHERE routeID="${ARG1}" AND nr="1")<br>
<br>
Solved.<br>
</font>
</body>
</html>