Index: openacs-4/packages/acs-subsite/www/register/user-login-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/register/Attic/user-login-oracle.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-subsite/www/register/user-login-oracle.xql	6 Jun 2003 09:13:00 -0000	1.1.2.1
@@ -0,0 +1,19 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="user_login_user_id_from_email">      
+      <querytext>
+      
+          select user_id, 
+                 member_state, 
+                 email_verified_p, 
+                 trunc(sysdate - password_changed_date) as password_age_days
+          from   cc_users
+          where  email = :email      
+
+      </querytext>
+</fullquery>
+
+ 
+</queryset>