How to remove "LIMIT 1"
MySQLi recordset builder is inserting by default a "LIMIT 1" SQL parameter. I cannot remove it via the builder (GUI) and if I remove the ",1" from within in the code, the recordset no longer displays in the Server Behavior panel. Is this a default setting I must defeat? If so, how?
Displayed in the code:
<?php
$rsAbstracts = new WA_MySQLi_RS("rsAbstracts",$icmids,1);
$rsAbstracts->setQuery("SELECT abstracts.* FROM abstracts");
$rsAbstracts->execute();
?>
<?php
$rsAuthors = new WA_MySQLi_RS("rsAuthors",$icmids,1);
$rsAuthors->setQuery("SELECT DISTINCT Author FROM abstracts ORDER BY Author ASC ");
$rsAuthors->execute();
?>
See "LIMIT 1" displayed in the attached screen capture of the GUI.