I think in this situation you have to manually display the rows you want. As a query can be addressed like this:
QSomeQuery["SomeColumnName"][1] QSomeQuery["SomeColumnName"][2] etc, you can loop through the query, display a row if the grouped column's value changes and record where you are in the query and the number of rows you've displayed so far. On 6/14/06, Auke van Leeuwen <[EMAIL PROTECTED]> wrote: > >I'm trying to output a grouped query using a startrow and maxrows. > >Something like this: > > > ><table> > ><cfoutput query="myQuery" startrow="#StartRow#" maxrows="10" group="Foo"> > > <tr> > > <td>#myQuery.Foo#</td> > > <td> > > <cfoutput> > > #myQuery.Bar# > ></cfoutput> > > </td> > ></tr> > ></cfoutput> > ></table> > > I haven't tested this (don't have the time right now), but you may have to > put the maxrows attribute in the inner <cfoutput /> while maintaining the > startrow attribute at the outer <cfoutput /> loop. > > Hmm thinking about that some more: that wouldn't really work well as it would > probably give you a maximum of 10 rows for every 'group'. Starting at row '5' > while specifying startrow="11" doesn't make much sense either way I guess. -- CFAJAX docs and other useful articles: http://jr-holmes.coldfusionjournal.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243420 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
