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,
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:3312
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
