issues and 1000 articles, you have to retreive 1000 records to show 10
articles. The Order by clause would have to be
WHERE articleIssueID, articleDate DESC
I can't see how the second solution would help.
Pascal
> -----Original Message-----
> From: Terry Troxel [mailto:[EMAIL PROTECTED]
> Sent: maandag 29 maart 2004 16:37
> To: CF-Talk
> Subject: Re: SQL grouped query help
>
> <CFQUERY name="blah">
> SELECT articleTitle, articleDate, articleIssueID
> FROM myArticles
> ORDER BY articleIssueID DESC
> </CFQUERY>
> <cfoutput query="getarticle" group="articleissueID">
> <<<<I think this might work for you.>>> </cfoutput>
>
> Terry
>
> OR do a select max(articleissueID) query and then run a query
> for ONLY that issue.
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
