Hi list,
I'm stuck for the moment @ the following :
My Query (in a macro) :
exten => s,n,MYSQL(Query resultid ${connid} SELECT\ vakantie_set\
vakantie_data1\ vakantie_data2\ FROM\ AstDB\ where\
SIPACCOUNT="${ARG1}")
Asterisk CLI :
[Aug 30 14:07:42] -- Executing [...@macro-vakantie:2]
MYSQL("IAX2/zoiper-9238", "Query resultid 1 SELECT vakantie_set
vakantie_data1 vakantie_data2 FROM AstDB where SIPACCOUNT="092779077"")
in new stack
[Aug 30 14:07:42] WARNING[26029]: app_addon_sql_mysql.c:335
aMYSQL_query: aMYSQL_query: mysql_query failed.
Error: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'vakantie_data2 FROM AstDB where SIPACCOUNT="092779077"' at line 1
Greetingz,
Jonas.
_______________________________________________
-- Bandwidth and Colocation Provided by http://www.api-digital.com --
AstriCon 2009 - October 13 - 15 Phoenix, Arizona
Register Now: http://www.astricon.net
asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo/asterisk-users
