> The following query returns a recorderdset of 'forums' and 'lastpost'
> being the last record the highest date, which is the only record I
> really need.
> Is there a way of getting just "that" las record?
> Thanks for helping.
>
> <cfquery name="qGetLastPost" datasource="schoolsforums">
> select max(sf_messages.posted) as lastpost,
> sf_messages.title,
> sf_users.username,
> sf_forums.id as forumid,
Select top 1?
> sf_threads.id as threadid
> from (((sf_messages
> left join sf_threads on sf_messages.threadidfk = sf_threads.id)
> left join sf_forums on sf_threads.forumidfk = sf_forums.id)
> left join sf_users on sf_messages.useridfk = sf_users.id)
> where sf_forums.id = 'CD4DBE82-874D-9864-ABB204DC22EC3285'
> group by sf_messages.posted
> </cfquery>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3315
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
