Index: openacs-4/packages/lars-blogger/tcl/blogger-api-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/blogger-api-procs-oracle.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/lars-blogger/tcl/blogger-api-procs-oracle.xql 14 Dec 2003 11:10:44 -0000 1.2 +++ openacs-4/packages/lars-blogger/tcl/blogger-api-procs-oracle.xql 14 Dec 2003 12:34:25 -0000 1.3 @@ -7,8 +7,8 @@ select * from (select entry_id, - to_char(entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi - content, + to_char(entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi, + content from pinds_blog_entries and package_id = :package_id and draft_p = 'f' Index: openacs-4/packages/lars-blogger/tcl/blogger-api-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/blogger-api-procs-postgresql.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/lars-blogger/tcl/blogger-api-procs-postgresql.xql 14 Dec 2003 11:10:44 -0000 1.2 +++ openacs-4/packages/lars-blogger/tcl/blogger-api-procs-postgresql.xql 14 Dec 2003 12:34:25 -0000 1.3 @@ -6,8 +6,8 @@ select entry_id, - to_char(entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi - content, + to_char(entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi, + content from pinds_blog_entries where package_id = :package_id and draft_p = 'f' Index: openacs-4/packages/lars-blogger/tcl/metaweblog-api-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/metaweblog-api-procs-oracle.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/lars-blogger/tcl/metaweblog-api-procs-oracle.xql 14 Dec 2003 11:10:44 -0000 1.2 +++ openacs-4/packages/lars-blogger/tcl/metaweblog-api-procs-oracle.xql 14 Dec 2003 12:34:25 -0000 1.3 @@ -10,7 +10,7 @@ to_char(entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi, title, c.name as category, - content, + content from pinds_blog_entries e, pinds_blog_categories c where e.category_id = c.category_id(+) and e.package_id = :package_id Index: openacs-4/packages/lars-blogger/tcl/metaweblog-api-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/metaweblog-api-procs-postgresql.xql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/lars-blogger/tcl/metaweblog-api-procs-postgresql.xql 14 Dec 2003 11:10:44 -0000 1.2 +++ openacs-4/packages/lars-blogger/tcl/metaweblog-api-procs-postgresql.xql 14 Dec 2003 12:34:25 -0000 1.3 @@ -9,7 +9,7 @@ to_char(entry_date, 'YYYY-MM-DD HH24:MI:SS') as entry_date_ansi, title, c.name as category, - content, + content from pinds_blog_entries e left outer join pinds_blog_categories c using (category_id) where e.package_id = :package_id