No amount of fiddling was helping. the only thing that worked was remove every deprecated server behaviour through the DW panel. Look through your code to see if anything was left behind. Then re-do the entire page again.
THEN it works.
The recordsets are still created with a limit of 1 by default it seems, but when you put it into a repeating region it removes the limit.
Webassist still crashes DW constantly. If I was working on a PC when a crash takes minutes for the software to close down and more minutes to either reboot the computer and open the software again... I'm now on a mac so it crashes in half a second and takes on second to get everything back again. Not a good reason to keep using software that costs a significant amount of money..... please fix the crashing.