Index: openacs-4/packages/acs-subsite/www/shared/community-member-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/shared/Attic/community-member-postgresql.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/acs-subsite/www/shared/community-member-postgresql.xql 28 Aug 2003 09:41:42 -0000 1.3 +++ openacs-4/packages/acs-subsite/www/shared/community-member-postgresql.xql 13 Jan 2005 13:55:50 -0000 1.4 @@ -4,12 +4,13 @@ -select at.pretty_name, at.pretty_plural, a.creation_date, acs_object__name(a.object_id) as object_name -from acs_objects a, acs_object_types at -where a.object_type = at.object_type -and a.creation_user = :user_id -order by at.pretty_name, creation_date desc + select at.pretty_name, at.pretty_plural, a.creation_date, acs_object__name(a.object_id) as object_name + from acs_objects a, acs_object_types at + where a.object_type = at.object_type + and a.creation_user = :user_id + order by at.pretty_name, creation_date desc +