Index: openacs-4/packages/acs-subsite/acs-subsite.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/acs-subsite.info,v
diff -u -r1.18 -r1.19
--- openacs-4/packages/acs-subsite/acs-subsite.info	2 Sep 2001 12:42:25 -0000	1.18
+++ openacs-4/packages/acs-subsite/acs-subsite.info	4 Sep 2001 00:48:18 -0000	1.19
@@ -529,6 +529,7 @@
             <file type="content_page" path="www/register/deleted-user.tcl"/>
             <file type="query_file" path="www/register/deleted-user.xql"/>
             <file type="query_file" db_type="postgresql" path="www/register/email-confirm-postgresql.xql"/>
+            <file type="query_file" db_type="oracle" path="www/register/email-confirm-oracle.xql"/>
             <file type="content_page" path="www/register/email-confirm.adp"/>
             <file type="content_page" path="www/register/email-confirm.tcl"/>
             <file type="query_file" path="www/register/email-confirm.xql"/>
Index: openacs-4/packages/acs-subsite/www/register/email-confirm-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/register/Attic/email-confirm-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-subsite/www/register/email-confirm-oracle.xql	4 Sep 2001 00:48:18 -0000	1.1
@@ -0,0 +1,20 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="register_email_user_info_get">      
+      <querytext>
+      
+	select c.member_state,
+	       c.email,
+	       c.user_id,
+	       c.email_verified_p
+	  from users u, cc_users c
+	 where u.user_id = c.user_id
+	   and u.rowid = :row_id
+
+      </querytext>
+</fullquery>
+
+ 
+</queryset>