> > ><cfoutput query="getorders"> > <cfinclude template="cart_items.cfm"> > <cfloop query="cartquery"> > <cfset NewRow = QueryAddRow(products)> > <cfset Temp = QuerySetCell(products, "qty", #cartquery.qty#)> > <cfset Temp = QuerySetCell(products, "owner", >#cartquery.owner#)> > <cfset Temp = QuerySetCell(products, "code", >#cartquery.qty#)> > <cfset Temp = QuerySetCell(products, "description", >"#cartquery.desc#"> > <cfset Temp = QuerySetCell(products, "price", >#cartquery.price#)> > </cfloop> > </cfoutput> > <cfoutput query="products"> > <cfquery name="final" dbtype="query"> > select SUM(qty) AS quantity, owner, description, price > from products > group by owner, description, price > order by qty desc > </cfquery> > <cfoutput query="final" group="owner"> > (#quantity#) | #owner# | #description#<hr> > </cfoutput> >
a couple of things with QoQ's, one: you must select the value to order by with it, two: your query above try order by sum(qty) or order by quantity three: sigh, QoQ's have problems sorting by fields values that are created by querysetcell I have found z ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
