Returning Records from <cfquery>

[pnugent]

I would like to return a large list of records 300+ to a web page without using
frames. The problem occurs when users scroll up or down to view the records.
The title row moves up and down with the returned records. Is there a way for
the title row to remain stationary? When the row remains stationary for the
large set of records, it will need to autosize to the same column width of the
data being brought back. (hope this makes sense)

I am using CF5.

Thanks!

[The ScareCrow]

Instead of dispaying the whole 300+ records on the single page, only display enough to be viewed without scrolling. Then use pagenation to display the next/previous set of records.

Ken

[pnugent]

How do i use pagenation? Is it a feature in CF?

[The ScareCrow]

No, it's just some code

At the top of the page

<!--- row to start output of query result set --->
<cfparam name="StartRow" default="1">
<!--- maximum number of rows to display --->
<cfparam name="MaxRows" defaylt="20">
<!-- parameter for the previously displayed records --->
<cfparam name="previous" default="0">
<!--- parameter for the next set of records to display --->
<cfparam name="next" default="0">

Then you have you cfoutput query tag, but you use the startrow and maxrows
attributes

<cfoutput query="myQuery" startrow="#startrow#" maxrows="#maxrows#">
<!--- output query resultset --->
</cfoutput>

<!-- set the parameters for the previous/next parameters --->
<cfset previous = startrow - maxrows>
<cfset next = startrow + maxrows>

Then output some links
<!--- only display the previous link if there is a previous --->
<cfif previous GT 0>
<cfoutput>
<a href="myPage.cfm?startrow=#previous#">Previous #maxrows# records</a>
</cfoutput>
</cfif>

<!--- only display the next link if there are records to display --->
<cfif next LTE myQuery.RecordCount>
<cfoutput>
<a href="myPage.cfm?startrow=#next#">Next #maxrows# records</a>
</cfoutput>
</cfif>

Ken