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:219365
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
