Thank you Prasad.<br><br clear="all">David V.<br>
<br><br><div class="gmail_quote">2009/11/3 Prasad <span dir="ltr"><<a href="mailto:prasad@vtiger.com">prasad@vtiger.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi David,<br><br>As you pointed out DESC rule has been skipped in the lexer, you will need to add it and re-build the parser file.<br><br>Regards,<br>Prasad<br><br><div><div><div></div><div class="h5"><span class="gmail_quote">On 11/2/09, <b class="gmail_sendername">David V.</b> <<a href="http://davidv.net" target="_blank">davidv.net</a>@<a href="http://gmail.com" target="_blank">gmail.com</a>> wrote:</span></div>
</div><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div></div><div class="h5">
Hi Prasad,<br><br>Do you have any idea about the ORDER BY ... DESC question ?<br>(please see below)<br><br>Thank you very much.<br><br clear="all">David V.<br>
<br><br><div class="gmail_quote">2009/10/31 David V. <span dir="ltr"><<a href="http://davidv.net" target="_blank">davidv.net</a>@<a href="http://gmail.com" target="_blank">gmail.com</a>></span><div>
<span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Hi Vtiger developers !<br><br>Is it me or ORDER BY DESC does not work in Vtiger WebServices ?<br><br>The following query works perfectly :<br><br> $query = "SELECT * FROM mds_computer <br> WHERE id > '33x39996'<br>
AND data_server_ip = '".$backup_server."' <br> ORDER BY computername<br> LIMIT 10<br> ";<br><br>This one also works but the problem is that the DESC is not taken in account. So the query retrieves data in the same order :<br>
<br> $query = "SELECT * FROM mds_computer <br> WHERE id > '33x39996'<br> AND data_server_ip = '".$backup_server."' <br> ORDER BY computername DESC<br>
LIMIT 10<br> ";<br><br>In the file include/WebservicesVTQL_Lexer.php.php line 133 I can see that DESC is supported.<br><br>But in include/Webservices/VTQL_Parser.php line 307 (and also line 150) DESC is not used.<br>
<br>Did anyone sucessfully make ORDER BY DESC work ?<br><font color="#888888"><br><br clear="all">David V.<br>
</font></blockquote></span></div></div><br>
<br></div></div>_______________________________________________<br>
Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com" target="_blank">http://jobs.vtiger.com</a> <br></blockquote></div><br>
<br>_______________________________________________<br>
Reach hundreds of potential candidates - <a href="http://jobs.vtiger.com" target="_blank">http://jobs.vtiger.com</a> <br></blockquote></div><br>