Index: openacs-4/packages/news/sql/oracle/news-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/sql/oracle/news-create.sql,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/news/sql/oracle/news-create.sql	6 Oct 2003 12:11:23 -0000	1.8
+++ openacs-4/packages/news/sql/oracle/news-create.sql	13 Jan 2005 13:58:26 -0000	1.9
@@ -925,7 +925,7 @@
     ci.item_id as item_id,
     cn.package_id as package_id,
     revision_id,        
-    title as publish_title,
+    cr.title as publish_title,
     content.blob_to_string(cr.content) as publish_body,
     decode(cr.mime_type,'text/html','t','f') as html_p,
     cr.publish_date,