probably not, but is this what you mean??
<cfquery name="places" datasource="lawyers"
select place from tbl_lawyers
order by place
</cfquery>
<cfparam name="thisplace" default="">
<table border="0" cellpadding="0" cellspacing="0" width="50%">
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<cfoutput query="places" group="place">
<cfquery name="lawyers" datasource="lawyers"
select * from tbl_lawyers where place = '#place#' order by place, name
</cfquery>
<cfset firstcolumn = round(lawyers.recordcount / 2)>
<cfset secondcolumn = round(lawyers.recordcount - firstcolumn)>
<tr>
<td style="text-decoration:underline; font-weight:bold;"
align="left"><br><br>#place# 1st:#firstcolumn# 2nd: #secondcolumn#</td>
</tr>
<tr>
<td width="100%">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td>
<cfloop query="lawyers">
<a href="">#name#</a><br>
<cfif currentrow is firstcolumn>
</td><td>
</cfif>
</cfloop>
</td>
</tr>
</table>
</td>
</tr>
<cfset thisplace = place>
</cfoutput>
</table>
</td>
</tr>
</table>
----- Original Message -----
From: "Ian Lurie" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, January 21, 2003 6:10 PM
Subject: Re: Columns and grouping issue
> OK, I've figured out at least part of the problem - the MAXROWS
> attribute needs to count out the number of GROUPs, not the number of
> records.
>
> But I actually want to split the largest group (Seattle) into two
> sub-groups, distributed between the two columns.
>
> Any suggestions? Aside from hard-coding?
>
> Ian
>
> On Tuesday, January 21, 2003, at 02:56 PM, Jerry Johnson wrote:
>
> > You've got the code right, but you are doing the WHOLE set in the
> > first list, and only the second half in the second list.
> >
> > (I say the code is right cause the right side is perfectly half of the
> > left side)
> >
> > Jerry Johnson
> >
> >>>> [EMAIL PROTECTED] 01/21/03 05:52PM >>>
> > I'm trying to get two even columns on a page, where the records are
> > grouped, like this:
> >
> > Seattle Tacoma
> > 1 5
> > 2 6
> > 3 7
> > 4
> > 5 Portland
> > 1
> > Tacoma 2
> > 1 3
> > 2 4
> > 3
> > 4
> >
> > But instead, I'm getting this:
> >
> > Seattle Tacoma
> > 1 1
> > 2 2
> > 3 3
> > 4 4
> > 5 5
> > 6
> > Tacoma 7
> > 1
> > 2 Portland
> > 3 1
> > 4 2
> > 5 3
> > 6 4
> > 7
> >
> > Any idea how I get this to balance out? The link is:
> >
> > http://www.wkg.com/index.cfm/action/section/nodeid/712.htm
> >
> > Thanks,
> >
> > Ian
> >
> >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
