You have specified two <CFOUTPUT GROUP=""> blocks. In addition, you need to specify a simple <CFOUTPUT> block to continue the looping.
You can have as many nested CFOUTPUT GROUPs, however, you usualy always need the simple CFOUTPUT to get the "details". M!ke -----Original Message----- From: Saturday (Stuart Kidd) [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 27, 2005 1:31 PM To: CF-Talk Subject: Splitting cfoutput of grouped query I'm having some trouble trying to split a query. <cfquery name="GetAuthors" datasource="user020"> SELECT tbl_020authorDetails.authorID, authorPhotograph, authorFirstName, authorSurname, authorAboutMe, tbl_020articleDetails.articleID, tbl_020articleDetails.authorID, articleTitle FROM tbl_020authorDetails, tbl_020articleDetails WHERE authorPhotograph <> ' ' AND tbl_020articleDetails.authorID = tbl_020authorDetails.authorID ORDER BY tbl_020authorDetails.authorID </cfquery> <p> <cfoutput query="GetAuthors" group="authorID"> Name: #authorFirstName# #authorSurname#<br /> <p>About Me:#ParagraphFormat(authorAboutMe)#</p> <p>Articles:<br /> <cfoutput group="articleTitle">#articleTitle#<br /></cfoutput></p> </cfoutput> </p> What i'd like to do is have something like below and repeated for each author: AuthorFirstName AuthorSurname AboutMe text here. <div> List of articles 1 - 6 </div> <div> List of articles 7-12 </div> I've tried a cfloop but that didn't seem to work. Any help i would be truly grateful. Thanks, Saturday ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219361 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
