I cannot get the following information to group properly.  Is there something I am not seeing?
 
Here is the query:
 
Select tblTestimonialCategories.*, tblTestimonials.* from
  tblTestimonials left outer join tblTestimonialCategories on
  tblTestimonials.numCategoryID=tblTestimonialCategories.autTestimonialCatID
order by intorder
 
 
Here is the table:
 
<CFSET NumberOfColumns = 2>
<TABLE cellpadding="8" width="720" bgcolor="white"   style="font-family: Arial, Helvetica, sans-serif; font-size: 12px;">
<TR>
<CFOUTPUT query="qTestimonials" group="numCategoryID">
<CFIF (CurrentRow MOD NumberOfColumns) IS 1>
</TR><TR>
</CFIF>
<TD valign="top" align="center">
<b><font size="3">#txtCategoryName#</font></b><br>
<cfoutput>
<a href="testimonials.cfm?ID=#autTestimonialID#">#txtCompanyName#</a><br>
</cfoutput>
</td>
</CFOUTPUT>
</TR>
<tr><td><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>&nbsp;</td></tr>
</TABLE>

Reply via email to