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">davidv.net</a>@<a href="http://gmail.com">gmail.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 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></div><br>