You just need to build your own counter to close the div. <cfoutput query="myquery" group="mygroup"> <cfset counter = 0> blah blah <div> <cfoutput> title <cfset counter = counter + 1> <cfif counter EQ 10> </div> <div> </cfif> </cfoutput>
On 9/27/05, Saturday (Stuart Kidd) <[EMAIL PROTECTED]> wrote: > > Mike, > > I've tried various ways, like having a cfloop within the simple > <cfoutput> - but no luck. > > The code is: > > <p> > <cfoutput query="GetAuthors" group="authorID"> > Name: #authorFirstName# #authorSurname#<br /> > <p>About Me:#ParagraphFormat(authorAboutMe)#</p> > <p>Articles:<br /> > <cfoutput>#articleTitle#<br /></cfoutput></p> > </cfoutput> > </p> > > What i'm trying to do is split up the article title so that i can > more or less create two divs for my html one that will have articles > 1-10 and then another which will have 11-20. > > Thanks, > > Saturday > > > On 27 Sep 2005, at 20:23, Dawson, Michael wrote: > > > 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:219372 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
