Well I have basically got the same. The problem I'm having can be shown below:
Harry Potter 1292BB85 $65 Cash 135CC94A $65 Cash Totals $130.00$130.00 Ben Forta 1292BB85 $65 Cash 135CC94A $65 Cash 135CC96B $65 Cash Totals $195.00$195.00$195.00 Basically its displaying the total as many times are there are records. Just trying to determine if there is a simple way to limit the displaying of the total to just once. If there is then the problem is fixed. Thanks in advance >> Hoe do you include a count after the books and before the next author >> name. > >Do you mean something like this? > ><cfoutput query="getAuthorsAndBooks" group="authorname"> > <b>#authorName#</b> > <cfset bookCount = 0 > > <ul> > <cfoutput> > <li>#bookTitle#</li> > <cfset bookCount = bookCount + 1> > </cfoutput> > </ul> > total books for this author (#bookCount#) <br> ></cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292994 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4