[asterisk-users] Fwd: cmd MySQL

[Felipe Figueiredo]

---------- Forwarded message ----------
From: Felipe Figueiredo <felipe.figueiredo86 at gmail.com>
Date: Fri, Feb 18, 2011 at 4:03 PM
Subject: Re: [asterisk-users] cmd MySQL
To: Gerald A <geraldablists at gmail.com>


- Executing [200 at teste:2] MYSQL("Console/dsp", "Query resultid 1 SELECT\
ramal\ FROM\ colaboradores\ WHERE\ ramal=200") in new stack
[Feb 18 16:01:42] WARNING[7749]: app_mysql.c:393 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 '\ ramal\ FROM\ colaboradores\ WHERE\ ramal=200' at line 1

hi Gerald,

look, the error is the same. Eveng changing the "/" for "\" ...

On Fri, Feb 18, 2011 at 4:00 PM, Gerald A <geraldablists at gmail.com> wrote:

> Hi Felipe,
>
> On Fri, Feb 18, 2011 at 12:56 PM, Felipe Figueiredo <
> felipe.figueiredo86 at gmail.com> wrote:
>
>>
>> -- Executing [200 at teste:2] MYSQL("Console/dsp", "Query resultid 1 SELECT/
>> ramal/ FROM/ colaboradores/ WHERE/ ramal=200") in new stack
>> [Feb 18 15:55:13] WARNING[7696]: app_mysql.c:393 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 '/ ramal/ FROM/ colaboradores/ WHERE/
>> ramal=200' at line 1
>>
>
> I'm not Asterisk-MySQL guru, but shouldn't the "/" be "\"?
>
> I'm guessing you are trying to keep a string together here, but maybe I'm
> mistaken.
>
> Thanks,
> Gerald
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110218/8c0d3155/attachment.htm>