|
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> </td></tr> </TABLE> |
- RE: Grouping April Young
- RE: Grouping Dave Cahall
