Re: Database Rows Returned

[Sean Davis]

In order to do this, you will need to have some way of determining where you 
are in the count of pages, number of rows, etc., so you will need to store 
some stuff in hidden fields on your page (or in the query string).  Also, 
based on those values, you will need to generate a page and make a way to 
move from one page to the next.  This is a tedious process, but it isn't 
difficult.  However, you don't necessarily need to reinvent the wheel.  If 
you incorporate a data model into your design, like Class::DBI, you can take 
advantage of some of their extension modules, like Class::DBI::Pager. 
Unfortunately, any solution here will require learning a fair amount about 
how your existing code works and how to generate CGI forms.  Again, none of 
this is hard, but I would suggest getting a CGI book if all of the above 
terminology (like hidden fields) sounds foreign.

Sean
----- Original Message ----- 
From: "Literatecat" <[EMAIL PROTECTED]>
To: "Sean Davis" <[EMAIL PROTECTED]>
Cc: <beginners-cgi@perl.org>
Sent: Tuesday, January 04, 2005 7:29 PM
Subject: Re: Database Rows Returned


Hi Sean,
The max_rows_returned is set in the setup file, but it simply determines 
the number of rows per page.  Then when it reads line by line that there 
are more than the predetermined maximum rows per page, it prints the 
warning that the number of rows have been exceeded, and suggests refining 
the search parameters.
In this case, could refining search parameters be as simple as setting a 
limit in the SQL query?

Problem is that I want to be able to pick up all the rows although not all 
on the same page, there must be some way of getting it to change to 
creating a new page with the next line read exceeding the max rows, and so 
on till the search parameter is filled.  Then placing the link to the next 
set of "25" for instance at the bottom of the page instead of suggested 
that the search be refined.
Unfortunately, CGI scripts cannot make decisions like "make a new page". 
Their only job is to generate ONE HTML page based on input from the request. 
At each page generation, you have to provide enough information on the page 
so that the next request (based on a submit button click, for example) 
allows the script to generate the next page when it runs again (eg., you 
have to tell the script what page number in a multiple-page output to 
generate; you can do this with form parameters).

You can see this in operation at 
http://www.etheria.com.au/cgi-bin/web_store.pl?


--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>