need help on cgi to get multi pages and could sort by column from Oracle

[robert...@gmail.com]

hi, please help me on:

I want to find like 1000+ records from Oracle database using dbi, but
the view could sort by column and could display by multi pages.

Anyone has this kind of experience?

Robert

[ccc31807]

On Mar 27, 1:55 am, "robertchen...@gmail.com"

This may actually be an SQL issue. If you are using DBI, you can write
your select statement as follows:

select f1, f2, f3, f4 [etc] from tablename where f1 = 'value' order by
columnname

When you get your statement handler, you can create a while loop and a
counter that will insert a break of an appropriate type when the
counter reaches your parameter and will reset the counter.

CC

[xho...@gmail.com]

Yes. There are a lot of ways to do it, with a lot of accompanying trade
offs.

Are you an Oracle developer that uses Perl, or Perl programmer that uses
Oracle? What is more heavily loaded, the CGI server or the Oracle server?
How efficient is the underlying query that returns the 1000+ records?
Are you using CGI sessions or doing sessionless CGI?

Why multiple pages at all? My browser has a scroll bar--let me use it.

How dynamic is the underlying data? What if a database entry that is
currently being displayed on "page one" gets deleted (and committed) from
the database? Now, when the person changes to "page two", everything has
slid up a row, and what would have been the first thing on page two is
missed altogether, because it now would show up on page one but the user
doesn't know that, because they went to the next page rather than
refreshing the current page.

Xho

--
-------------------- http://NewsReader.Com/ --------------------
The costs of publication of this article were defrayed in part by the
payment of page charges. This article must therefore be hereby marked
advertisement in accordance with 18 U.S.C. Section 1734 solely to indicate
this fact.