Sorry, I was on the phone for a bit:
SELECT
r.cb_id,
r.cb_dCreated,
r.cb_dModified,
r.cb_content,
r.cb_isArchive,
(
SELECT
COUNT( * )
FROM
clubroom_images i
WHERE
i.cb_id = r.cb_id
) AS image_count
FROM
clubroom r
ORDER BY
r.cb_dCreated DESC
.......................
Ben Nadel
www.bennadel.com
Certified Advanced ColdFusion Developer
Need Help?
www.bennadel.com/ask-ben/
-----Original Message-----
From: Mike Little [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 30, 2006 6:39 PM
To: CF-Talk
Subject: Re: GROUP BY error
hmmm...
now i cannot get at my getArticles.image_count variable ??
> sort of like this?
>
> SELECT clubroom.cb_id, clubroom.cb_dCreated, clubroom.cb_dModified,
> clubroom.cb_content, clubroom.cb_isArchive, (
> SELECT COUNT(cbi_id) AS image_count
> FROM clubroom_images
> )
> FROM clubroom LEFT OUTER JOIN clubroom_images ON clubroom.cb_id =
> clubroom_images.cb_id ORDER BY clubroom.cb_dCreated DESC
>
> thanks for the prompt response.
>
> Mike
:o)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251558
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
