Hello,
I followed a coded example from QUE's CF Web App Construction Kit 2nd ed.
book. It displays 5 records at a time and then displays a button which a
user can click to display the next 5 records and so on.
The code given, however, displays the first set of 5 records and when I
click the "Next 5 records" button it STILL displays the first 5 records; it
does not go to the next set of five records and so on.
Any suggestions/ corrections please? Thanks.
Robert Orlini
Web Admin
========================================================================
Here is some of the code(I took out some of the HTML and data fields to make
it easy to read):
<CFSET MaxRows = 5>
<CFPARAM Name="start" Default="1">
<CFPARAM Name="id" Default="">
<CFPARAM Name="orderdate" Default="">
<CFPARAM Name="customer" Default="">
<CFPARAM Name="state" Default="">
<CFPARAM Name="country" Default="">
<CFPARAM Name="institution" Default="">
<CFPARAM Name="phone" Default="">
<CFPARAM Name="email" Default="">
<CFPARAM Name="city" Default="">
<CFPARAM Name="address" Default="">
<cfquery name="Getcustomer" datasource="catalog99">
SELECT * FROM 99catalog
Where id = id
Order by id
</cfquery>
<CFOUTPUT QUERY="Getcustomer" Startrow="#start#" Maxrows="#maxrows#">
(Data is output here)
</cfoutput>
<CFSET NextStart = Start + Maxrows>
<CFOUTPUT>
<FORM ACTION="getcatalog2.cfm" Method="POST"
<input type="hidden" name="start" value="#NextStart#">
<input type="hidden" name="customer" value="#customer#">
<input type="hidden" name="institution" value="#institution#">
<input type="hidden" name="state" value="#State#">
<input type="hidden" name="city" value="#city#">
<input type="hidden" name="country" value="#country#">
<input type="hidden" name="institution" value="#institution#">
<input type="hidden" name="orderdate" value="#orderdate#">
<input type="hidden" name="phone" value="#phone#">
<input type="hidden" name="email" value="#email#">
<Input type="submit" value="Next #maxrows#">
</form>
</cfoutput>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
