Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question about cursors

Re: Question about cursors

From: Syltrem <syltremspammenot_at_videotron.com>
Date: Tue, 9 Apr 2002 15:23:59 -0400
Message-ID: <gcHs8.7214$a04.35225@tor-nn1.netcom.ca>


Thanks for responding.
I finished the program yesterday. I have a record that holds session information, and I keep the info in there. This is a variation of what you propose. I don't have control over HTML All works fine now.

Regards,

--

Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove .spammenot from my address

"John Russell" <netnews2_at_johnrussell.mailshell.com> a écrit dans le message
de news: 78h3bu862nmf5jji2k7s4h8emgs3fp8aho_at_4ax.com...

> On Fri, 5 Apr 2002 09:57:59 -0500, "Syltrem"
> <syltremspammenot_at_videotron.com> wrote:
> >The procedure (or package) is called every time the user either enters
the
> >particular screen, or hits next page button.
> >The only info I am receiving from the web site is the sessionId, how many
> >rows fit on the screen, and if it's a new selection (entering screen), or
> >continuation of previous selection (next screen).
> >As I see it, I must keep track of the last row returned, and upon
> >continuation of previous selection, only return the next n rows.
>
> Do you generate the HTML that is displayed on the original web page,
> or have some influence over its contents? If so, you can include
> something like
>
> <input type="hidden" name="lastrowreturned" value="10">
>
> so that when the Next Page button is pressed, this extra piece of
> information is passed to the procedure. Set up the procedure to use a
> default value of null for the parameter, so that it works for the
> original form submission that wouldn't include this parameter.
>
> John
> --
> Got an Oracle database question?
> Try the search engine for the database docs at:
> http://tahiti.oracle.com/
Received on Tue Apr 09 2002 - 14:23:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US