Index: openacs-4/packages/acs-subsite/www/pvt/home.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/pvt/Attic/home.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/acs-subsite/www/pvt/home.xql 30 Nov 2002 17:22:53 -0000 1.3 +++ openacs-4/packages/acs-subsite/www/pvt/home.xql 9 Dec 2002 13:29:00 -0000 1.4 @@ -4,8 +4,7 @@ - select first_names, last_name, email, url, - coalesce(screen_name,'< none set up >') as screen_name + select first_names, last_name, email, url, screen_name from cc_users where user_id=:user_id @@ -31,7 +30,7 @@ - select cr.publish_date, coalesce(cr.title,'your portrait') as portrait_title + select cr.publish_date, cr.title as portrait_title from cr_revisions cr, cr_items ci, acs_rels a where cr.revision_id = ci.live_revision and ci.item_id = a.object_id_two