When using a repeat region, the limit is set to the number of records you select to return.
what this means is:
by default when you create a recordset, the limit is set to 1.
This gets changed when you apply the repeat region. you say that when you applied the repeat region, the limit was set to 0, this would happen if you selected to return all rows in the repeat region behavior.
so, create the basic recordset with out the limit applied, add the column binding to your page with the repeat region around it, in the repeat region, set the number of records to return to 4. this will update the limit in the recordset to 4.
to show the current starting record number and the ending record number, use the WebAssist -> MySQLi -> Display Record Count -> MySQLI Display Starting Record Number and MySQLI Display Ending Record Number behaviors
to page through the recordset use the MySQLi recordset paging controls
