IIRC, you need the query name in the inner CFOUTPUT, but I could be wrong about that. It's been a while since I've done this.
--Ben Saturday (Stuart Kidd) 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:219371 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
