You can adjust the number of rows to display by modifying Max Rows variable. attached is a custom tag I have and here's how I call it:
<cfparam name="Request.stAttributes.StartRow" default="1">
<cfparam name="Request.stAttributes.MaxRow" default="10">
...
<!--- calling custom tag at top of a list --->
<cf_ctRecordNavigation StartRow=#Request.stAttributes.StartRow#
MaxRows="#Request.stAttributes.MaxRow#" RecordCount=#qryGetContent.recordcount#
TableAlign="Left">
<cfoutput query="qryGetContent" startrow="#Request.stAttributes.StartRow#"
maxrows="#Request.stAttributes.MaxRow#">
... output results
</cfoutput>
...
<!--- calling custom tag at bottom of list --->
<cfif qryGetContent.recordcount GT Request.stAttributes.MaxRow>
<cf_ctRecordNavigation
StartRow=#Request.stAttributes.StartRow# MaxRows="10"
RecordCount=#qryGetContent.recordcount# FormLocation="Bottom" TableAlign="Left">
...
Hope this helps
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 31, 2002 2:27 PM
To: [EMAIL PROTECTED]
Subject: Next/Previous question
I have to show one record at a time with an option to go to next or
previous record. Does anybody has a code for this? I know how to show the
record. I need next/previous logic.
Thanks
(Embedded image moved to file: pic29657.pcx)
ctRecordNavigation.cfm
Description: ctRecordNavigation.cfm
nextRecords.gif
Description: nextRecords.gif
prevRecords.gif
Description: prevRecords.gif
