Cfquery to html table with 3 columns

Newbie here --
I have seen how to display 3 output fields into and html table. However, I am wishing to display a single output field into an html table that is multiple columns wide (ex. 3) having dynamic rows depending on the number of fields returned. To site a simple example, an access table contains a record for each month of the year and a date on which the monthly meeting occurred....I would like to display across a 3column table each of those dates,
January 23 Februrary 14 March 14
April 22 May 16 etc.....
Thanks in advance

Well, I'm assuming that your query can result in more than 3 row, so then you will have multiple rows of 3.

try this:

Thanks ebot - have created following code from your suggestion and i get error indicating mdate is not defined, yet a previous page executes properly...cannot see my error..
code modified per your suggestion:
<cfquery name="getBoardMeetings" datasource="glenmore">
SELECT *
FROM GCAtblBoardMeetings
WHERE mdate < Now()
ORDER BY mdate DESC
</cfquery>

<cfmodule template="../templates/headStart.cfm" title="Board Meeting Minutes">

<cfmodule template="../templates/headStop.cfm" title="Board Meeting Minutes" menuid="4">

</cfoutput>
<cfloop from="1" index="i" to="#getBoardMeetings.recordcount#" step="3">
<cfoutput>
#dateFormat(mdate[i],'mmmm d, yyyy')#
<cfset i=i+1>
#dateFormat(mdate[i],'mmmm d, yyyy')#
<cfset i=i+1>
#dateFormat(mdate[i],'mmmm d, yyyy')#
</cfoutput>
<br />
</cfloop>


<cfmodule template="../templates/foot.cfm">
(the templates display properly)
code that is working:
<cfquery name="getBoardMeetings" datasource="glenmore">
SELECT *
FROM GCAtblBoardMeetings
WHERE mdate < Now()
ORDER BY mdate DESC
</cfquery>

<cfmodule template="../templates/headStart.cfm" title="Board Meeting Minutes">

<cfmodule template="../templates/headStop.cfm" title="Board Meeting Minutes" menuid="4">

<ul>
<cfloop query="getBoardMeetings">
<cfoutput>
<li>
<cfif #minutes# NEQ "not posted">
<a href="minutes/#minutes#">#dateFormat(mdate,'mmmm d, yyyy')#</a>
<cfelse>
#dateFormat(mdate,'mmmm d, yyyy')# - Not Yet Available
</cfif>
<cfif #trim(notes)# NEQ "">
<br /><em>#notes#</em>
</cfif>
<br /><br />
</li>
</cfoutput>
</cfloop>
</ul>


<cfmodule template="../templates/foot.cfm">
\\appreciate your help....bob

There is no mdate defined in the variables scope. You need to prefix anything related to the query with the name of the query:


<cfloop from="1" index="i" to="#getBoardMeetings.recordcount#" step="3">
<cfoutput>
#dateFormat(getBoardMeetings.mdate[i],'mmmm d, yyyy')#
<cfset i=i+1>
#dateFormat(getBoardMeetings.mdate[i],'mmmm d, yyyy')#
<cfset i=i+1>
#dateFormat(getBoardMeetings.mdate[i],'mmmm d, yyyy')#
</cfoutput>
<br />
</cfloop>

Kiteless,
Thanks so much...worked like a charm....is it possible for you to point me in the right direction to understand how to establish the variable scope you mention? Thanks in advance ..
Kudos,
Bob

The variables scope is the default ColdFusion scope. You don't have to do anything to create it; like all ColdFusion scopes it is created by the CF engine.

So you can do:

<cfset you = "Bob" />
<cfset variables.me = "Brian" />
<cfset variables['kook'] = "Kim Jong Il" />
<cfdump var="#variables#" />

And see that all three are in the variables scope.

Thanks kite - appreciate your help.