>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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243413 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
