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>
When startrow is 1, the output is as expected and I see 10 rows in the
table that correspond to the first ten rows (grouped) from my query.
When startrow is 11, the first row I see is what I would label row 5.
It seems that this is because ColdFusion is determining the startrow
before grouping is applied. The calculation of output for maxrows,
however, seems to be determined after grouping is applied. Is this a
correct evaluation of what's happening? Maybe I'm missing something.
I'm running CFMX 6.1.
I hope this makes sense. Basically what I want to do is output a
grouped query and use the startrow and maxrows attributes as they
would apply to the query after it has been grouped.
Thanks.
Chris
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:243399
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
