>I'm trying to group people by state, with two columns of names under each >state heading. This works, other than some states don't always fill the >second top column in the group. Some rows display correctly, and others >don't. I have some states with 3 names that work correctly. > >I get >STATE >name1 name2 >STATE >name1 >name2 name3 >etc. > >How can I force the 2nd column to fill from the top of the group.
I'm not sure if this will help or not, but you can check out my cf_recordcount tag. http://www.twcreations.com/recordcount/ It's designed to be able to return the top X number of records or X number of records per page based on any group out of a joined query. -- Bud Schneehagen - Tropical Web Creations, Inc. _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Web Based Solutions / eCommerce Development & Hosting http://www.twcreations.com/ - http://www.cf-ezcart.com/ 954.721.3452 - Toll Free: 877.207.6397 - Fax: 954.721.7493 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm