RE: Grouping

[Dave Cahall]

Add numCategoryID to your Order By clause -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of April Young Sent: Monday, April 22, 2002 5:55 PM To: [EMAIL PROTECTED] Subject: Grouping 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>