You'll have to keep track of the current record yourself something like....
<CFSET IHaveOutput = 0>
<CFOUTPUT QUERY="Q_MyQuery" STARTROW="#StartRow#" GROUP="MyGroup">
<CFIF IHaveOutput LT MaxRecords>
>> <CFOUTPUT>
>> <CFIF IHaveOutput LT MaxRecords>
>> <CFSET IHaveOutput = IHaveOutput + 1>
>> #BlahBlahBlah#
>> </CFIF>
>> </CFOUTPUT>
</CFIF>
</CFOUTPUT>
note that IHaveOutput is checked against MaxRecords in two places, because
we are outputting in two groups...
At 04:02 PM 10/26/2001, you wrote:
>I've got a list of events I'm pulling from a db and looping over them
>to first sort by month - then the inner list sorts by date. Since this
>is a long list I'd like to break it up in a prev/next list but ran
>into a roadblock when I discovered maxrows was only affecting the
>group, not the entire list.
>
>Any workaround for this?
>
><cfoutput query="eventList" group="theMonth" startrow=#startrows#
>maxrows=#maxrows#>
> <cfoutput group="detail">
> event info
> </cfoutput>
></cfoutput>
>
>Thanks,
>jim
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
