Hey Guy,
This is what I came up with:
<cfquery name="queryName" datasource="datasourceName">
SELECT c.categoryName, s.subCategoryName
FROM tblCategory c, tblSubCategory s
WHERE c.categoryid = s.categoryid
ORDER BY c.categoryName
</cfquery>
<cfset categoryCount=1>
<table>
<tr>
<cfoutput query="queryName" group="categoryName">
<cfif not categoryCount mod 4></tr><tr></cfif>
<td valign="top">
<b>#queryName.categoryName#</b><br>
<cfset subCategoryCount=1>
<cfoutput>
<cfif subCategoryCount lte 3>
#queryName.subCategoryName#<br>
<cfelseif subCategoryCount eq 4>
More...
</cfif>
<cfset
subCategoryCount=subCategoryCount+1>
</cfoutput>
</td>
<cfset categoryCount=categoryCount+1>
</cfoutput>
</tr>
</table>
There may be a more efficient way of doing what you proposed, but this
gets the job done.
Best,
Nathan
> -----Original Message-----
> From: Guy McDowell [mailto:[EMAIL PROTECTED]]
> Sent: Friday, February 21, 2003 11:26 AM
> To: CF-Talk
> Subject: Re: 3 Cells Wide
>
>
> Hi Dave (and everyone else),
>
> I've got the grouping and ordering down, it's the formatting
> of the output that's the challenge. The trick is to get my
> HTML table only 3 cols wide and then only have the first 3
> results of the query on the Subcategory table displayed under
> the appropriate Category heading.
>
> I have a straight HTML version on the index of my site to
> illustrate where I am trying to go with this. It's at
> http://www.guymcdowell.com
>
> TIA,
>
>
>
> Truly,
>
> Guy J. McDowell, M.M.C.P.
> (705) 324-9144 ex 3422
> [EMAIL PROTECTED]
> ~~~~~~~~~~~~~~~~~~~~
> Sir Sandford Fleming College
> Frost Campus
> P.O. Box 8000
> Lindsay, Ontario
> K9V 5E6
>
>
> >>> [EMAIL PROTECTED] 02/21/03 10:33am >>>
> >This is a borderline newbie question. Perhaps we should have a
> >CF-Brainfart list. Anyway....
> >
> >Challenge: To have out put from two tables put into a three column
> >wide, n-rows deep HTML table a la Yahoo! Each column's formatted
> output
> >would look something like this:
> >
> >Category Name
> >
> >Subcategory Name 1, Subcategory Name 2, Subcategory Name 3, more...
> >
> >Given: CF 5, MS Access 2000, tblCategory, tblSubcategory, one rusty
> CF
> >developer.
> >
> >I'm pretty sure this is a job for query-a-query and loop list while
> >n<=3 type logic, but I just can't get it to jive. Help?
>
> Nah. Look into the "group" attribute of the <cfoutput
> query...> tag. Just
> group your query results by the category name and you should
> be good to go.
> The key is the ORDER BY clause in your SQL statement. You
> want to make sure
> you order by the category name so that CF can properly group the data.
>
> Here's a brief sample:
>
> <cfquery name="queryName" datasource="myDSN">
> SELECT c.categoryName,
> s.subcategory
> FROM tblCategory c, tblSubcategory s
> WHERE c.categoryid = s.categoryid
> ORDER BY c.categoryName
> </cfquery>
>
> Then in your output, you'd do something like:
>
> <cfoutput query="queryName" group="categoryid">
> #queryName.categoryName#<br/>
> <cfoutput>#queryName.subcategory#</cfoutput>
> </cfoutput>
>
> The nested <cfoutput> is necessary because you need to "tell" CF which
>
> fields to group.
>
> Something like that should take care of your issue. Haven't
> tested that
>
> code, but it looks Kosher.
>
> Regards,
> Dave.
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
