<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 TRANSITIONAL//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; CHARSET=UTF-8">
<META NAME="GENERATOR" CONTENT="GtkHTML/3.24.5">
</HEAD>
<BODY>
Hi list,<BR>
<BR>
I'm stuck for the moment @ the following :<BR>
<BR>
My Query (in a macro) :<BR>
<BR>
exten => s,n,MYSQL(Query resultid ${connid} SELECT\ vakantie_set\ vakantie_data1\ vakantie_data2\ FROM\ AstDB\ where\ SIPACCOUNT="${ARG1}")<BR>
<BR>
Asterisk CLI :<BR>
<BR>
[Aug 30 14:07:42] -- Executing [s@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<BR>
[Aug 30 14:07:42] WARNING[26029]: app_addon_sql_mysql.c:335 aMYSQL_query: aMYSQL_query: mysql_query failed.<BR>
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<BR>
<BR>
<BR>
Greetingz,<BR>
Jonas.
</BODY>
</HTML>