Faisal, <div><br></div><div>yes, that's it!! I'm using 1.8.x , I didn't know about it!!!</div><div>Thank you so much, guy!!!</div><div><br><div class="gmail_quote">On Fri, Feb 18, 2011 at 4:26 PM, Faisal Hanif <span dir="ltr"><<a href="mailto:faisal@vopium.com">faisal@vopium.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div lang="EN-US" link="blue" vlink="purple"><div><p class="MsoNormal"><span style="font-size:10.0pt;color:#1F497D">If you are using asterisk 1.8.x you don’t need to type \ for spaces you can write simple query and use spaces as normal it will work fine.</span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#1F497D"> </span></p><p class="MsoNormal"><span style="font-size:10.0pt;color:#1F497D">Faisal</span></p><p class="MsoNormal"><span style="font-size:10.0pt;color:#1F497D"> </span></p>
<p class="MsoNormal"><b><span style="font-size:10.0pt">From:</span></b><span style="font-size:10.0pt"> <a href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">asterisk-users-bounces@lists.digium.com</a> [mailto:<a href="mailto:asterisk-users-bounces@lists.digium.com" target="_blank">asterisk-users-bounces@lists.digium.com</a>] <b>On Behalf Of </b>Felipe Figueiredo<br>
<b>Sent:</b> Friday, February 18, 2011 11:04 PM<br><b>To:</b> Asterisk Users Mailing List - Non-Commercial Discussion<br><b>Subject:</b> [asterisk-users] Fwd: cmd MySQL</span></p><div><div></div><div class="h5"><p class="MsoNormal">
</p><p class="MsoNormal" style="margin-bottom:12.0pt"> </p><div><p class="MsoNormal" style="margin-bottom:12.0pt">---------- Forwarded message ----------<br>From: <b>Felipe Figueiredo</b> <<a href="mailto:felipe.figueiredo86@gmail.com" target="_blank">felipe.figueiredo86@gmail.com</a>><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" target="_blank">geraldablists@gmail.com</a>><br><br></p><div><div><p class="MsoNormal">
- Executing [200@teste:2] MYSQL("Console/dsp", "Query resultid 1 SELECT\ ramal\ FROM\ colaboradores\ WHERE\ ramal=200") in new stack</p></div></div><div><p class="MsoNormal">[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</p>
</div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal">hi Gerald, </p></div><div><p class="MsoNormal"> </p></div><div><p class="MsoNormal">look, the error is the same. Eveng changing the "/" for "\" ... </p>
</div><div><div><p class="MsoNormal"> </p><div><p class="MsoNormal">On Fri, Feb 18, 2011 at 4:00 PM, Gerald A <<a href="mailto:geraldablists@gmail.com" target="_blank">geraldablists@gmail.com</a>> wrote:</p><p class="MsoNormal" style="margin-bottom:12.0pt">
Hi Felipe,</p><div><div><p class="MsoNormal">On Fri, Feb 18, 2011 at 12:56 PM, Felipe Figueiredo <<a href="mailto:felipe.figueiredo86@gmail.com" target="_blank">felipe.figueiredo86@gmail.com</a>> wrote:</p><p class="MsoNormal">
</p><div><div><p class="MsoNormal">-- Executing [200@teste:2] MYSQL("Console/dsp", "Query resultid 1 SELECT/ ramal/ FROM/ colaboradores/ WHERE/ ramal=200") in new stack</p></div><div><p class="MsoNormal">
[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</p>
</div></div></div><div><p class="MsoNormal"><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</p></div></div></div><p class="MsoNormal"> </p></div></div></div><p class="MsoNormal"> </p></div></div></div></div><br>--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br></blockquote></div><br></div>