Index: openacs-4/packages/lars-blogger/www/one-entry.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/www/Attic/one-entry.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/lars-blogger/www/one-entry.xql	19 Aug 2002 21:52:59 -0000	1.1
+++ openacs-4/packages/lars-blogger/www/one-entry.xql	12 Sep 2002 14:14:54 -0000	1.2
@@ -4,9 +4,19 @@
 
     <fullquery name="entry">
         <querytext>
-		    select title, content, draft_p, to_char(entry_date, 'YYYY-MM-DD') as entry_date
-		    from   pinds_blog_entries
-		    where  entry_id = :entry_id
+		    select b.title, 
+                           b.content, 
+                           b.draft_p, 
+                           to_char(b.entry_date, 'YYYY-MM-DD') as entry_date,
+        		   p.first_names as poster_first_names,
+		           p.last_name as poster_last_name,
+		           to_char(b.posted_date , 'HH24:SS') as posted_time_pretty
+		    from   pinds_blog_entries b,
+                           acs_objects o,
+                           persons p
+		    where  b.entry_id = :entry_id
+                    and    o.object_id = b.entry_id
+                    and    p.person_id = o.creation_user
         </querytext>
     </fullquery>