More loopy looism
Here’s a little thing I was forced to realise after a far too high profile site when slightly wrong (in a far too big way).
Looping a query inside a loop of another query changes the way you can refer to the outer-loops current row. Running the following code demonstrates this:
The problem is that you cannot access the current row of the qry_foo query when inside the loop of qry_bar in this way. Instead, you would have to use:
Does anyone else find this bizarre?