Subject | Re: How to implement "fetch data on demand" at SQL level |
---|---|
Author | Adam |
Post date | 2004-12-20T22:50:49Z |
> This is what I want, but can I use the parameters toWilliam,
> pass the m and n value to SELECT statement, like:
>
> Select first :m skip :n .....
>
> Thanks
>
> William
>
You can pass in m and n just like you would pass in a parameter inside
the where clause. Alternatively, you could create a stored procedure
that accepted m and n as inputs and returned the result, it is up to you.
Just be careful that your query is kind to the database, as you are
really multiplying its workload to implement it. It may be possible to
do it efficiently from the client side.
Adam