Try this and see if it works for you.
<cfset setlocale("Portuguese (Brazilian)")>
<table>
<tr>
<th><a href = "#query.Weblink#"><strong>#query.id# -
#query.myName#</strong></a></th>
</tr>
<tr>
<td>
<table width="100%" border="0" cellpadding="1" cellspacing="1">
<tr bgcolor="003399">
<td>Month 1</td>
<td>Month 2</td>
<td>Month 3</td>
</tr>
</table>
</td>
</tr>
<cfset groupcount = 0>
<cfoutput query="query" group="id">
<cfset groupcount = groupcount + 1>
<tr>
<td colspan="3">Course 1 ID, Name</td>
</tr>
<tr>
<cfoutput>
<td>
<p><cfif month(query.myDate) EQ
month(now())>#DateFormat(query.myDate, 'dd')#<cfif #dateformat(dateadd("d",
query.Days-1, query.myDate), "dd")# EQ #dateformat(query.myDate,
"dd")#><cfelse>-#dateformat(dateadd("d",
query.Days-1, query.myDate), "dd")#</cfif> /
#query.Location#</cfif></p>
</td>
</cfoutput>
</tr>
<cfif groupcount mod 10 EQ 0>
<tr>
<td>
<table width="100%" border="0" cellpadding="1"
cellspacing="1">
<tr bgcolor="003399">
<td>Month 1</td>
<td>Month 2</td>
<td>Month 3</td>
</tr>
</table>
</td>
</tr>
</cfif>
</table>
--
William E. Seiter
Have you ever read a book that changed your life?
Go to: www.winninginthemargins.com
Enter passkey: goldengrove
Web Developer / ColdFusion Programmer
http://William.Seiter.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3376
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
