Nested Loop and LIMIT 4,3

Hello,
Any progress on offering a nested looping condition in the MySQLi Behavior?

Also the LIMIT parameter seems to be getting striped out of generated queries.

1st goal:
Select 6 records and then display (2) rows with 3 records per row.


2nd goal:
Create a second Recordset that only returns the 4th , 5th and 6th records from a duplicate recordset

select something
from somewhere
LIMIT 4,3 <-- start at 4th record and display 3 more

This sounds like a bug I may need to address.... so if I just add the limit to a Recordset manually and then open and close the recordset interface then it causes the issue? I'll take a look now and see if we can get it updated so that doesn't happen.

Ray,
I believe it is a conflict with the Repeat Region behavior as it is not suited to accept two variables. Repeat region accepts the comma separated value but I don't think it is looking for this so it clashes with the Recordset when the LIMIT 3,4 is set in place.

I see, yeah that makes sense.

The repeat region tries to add a limit to adjust the number of rows displayed. I'll see if I can figure out a way for it to be smarter with complex limit statements.