Bud from Topica sent this in last week. http://www.twcreations.com/recordcount/
I found using CFOUTPUT with the "Group" attribute to populate a custom structure works very well for this but THAT code isn't the pretty kind :-) > 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 > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
