Index: openacs-4/packages/acs-admin/www/users/one-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/Attic/one-oracle.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-admin/www/users/one-oracle.xql	16 Jan 2003 13:28:06 -0000	1.4
+++ openacs-4/packages/acs-admin/www/users/one-oracle.xql	22 Sep 2003 10:24:58 -0000	1.5
@@ -5,13 +5,22 @@
 
 <fullquery name="user_info">      
       <querytext>
-      select first_names, last_name, email, nvl(screen_name,'&lt; none set up &gt;') as screen_name, creation_date, creation_ip, last_visit, member_state, email_verified_p, url
-from cc_users
-where user_id = :user_id
+      select first_names, 
+             last_name, 
+             username, 
+             email,
+             nvl(screen_name,'&lt; none set up &gt;') as screen_name,
+             creation_date, 
+             creation_ip, 
+             to_char(last_visit, 'YYYY-MM-DD HH24:MI:SS') as last_visit_ansi, 
+             member_state,
+             email_verified_p, 
+             url
+      from   cc_users
+      where  user_id = :user_id
       </querytext>
 </fullquery>
 
- 
 <fullquery name="get_item_id">      
       <querytext>
       select live_revision as revision_id, nvl(title,'view this portrait') portrait_title