[asterisk-users] Mysql dialplan statement not executed

[Jonas Kellens]

On 09/14/2011 02:51 PM, Jonas Kellens wrote:
> Hello,
>
> I do the following in a macro in the dialplan :
>
> exten => s,n,MYSQL(Connect connid localhost user password AsteriskDB)
> exten => s,n,MYSQL(Query resultid ${connid} UPDATE custDB SET active=1 
> WHERE routeID=${ARG1} AND nr=1)
> exten => s,n,MYSQL(Disconnect ${connid})
>
> But nothing changes in my database...

OK I clearly need to use ", like this :

exten => s,n,MYSQL(Query resultid ${connid} UPDATE custDB SET active='1' 
WHERE routeID="${ARG1}" AND nr="1")

Solved.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110914/f1b34d18/attachment.htm>