Skip record set results

[t.d.]

Hi, just wondering if anyone knows a simple way to filter out the 1st 5 records
in a record set. I'm trying to get a page to display the 1st 5 records from a
database, with another table which will display the next 5 underneath it. The
problem I'm having to getting the proper filter to skip the first 5. Appreciate
it if anyone can help.

[cgsj_usa@yahoo.com]

There are startrow and endrow attributes included with the cfoutput tag. You can use these to limit your results. Hope that this helps. Thanks.

Chris

[t.d.]

I'm a little unsure where to put them though, and what to let them equal to.
What I have at the moment is: <cfoutput> <cfoutput query='PrevEvents'
startRow='#StartRow_PrevEvents#' maxRows='#MaxRows_PrevEvents#' >
<tr> <td
width='20' height='15'>#PrevEvents.Date##PrevEvents.Title#</td>
<td width='125' height='15'>&amp;nbsp;</td>
<td width='10' height='15'><img
src='/Images/bulletpurple.png' name='l1' width='10' height='10' id='l1' /></td>
</tr>
</cfoutput> </cfoutput>

[cgsj_usa@yahoo.com]

Try this:

<cfquery...

...</cfquery>

<cfoutput query = "queryname" startrow = "1" endrow = "5">
whatever the columns are
</cfoutput>

<cfset startrow_prevevents = "6" />
<cfset maxrows_prevevents = "10" />

<cfoutput query="PrevEvents" startRow="#StartRow_PrevEvents#"
maxRows="#MaxRows_PrevEvents#" >
<tr>
<td width="20" height="15">#PrevEvents.Date##PrevEvents.Title#</td>
<td width="125" height="15"> </td>
<td width="10" height="15"><img src="/Images/bulletpurple.png" name="l1"
width="10" height="10" id="l1" /></td>
</tr>
</cfoutput>

Hope that this helps. Thanks.

Chris