little coding prob...

ok, this here is my code:



usually this would output my query results in 3 columns, but apparantly the grouping is throwing this off, it comes out in this hideous mass of cells all over the place.

anyone know how to fix this????

thanks!

later

I'm not sure what format you're trying for? Do you want 3 table columns? Like this?

<tr>
<td>category1<td>
<td>field1<td>
<td>field2<td>
</tr>

Keep in mind that to use the "group" attribute you must be ordering your query by that column as well.

no, like this:

<tr>
<td>
category1

field1, field2
</td>

<td>
category2

field1, field2
</td>

<td>
category3

field1, field2
</td>
</tr>

<tr>
<td>
category4

field1, field2
</td>

<td>
category5

field1, field2
</td>

<td>
category6

field1, field2
</td>
</tr>

thanks!

Well then, as long as your query is ordered by category, you should be able to do it like this:

<table>
<cfoutput query="myquery" group="category">
<tr>
<td>
#myQuery.category#
<cfoutput>
#field1# #field2#
</cfoutput>
</td>
</tr>
</cfoutput>
</table>

Basically everything inside the outer cfoutput block, but not inside the inner cfoutput block, will only execute once for each category. But the code in the inner cfouput block will execute for each data row present for each category.

ok, maybe a visual aid will help...

i don't want my table like this:


but like this:


does this help??

thanks again!!

later