Index: openacs-4/packages/lars-blogger/tcl/rss-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/rss-procs-oracle.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/lars-blogger/tcl/rss-procs-oracle.xql 28 Sep 2003 16:24:52 -0000 1.4
+++ openacs-4/packages/lars-blogger/tcl/rss-procs-oracle.xql 11 Dec 2003 21:40:05 -0000 1.5
@@ -13,51 +13,41 @@
select *
from (select entry_id,
- title,
- content,
- entry_date,
- posted_date,
- to_char(posted_date, 'YYYY-MM-DD') as posted_date_string,
- to_char(posted_date, 'HH:MI') as posted_time_string,
- to_char(posted_date, 'YYYY-MM-DD HH24:MI:SS') as posted_time_ansi,
- -6 as tzoffset_hour,
- 0 as tzoffset_minute,
- to_char(entry_date, 'DD Mon YYYY hh12:MI am') as entry_date_pretty,
- to_char(entry_date, 'YYYY/MM/') as entry_archive_url
- from pinds_blog_entries
- where package_id = :package_id
- and draft_p = 'f'
- and deleted_p = 'f'
- order by entry_date desc, posted_date desc)
+ e.title,
+ e.content,
+ to_char(e.posted_date, 'YYYY-MM-DD HH24:MI:SS') as posted_time_ansi,
+ c.name as category
+ from pinds_blog_entries e,
+ pinds_blog_categories c
+ where e.package_id = :package_id
+ and e.draft_p = 'f'
+ and e.deleted_p = 'f'
+ and c.category_id = e.category_id (+)
+ order by e.entry_date desc, e.posted_date desc)
where rownum < 11
select *
- from (select entry_id,
- title,
- content,
- entry_date,
- posted_date,
- to_char(posted_date, 'YYYY-MM-DD') as posted_date_string,
- to_char(posted_date, 'HH:MI') as posted_time_string,
- to_char(posted_date, 'YYYY-MM-DD HH24:MI:SS') as posted_time_ansi,
- -6 as tzoffset_hour,
- 0 as tzoffset_minute,
- to_char(entry_date, 'DD Mon YYYY hh12:MI am') as entry_date_pretty,
- to_char(entry_date, 'YYYY/MM/') as entry_archive_url
+ from (select e.entry_id,
+ e.title,
+ e.content,
+ to_char(e.posted_date, 'YYYY-MM-DD HH24:MI:SS') as posted_time_ansi,
+ c.name as category
from pinds_blog_entries e,
acs_objects o,
- users u
- where e.package_id = :package_id
- and o.object_id = e.entry_id
- and o.creation_user = :user_id
- and u.user_id = o.creation_user
- and e.draft_p = 'f'
- and e.deleted_p = 'f'
- order by e.entry_date desc, e.posted_date desc)
+ users u,
+ pinds_blog_categories c
+ where e.package_id = :package_id
+ and o.object_id = e.entry_id
+ and o.creation_user = :user_id
+ and u.user_id = o.creation_user
+ and e.draft_p = 'f'
+ and e.deleted_p = 'f'
+ and c.category_id = e.category_id (+)
+ order by e.entry_date desc, e.posted_date desc)
where rownum < 11