Sorry to bump this one up again, but I wanted to see if anyone had any
post-Christmas thoughts on this one.
Thanks!
Jake
> I'm with you, and that's basically what I'm doing. I do a query, group
> in the "Group" items shown below. Not a problem there. It's getting
> the data to a) break in the right spot (only breaking between groups,
> not in the middle of a single group), and b) to get the ordering right.
>
>
> For example... this is the right way, what I'm trying to do:
>
> Group 1
> - Item 1a
> - Item 2a
> - Item 3a
> Group 2
> - Item 1b
> === next page ===
> Group 3
> - Item 1c
> - Item 2c
> Group 4
> - Item 1d
> - Item 2d
>
> But I end up getting weird things like:
>
> Group 1
> - Item 1a
> - Item 2a
> Group 4
> - Item 1d
> - Item 2d
> Group 2
> - Item 1b
> - Item 2c
> === next page ===
> Group 3
> - Item 3a
> - Item 1c
>
> This is using the grouped query approach:
>
> <CFOUTPUT query="myQueryName" group="mygroupfield">
> #Title#
> <CFOUTPUT group="someotherfield">
> #Entry#
> </CFOUTPUT>
> </CFOUTPUT>
>
> Does that makes sense?
>
> Thanks!
> Jake
>
>
> > I think I would try breaking on the Group. If you can, determine
> >the number of groups you have and treat each group as if it were its
> own
> >record. Then you can page by each group, with a set number of groups
> on
> >each page.
> > I'd guess you could select distinct on the column that Group
> derives
> >from, then use that number to determine the number of pages you would
> have.
> > Does this make any sense?
> >
> >- Matt Small
> >
> >
> >-----Original Message-----
> >From: Jake [mailto:[EMAIL PROTECTED]
> >Sent: Friday, December 17, 2004 9:23 AM
> >To: CF-Talk
> >Subject: Suggestions for grouped query and next/previous paging
> >
> >All,
> >
> >I'm outputting a grouped query:
> >
> >Group 1
> >- Item 1a
> >- Item 2a
> >- Item 3a
> >Group 2
> >- Item 1b
> >Group 3
> >- Item 1c
> >- Item 2c
> >
> >and so on...
> >
> >but the query results in a large number of records, so I want to add
> >next/previous paging.
> >
> >The grouping I have no trouble setting up, but how to I break the
> results
> >up? If you add the standard next/previous
> >to the grouped query, it tends to break up in really odd ways.
> >
> >Thanks!
>Jake
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189112
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
