Forum OpenACS Q&A: Response to SQL tip: Find NEXT in Result

Collapse
Posted by MaineBob OConnor on

David, I like your answer.... It would work with repeated clicks on my "Save and Next" button.

Don, (To help with my learning and for future use) I see that I could use a TCL count variable in my loop to know the offset but is there a way to know the number of the row returned by pg, some internal PG variable like oid and in this example "pg_count":

select first_names, user_id, pg_count from users where...
Then I could use pg_count+1 in the offset in a later query.

Thanks
-Bob