Linda, >From my favorite site comes an excellent answer about this question with regards to Oracle specific solution.
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:76812348057 hope it serves you well. People have lots of different approaches. I tend to follow whatever this guy (Tom Kyte) recommends. He is brilliant. This has been asked a lot around here. Job --- Linda Xu <[EMAIL PROTECTED]> wrote: > Hi, > > I am a beginner of using perl. > > I need to write a script to retrived records from > oracle database and > display them in CGI web page by n records per page. > > I use an array reference to store all the records : > > $re_list_ref=$dbh->selectall_arrayref($sql,{}, > @bind); > > How could I make a URL to display next n records? Do > I need to create a > package to print the records? or use a template > file? or redirect to itself? > > > > > TKS > > Linda Xu > General Magic > > __________________________________________________ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com