[prev in list] [next in list] [prev in thread] [next in thread] 

List:       asterisk-users
Subject:    Re: [asterisk-users] MySQL syntax error : I really don't see
From:       Per Jessen <per () computer ! org>
Date:       2009-08-30 12:43:34
Message-ID: h7ds5m$1pg$1 () saturn ! local ! net
[Download RAW message or body]

jonas kellens wrote:

> [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
> [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

You need to separate the selected columns with commas.


/Per Jessen, Zürich

-- 
http://www.spamchek.com/ - your spam is our business.


_______________________________________________
-- 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

[prev in list] [next in list] [prev in thread] [next in thread]