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.

Hey Randi

If you want to return all records from a recordset you need to replace the 1 with a 0 (if you want to return a specific number of records, say 5, just replace the 1 with 5 or whatever number you want)

from this

<?php
$rsAuthors = new WA_MySQLi_RS("rsAuthors",$icmids,1);
$rsAuthors->setQuery("SELECT DISTINCT Author FROM abstracts ORDER BY Author ASC ");
$rsAuthors->execute();
?>

to this

<?php
$rsAuthors = new WA_MySQLi_RS("rsAuthors",$icmids,0);
$rsAuthors->setQuery("SELECT DISTINCT Author FROM abstracts ORDER BY Author ASC ");
$rsAuthors->execute();
?>

Yup - that worked, Jamie.

Wonder why MySQLi sets a " LIMIT" in the SQL by default and if there is a way to disable this?

Glad it worked!

I believe it just defaults to 1 but you are able to either manually change as above or use the mysqli repeat region function to select the number you want to set it to - I dont know if the default is changeable.

Jamie

The default is not changeable.

It defaults to 1 to ensure that overlarge data sets are not created that could overload the servers memory and other resources.

The thinking is that if you are not using a repeat region to return more rows, then really you will most likely only use the first record in the result.

In the recordset you can set the limit to 0 if you don't want to add a repeat.