Index: openacs-4/packages/rss-support/www/subscrs-include-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/www/Attic/subscrs-include-oracle.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/rss-support/www/subscrs-include-oracle.xql 28 Sep 2003 15:08:12 -0000 1.3 +++ openacs-4/packages/rss-support/www/subscrs-include-oracle.xql 23 Feb 2005 12:33:21 -0000 1.4 @@ -8,7 +8,7 @@ select s.subscr_id, s.timeout, person.name(o.creation_user) as creator, - nvl(to_char(s.lastbuild,'YYYY-MM-DD HH24:MI:SS'),'never built') as lastbuild_ansi, + to_char(s.lastbuild,'YYYY-MM-DD HH24:MI:SS') as lastbuild_ansi, s.last_ttb, s.channel_title, s.channel_link Index: openacs-4/packages/rss-support/www/subscrs-include-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/www/Attic/subscrs-include-postgresql.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/rss-support/www/subscrs-include-postgresql.xql 28 Sep 2003 15:08:12 -0000 1.3 +++ openacs-4/packages/rss-support/www/subscrs-include-postgresql.xql 23 Feb 2005 12:33:22 -0000 1.4 @@ -8,7 +8,7 @@ select s.subscr_id, s.timeout, person__name(o.creation_user) as creator, - coalesce(to_char(s.lastbuild,'YYYY-MM-DD HH24:MI:SS'),'never built') as lastbuild_ansi, + to_char(s.lastbuild,'YYYY-MM-DD HH24:MI:SS') as lastbuild_ansi, s.last_ttb, s.channel_title, s.channel_link Index: openacs-4/packages/rss-support/www/subscrs-include.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/www/subscrs-include.tcl,v diff -u -r1.4 -r1.5 --- openacs-4/packages/rss-support/www/subscrs-include.tcl 28 Sep 2003 15:08:12 -0000 1.4 +++ openacs-4/packages/rss-support/www/subscrs-include.tcl 23 Feb 2005 12:33:22 -0000 1.5 @@ -5,8 +5,12 @@ } db_multirow -extend { lastbuild_pretty } subscrs get_subscrs {} { - set lastbuild_ansi [lc_time_system_to_conn $lastbuild_ansi] - set lastbuild_pretty [lc_time_fmt $lastbuild_ansi "%x %X"] + if {![empty_string_p $lastbuild_ansi]} { + set lastbuild_ansi [lc_time_system_to_conn $lastbuild_ansi] + set lastbuild_pretty [lc_time_fmt $lastbuild_ansi "%x %X"] + } else { + set lastbuild_pretty "never built" + } if [string equal $channel_title ""] { set channel_title "Subscription #$subscr_id"