My example wasn't complete. You need to wrap the cursor calls in BEGIN
and END. Read the DECLARE docs for the minutiae.
/Steve
Josh Berkus ([EMAIL PROTECTED]) wrote:
> Unfortunately, your only real option I can see for DB server-side row
> grabbing is: Create the query(ies) as a temporary table or view using a
> function. Then use Limit and Offset to grab one chunk of data at a
> time. This is, of course, a seriou
Stephen,
> How come nobody's ever thought of cursors?
>
> DECLARE foo CURSOR FOR SELECT stuff FROM stuff WHERE foo ORDER BY
> something;
>
> Hop forward N rows?
> MOVE FORWARD $n IN foo
>
> Want M rows?
> FETCH FORWARD $m IN foo
I'm intrigued by this. How would I ret
Paul,
I'm afraid that much of that was over my head. In fact, I'm keeping it
as an example in case I ever need to do something similar. Forward your
info and I'll include credit in the source :-)
In general terms, I've always depended on the PHP to select a "page" of
results, u
Hello,
This is going to be a bit long, I hope some of you will take the
trouble to read it :)
I am building a search engine for a section of a (PHP based) website.
I wish the user to be able to a number of words in the search, and the
search results to be ranked by the number of times words occu
