Re: [Q] CGI with Oracle: rows limit.

I use OWAS with PL/SQL code like this:

owa_util.cellsprint(sel,listsize-1, null, recpointer, moredata);

where

    sel = select statement (the query)
    listsize = the number of rows returned per page     recpointer = the starting row in the query     moredata = boolean that indicated if there's more to come

The first time the function is launched, set recpointer to 1 and the next-button schould set the recpointer to recpointer + listsize (and call the function again).

I know it's kinda brief, but if this is what you are looking for and need more info, please contact me.

HTH, Jochen.

Mattia schreef:

> Hi I need to do a CGI application that makes a search in my Oracle DBMS that
> looks like an internet search engine (altavista, hotbot) query:
> An HTML form is presented to the user, and when the user clicks on the
> 'submit' button an SQL query is fired by my CGI program. The user gets in
> return the first 20 rows generated by the query, because the resulting table
> may be very long. In the returning page the user is given the opportunity to
> view the following 20 results. (the rows of the resulting table are likely
> to be much more than 20)
> My CGI program fires the SQL query and print out the first 20 lines of the
> resulting table (and discards the following)
>
> Now comes the question: is it possible to limit the number of the rows of
> the table resulting from the SQL query, so that the DBMS doesn't have to do
> a huge job every time the SQL query is fired?
>
> Thanx in advance
>
> Mattia Cazzola
Received on Mon Oct 19 1998 - 07:58:28 CDT