<br><br><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">Felipe Figueiredo</b> <span dir="ltr"><<a href="mailto:felipe.figueiredo86@gmail.com">felipe.figueiredo86@gmail.com</a>></span><br>
Date: Fri, Feb 18, 2011 at 4:03 PM<br>Subject: Re: [asterisk-users] cmd MySQL<br>To: Gerald A <<a href="mailto:geraldablists@gmail.com">geraldablists@gmail.com</a>><br><br><br><div class="im"><div>- Executing [200@teste:2] MYSQL("Console/dsp", "Query resultid 1 SELECT\ ramal\ FROM\ colaboradores\ WHERE\ ramal=200") in new stack</div>
</div><div>[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</div>
<div><br></div><div>hi Gerald, </div><div><br></div><div>look, the error is the same. Eveng changing the "/" for "\" ... </div><div><div></div><div class="h5"><br><div class="gmail_quote">On Fri, Feb 18, 2011 at 4:00 PM, Gerald A <span dir="ltr"><<a href="mailto:geraldablists@gmail.com" target="_blank">geraldablists@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Felipe,<br><br><div class="gmail_quote"><div>On Fri, Feb 18, 2011 at 12:56 PM, Felipe Figueiredo <span dir="ltr"><<a href="mailto:felipe.figueiredo86@gmail.com" target="_blank">felipe.figueiredo86@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0pt 0pt 0pt 0.8ex;border-left:1px solid rgb(204, 204, 204);padding-left:1ex">
<br><div><div>-- Executing [200@teste:2] MYSQL("Console/dsp", "Query resultid 1 SELECT/ ramal/ FROM/ colaboradores/ WHERE/ ramal=200") in new stack</div>
<div>[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</div>
</div></blockquote></div><div><br>I'm not Asterisk-MySQL guru, but shouldn't the "/" be "\"?<br><br>I'm guessing you are trying to keep a string together here, but maybe I'm mistaken.<br>
<br>
Thanks,<br>Gerald<br></div></div>
</blockquote></div><br>
</div></div></div><br>