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.
--
_____________________________________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
New to Asterisk? Join us for a live introductory webinar every Thurs:
http://www.asterisk.org/hello
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
