Index: openacs-4/packages/sloan-bboard/www/forum-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/sloan-bboard/www/forum-oracle.xql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/sloan-bboard/www/forum-oracle.xql 18 Feb 2002 13:21:06 -0000 1.2 +++ openacs-4/packages/sloan-bboard/www/forum-oracle.xql 25 Feb 2002 13:29:56 -0000 1.3 @@ -23,7 +23,8 @@ select message_id, title, num_replies, first_names||' '||last_name as full_name, - to_char(last_reply_date,'MM/DD/YY hh12:Mi am') as last_updated + to_char(last_reply_date,'MM/DD/YY hh12:Mi am') as last_updated, + bboard_message.new_p(message_id, :user_id) as new_p from bboard_messages_all b, persons where forum_id = :forum_id and sent_date > case when :last_n_days = 0 then '1976-01-01' else to_char(sysdate - :last_n_days) end