[thelist] CF - multiple groups, and SQL too perhaps

chris,


>   Are you sure you can't nest multiple groups?  I thought you could.

seems you are right! i must've been confused by the error message regarding
outer <cfoutput>'s and the query attribute, and given up too soon with the
obvious method.

using this order by in my SQL:

	order by locationname, auctiontitle, reviewdate DESC;

and this further down:

	<h3>list all reviews</h3>

	<ul><cfoutput query=getreviews group=locationname>
	<li><b>#locationname#</b></li>

	<ul><cfoutput group=auctiontitle>
	<li>#auctiontitle#</li>

	<ul><cfoutput><li><a
href="reviewdetails.cfm?reviewid=#reviewid#">#reviewtitle#</a> 	(by <cfif not
len("#reviewnameoverride#")>#memberfirstname# #memberlastname#<cfelse>
#reviewnameoverride#</cfif> on #dateformat("#reviewdate#","dd/mm/yyyy")#)</li>

	</cfoutput></ul></cfoutput></ul></cfoutput></ul>


i got it to work...


thanks for pointing out my mistake :)


isaac