CFOUTPUT with Group attribute <back><next>navigation

[Ad Bec]

I have relational database system and when the query is run, i get 300 rows but
only 5 should be displayed as I group by ListingID. I would like to create a
back next navigation with 10 per page but only the first 5 are displayed in the
output.
<cfoutput query="#attributes.QueryName#" group="NewsID"
StartRow="#url.StartRow#" maxrows="#EndRow#">

</cfoutput >

Is there an example that shows an efficient way to do this?

Thanks!

[Dan Bracuk]

You almost have it. You have to cache your query, which you may have already
known. Also, instead of maxrows=#endrow#, just state the number of rows.

Speaking of which, you want 10 rows per page of which 5 are displayed? That
doesn't make sense.

[Rick]

I like to use a custom tag for this this one makes it very easy.

[url]http://www.johnstons.org/wdc/pub/cfusion/customtags/CF_PageThru/CF_PageThru.html[/url]


"Ad Bec" <webforumsuser@macromedia.com> wrote in message
news:dhi4di$cja$1@forums.macromedia.com...

>I have relational database system and when the query is run, i get 300 rows
>but
> only 5 should be displayed as I group by ListingID. I would like to create
> a
> back next navigation with 10 per page but only the first 5 are displayed
> in the
> output.
> <cfoutput query="#attributes.QueryName#" group="NewsID"
> StartRow="#url.StartRow#" maxrows="#EndRow#">
>
> </cfoutput >
>
> Is there an example that shows an efficient way to do this?
>
> Thanks!
>