Index: openacs-4/packages/acs-subsite/www/shared/community-member-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/shared/community-member-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-subsite/www/shared/community-member-postgresql.xql 19 Apr 2001 16:38:05 -0000 1.1 +++ openacs-4/packages/acs-subsite/www/shared/community-member-postgresql.xql 22 Apr 2001 16:13:15 -0000 1.2 @@ -1,18 +1,15 @@ - - postgresql - 7.1 - +postgresql7.1 - - - select at.pretty_name, at.pretty_plural, a.creation_date, acs_object__name(a.object_id) as object_name + + +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 object_name, creation_date - - + +