Caching data from resultset
This works fine when:
WHERE ROWNUM BETWEEN 1 and 10
But when I use:
WHERE ROWNUM BETWEEN 11 AND 20
I get no rows returned.
Any ideas why?
-Original Message-
From: Kies, Daniel [mailto:[EMAIL PROTECTED]
Sent: Monday, June 14, 2004 12:52 PM
To: 'St
Caching data from resultset
This works fine when:
WHERE ROWNUM BETWEEN 1 and 10
But when I use:
WHERE ROWNUM BETWEEN 11 AND 20
I get no rows returned.
Any ideas why?
-Original Message-
From: Kies, Daniel [mailto:[EMAIL PROTECTED]
Sent: Monday, June 14, 2004 12:52 PM
To: 'St
I recently implemented pagination for resultsets using Oracle 9i. Instead
of loading up the entire resultset into memory, I just queried based on the
records that the user requested.
1) Before getting the records, I first counted the records that were coming
back in the result. That way I can
Question:
I am trying to put two parameters into the request, but with this code, only
the second parameter, offer, gets into the request.
Link
If I take offer out and the code looks like this:
Link
The request will get populated with the student data with no problem. What
is the best way t
4 matches
Mail list logo
