That works fantastically, thanks Deanna! :) Saturday
On 27 Sep 2005, at 21:42, Deanna Schneider wrote: > 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 >>> >>> >>> >>> >>> >>> >>> >>> >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219384 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
