Index: openacs-4/packages/cms/www/modules/users/edit-user.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/users/edit-user.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/cms/www/modules/users/edit-user.xql 25 May 2001 23:49:05 -0000 1.1 +++ openacs-4/packages/cms/www/modules/users/edit-user.xql 8 Jun 2001 01:44:53 -0000 1.2 @@ -1,6 +1,27 @@ + + + + select + p.first_names, p.last_name, + pp.email, pp.url, + u.screen_name, + to_char(u.no_alerts_until, 'YYYY/MM/DD') as no_alerts_until + from + persons p, parties pp, users u + where + p.person_id = :id + and + pp.party_id = :id + and + u.user_id = :id + + + + +