Re: Suggestions for grouped query and next/previous paging
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: > > > #Title# > > #Entry# > > > > 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
Re: Suggestions for grouped query and next/previous paging
http://www.twcreations.com/recordcount/ > 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 - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188756 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Suggestions for grouped query and next/previous paging
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: #Title# #Entry# 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 Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188739 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Suggestions for grouped query and next/previous paging
Hi 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 - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:187999 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
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:187993 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54