possible webassist query rewriting bug when using LIMIT and trying to ORDER BY with more than a single field?
I have just disocvered that webassist is automatically rewriting my queries, which is now why I believe (but possibly wrongly) that I have been unable to put together my pages and queries.
If I try to use variables to set up the following query with LIMITs in place and so I can control the paging:
<?php $starthighlight = 1;
$numberofhighlights = 4; ?>
$rsPresenterHighlights = new WA_MySQLi_RS("rsPresenterHighlights",$mysqli_navayogimarga,$numberofhighlights,$starthighlight);
$rsPresenterHighlights->setQuery("SELECT * FROM presenter_data WHERE ID >= 1 ORDER BY `Last`,`First` ASC ");
then when I run the script, webassist eventually overwrites my original query to:
$rsPresenterHighlights = new WA_MySQLi_RS("rsPresenterHighlights",$mysqli_navayogimarga,0);
$rsPresenterHighlights->setQuery("SELECT * FROM presenter_data ");
meaning it ignores my requests. And since the query is of course at the head, it never previously occurred to me to go back and check what was happening.
I have also found that QueryBuilder is failing. It either hangs; or else it tells me that it cannot recognize any of the table or columns, and that these will be deleted. I therefore used some third-party software to build the queries I wanted; which I am now finding webassist will not accept.
I am hopeful that some kind of workaround exists that will allow me to achieve the objectives I have in mind?
I still accept that I am somehow applying a flawed logic, and that that is why the queries are not "sticking", and not allowing me to use the variables I need.
Thank you for your kindness.