Index: openacs-4/packages/lars-blogger/tcl/entry-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/tcl/entry-procs-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/lars-blogger/tcl/entry-procs-postgresql.xql 27 Jan 2003 16:19:15 -0000 1.1
+++ openacs-4/packages/lars-blogger/tcl/entry-procs-postgresql.xql 28 Aug 2003 09:41:55 -0000 1.2
@@ -7,11 +7,13 @@
select b.entry_id,
b.title,
+ b.title_url,
b.content,
b.content_format,
b.draft_p,
+ o.creation_user as user_id,
to_char(b.entry_date, 'YYYY-MM-DD') as entry_date,
- to_char(b.entry_date, 'fmDayfm, Month fmDDfm, YYYY') as entry_date_pretty,
+ to_char(b.entry_date, 'fmDayfm, fmMonthfm fmDDfm, YYYY') as entry_date_pretty,
p.first_names as poster_first_names,
p.last_name as poster_last_name,
to_char(b.posted_date , 'HH24:MI') as posted_time_pretty,
@@ -29,4 +31,14 @@
+
+
+ update pinds_blog_entries
+ set entry_date = date_trunc('day', current_timestamp),
+ draft_p = 'f',
+ posted_date = current_timestamp
+ where entry_id = :entry_id
+
+
+