Posted by J.O. Aho on 01/10/06 17:26

Stefan Rybacki wrote:
> J.O. Aho wrote:
>>> Stefan Rybacki wrote:
>>>> J.O. Aho wrote:
>>> ...
>>>
>>> I hope this explains enough for you to see how the procedure works.
>>>
>
> Yes thanks, you're right. I just didn't saw the obvious and thought to
> complicated, sorry. ;)

Nothing to be sorry about, gosh I did fight with this procedure myself for
many hours, was doing the fetch loop with a while loop where I used limit to
decide the line from the database to get, but sadly (or luckily) limit don't
take variables as arguments, you have always give them constant values.

The main thing is that Joe gets his query to work, no matter if it's with
subselects or procedures.


//Aho

[Back to original message]