Group and CurrentRow MOD

[Al]

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.

<cfoutput query="Pull_All_Members" group="State">
   <tr valign="top">
      <td  colspan="2" valign="top"><strong>#RTrim(state)#</strong></td>
   </tr>
   <cfoutput>
      <cfif Pull_All_Members.CurrentRow MOD 2 IS 1>
         <tr valign="top">
         <cfset trOpen=true>
      </cfif>
      <td valign="top">#Lastname#</td>
       <cfif Pull_All_Members.CurrentRow MOD 2 IS 0>
         </tr>
         <cfset trOpen=false>
      </cfif>
   </cfoutput>
   <cfif trOpen>
      </tr>
   </cfif>
</cfoutput>
</table>

Thanks,
Al


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com