##-- web_store.cgi changes (in sub create_html_page_from_db)--##

###- old lines -###
   ($status,$total_row_count) = &submit_query(*database_rows);

###- new lines -###
   ($status,$total_row_count) = &submit_query(*database_rows,
$form_data{'hits_seen'});
   $hits_seen = $form_data{'hits_seen'} + $sc_db_max_rows_returned;

##-- end of web_store.cgi changes --##

_______________________________________________________

##-- web_store_db_lib.pl changes (in sub submit_query)--##

###- old lines -###
   sub submit_query
   {
   local(*database_rows) = @_;

###- new lines -###
   sub submit_query
   {
   local(*database_rows, $hits_seen) = @_;

###- old lines -###
   while(($line = &ltDATAFILE> ) && ($row_count <
$sc_db_max_rows_returned + 1))

###- new lines -###
   while(($line = &ltDATAFILE> ) && ($row_count > -1))

###- old lines -###
   if (($not_found == 0) && ($row_count <= $sc_db_max_rows_returned))

###- new lines -###
   $adjusted_line_number = $sc_db_max_rows_returned + $hits_seen - 1;
   if (($not_found == 0) && ($row_count <= $adjusted_line_number) &&
$row_count >= $hits_seen)

##-- end of web_store_db_lib.pl changes --##

_________________________________________________________

##-- web_store_html_lib.pl changes (in sub product_page_footer) --##

###- look for and add/change/move lines with <*> markers -###
   local($db_status, $total_rows_returned) = @_;
   local($warn_message);
<*> $warn_message = ""; <*> CHANGE TO....
<*>$warn_message = qq!
                                   <p align="center"><i><b>1 -
$total_rows_returned</b> of <b>$total_rows_returned</b></i></p>
                                    !; <*> ....THIS
<*> local($next_amount); <*> ADD THIS
<*> $next_amount = $sc_db_max_rows_returned; <*> ADD THIS
<*> local($hidden_fields) = &make_hidden_fields; <*> ADD THIS

###- end of look/add/change/move lines -###

###- old lines -###
   if ($db_status ne "")
   {
   if ($db_status =~ /max.*row.*exceed.*/i)
   {
   $warn_message = qq!
   &ltCENTER>
   &ltBLOCKQUOTE>
   Your query returned $total_rows_returned. This is more than
   the maximum we allow ($sc_db_max_rows_returned). You will need to
   restrict your query further.
   </BLOCKQUOTE></CENTER>&ltP>!;
   }
   }

###- new lines -###

   if ($hits_seen > 0)
   {
   if ($hits_seen > $sc_db_max_rows_returned)
   {
   $hits_prev = $hits_seen - $sc_db_max_rows_returned -
$sc_db_max_rows_returned;
   $hits_start = $hits_seen - $sc_db_max_rows_returned + 1;
   $warn_message = qq!
   <center>
   <i><b>$hits_start - $total_rows_returned</b> of
<b>$total_rows_returned</b></i><br>
   <table>
   <tr>
   <td>
   <form action = "$sc_main_script_url" method = post>$hidden_fields
   <input type = "hidden" name="hits_seen" value="$hits_prev">
   <INPUT TYPE = "submit" VALUE = "&lt&lt Prev $sc_db_max_rows_returned"
NAME = "search_request_button">
   </form>
   </td>
   </tr>
   </table>
   </CENTER>
   !;
   }
   if ($total_rows_returned >= $hits_seen)
   {
   $hits_prev = $hits_seen - $sc_db_max_rows_returned -
$sc_db_max_rows_returned;
   $hits_start = $hits_seen - $sc_db_max_rows_returned + 1;
   if (($total_rows_returned - $hits_seen) < $sc_db_max_rows_returned)
   {
   $next_amount = $total_rows_returned - $hits_seen;
   }
   $warn_message = qq!
   <center>
   <i><b>$hits_start - $hits_seen</b> of <b>
$total_rows_returned</b></a><br>
   <table><tr>
   !;
   if ($hits_prev > -1)
   {
   $warn_message .= qq!
   <td>
   <form action = "$sc_main_script_url" method = post>$hidden_fields
   <input type = "hidden" name="hits_seen" value="$hits_prev">
   <INPUT TYPE = "submit" VALUE ="&lt&lt Prev $sc_db_max_rows_returned"
NAME = "search_request_button">
   </form>
   </td>
   !;
   } # end if $hits_prev
   $warn_message .= qq!
   <td>
   <form action = "$sc_main_script_url" method = post>$hidden_fields
   <INPUT TYPE = "hidden" NAME = "hits_seen" VALUE= "$hits_seen">
   <INPUT TYPE = "submit" VALUE = "Next $next_amount &gt&gt" NAME =
"search_request_button">
   </form>
   </td></tr>
   </table>
   </CENTER>
   !;
   } # end if $total_rows_returned
   } # end if ($hits_seen > 0)

###- look for and add/change/move lines with <*> markers -###
   print qq~
   $sc_product_display_footer
   <P>
<*> $warn_message <*>  MOVE FROM HERE....

   <CENTER>
   <INPUT TYPE = "submit" NAME = "add_to_cart_button" VALUE = "Add Items
to my Cart">
   <INPUT TYPE = "submit" NAME = "modify_cart_button" VALUE =
"View/Modify Cart">
   $sc_no_frames_button
   <INPUT TYPE = "submit" NAME = "order_form_button" VALUE = "Checkout
Stand">
   </FORM>
<*> $warn_message <*>  ....TO HERE
   </CENTER>
   </BODY>
   </HTML>~;
   }

###- end of look/add/change/move lines -###

##-- end of web_store_html_lib.pl --#