Hi guys,
I'm trying to work out how to order my query by the amount of articles.
<cfquery name="GetAuthors" datasource="user020">
SELECT tbl_020authorDetails.authorID,
authorPhotograph, authorFirstName, authorSurname, authorAboutMe,
tbl_020articleDetails.articleID, tbl_020articleDetails.authorID,
articleTitle, articleDatePublishedLast
FROM tbl_020authorDetails, tbl_020articleDetails
WHERE authorPhotograph <> ' ' AND
tbl_020articleDetails.authorID = tbl_020authorDetails.authorID AND
tbl_020articleDetails.articleAuthenticated = 1 AND
tbl_020articleDetails.articleSubTypeID <> 55 AND
tbl_020articleDetails.articleSubTypeID <> 68
ORDER BY tbl_020authorDetails.authorFirstName,
articleDatePublishedLast DESC
</cfquery>
How do I count how many articles there are, ie something like ORDER
BY tbl_020articleDetails.articleID(Count as) or something?
Thanks for any help,
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:219505
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
