the default setting is 1 (which returns 1 record) but you can change it to 0 (all records) or specify the number of records you want to return just by changing in code view the value shown after the database connection reference within the recordset manually:
example for all records:
<?php
$Gallery = new WA_MySQLi_RS("Gallery",$DBConnection,0);
$Gallery->setQuery("SELECT * FROM gallery");
$Gallery->execute();
?>
example for 1 record:
<?php
$Gallery = new WA_MySQLi_RS("Gallery",$DBConnection,1);
$Gallery->setQuery("SELECT * FROM gallery");
$Gallery->execute();
?>
example for 10 recrods:
<?php
$Gallery = new WA_MySQLi_RS("Gallery",$DBConnection,10);
$Gallery->setQuery("SELECT * FROM gallery");
$Gallery->execute();
?>
So you can see that it is very easy to add that back in if you remove the LIMIT from the query within the recordset snapin.