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...
This is the CLI :
[Sep 14 16:41:04] -- Executing [s@macro-bal:15]
MYSQL("SIP/vc5-0000000b", "Connect connid localhost user password
AsteriskDB") in new stack
[Sep 14 16:41:04] -- Executing [s@macro-bal:16]
MYSQL("SIP/vc5-0000000b", "Query resultid 15 UPDATE custDBSET active=1
WHERE routeID=195 AND nr=1") in new stack
[Sep 14 16:41:04] -- Executing [s@macro-bal:17]
MYSQL("SIP/vc5-0000000b", "Disconnect 15") in new stack
Seems OK, no warnings. But the update has not taken place.
Kind regards,
Jonas.
--
_____________________________________________________________________
-- 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
