Index: openacs-4/packages/lars-blogger/www/blog-months-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/www/blog-months-oracle.xql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/lars-blogger/www/blog-months-oracle.xql	14 Sep 2002 18:37:58 -0000	1.2
+++ openacs-4/packages/lars-blogger/www/blog-months-oracle.xql	13 Jun 2003 09:15:01 -0000	1.2.2.1
@@ -3,7 +3,7 @@
 <queryset>
     <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
-    <fullquery name="months">
+    <fullquery name="all_blog_months">
         <querytext>
 			select trunc(entry_date, 'month') as month_date,
 			       to_char(trunc(entry_date, 'month'), 'fmMonthfm YYYY')
@@ -18,4 +18,21 @@
         </querytext>
     </fullquery>
 
+    <fullquery name="one_blog_months">
+        <querytext>
+			select trunc(entry_date, 'month') as month_date,
+			       to_char(trunc(entry_date, 'month'), 'fmMonthfm YYYY')
+					  as date_pretty,
+			       to_char(trunc(entry_date, 'month'), 'YYYY/MM/')
+					  as month_url_stub
+			from   pinds_blog_entries e, users u
+			where  draft_p = 'f'
+			and    package_id = :package_id
+			and    screen_name = :screen_name
+			and    u.user_id = e.user_id
+			group  by trunc(entry_date, 'month')
+			order  by month_date desc
+        </querytext>
+    </fullquery>
+
 </queryset>