Index: openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/arc-edit-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/arc-edit-oracle.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/arc-edit-oracle.xql	16 May 2001 00:43:15 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/acs-workflow/www/admin/arc-edit-oracle.xql	9 Oct 2002 21:05:19 -0000	1.1.4.1
@@ -1,6 +1,6 @@
 <?xml version="1.0"?>
 <queryset>
-   <rdbms><type>postgresql</type><version>7.1</version></rdbms>                                                
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>                                                
 
 <fullquery name="possible_guards">      
       <querytext>
Index: openacs-4/packages/acs-admin/www/apm/packages-install-3-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/apm/packages-install-3-oracle.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/acs-admin/www/apm/packages-install-3-oracle.xql	3 Oct 2001 23:35:49 -0000	1.1
+++ openacs-4/packages/acs-admin/www/apm/packages-install-3-oracle.xql	9 Oct 2002 21:05:13 -0000	1.1.4.1
@@ -1,5 +1,6 @@
 <?xml version="1.0"?>
 <queryset>
+<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
 <fullquery name="apm_package_upgrade_from">      
       <querytext>
Index: openacs-4/packages/acs-admin/www/apm/packages-install-3-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/apm/packages-install-3-postgresql.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/acs-admin/www/apm/packages-install-3-postgresql.xql	3 Oct 2001 23:35:49 -0000	1.1
+++ openacs-4/packages/acs-admin/www/apm/packages-install-3-postgresql.xql	9 Oct 2002 21:05:13 -0000	1.1.4.1
@@ -1,5 +1,6 @@
 <?xml version="1.0"?>
 <queryset>
+<rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
 <fullquery name="apm_package_upgrade_from">      
       <querytext>
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.2 -r1.2.4.1
--- openacs-4/packages/acs-admin/www/users/one-oracle.xql	9 May 2001 22:32:25 -0000	1.2
+++ openacs-4/packages/acs-admin/www/users/one-oracle.xql	9 Oct 2002 21:05:16 -0000	1.2.4.1
@@ -5,7 +5,7 @@
 
 <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
+      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
 from cc_users
 where user_id = :user_id
       </querytext>
Index: openacs-4/packages/acs-admin/www/users/one.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/one.xql,v
diff -u -r1.9 -r1.9.2.1
--- openacs-4/packages/acs-admin/www/users/one.xql	24 Sep 2002 00:12:32 -0000	1.9
+++ openacs-4/packages/acs-admin/www/users/one.xql	9 Oct 2002 21:05:16 -0000	1.9.2.1
@@ -4,7 +4,7 @@
 <fullquery name="user_info">      
       <querytext>
       select first_names, last_name, email,
-          coalesce(screen_name,'&lt none set up &gt') as screen_name,
+          coalesce(screen_name,'&lt; none set up &gt;') as screen_name,
           creation_date, creation_ip, last_visit, member_state, email_verified_p
       from cc_users
       where user_id = :user_id
Index: openacs-4/packages/acs-lang/tcl/lang-init-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/tcl/Attic/lang-init-oracle.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/acs-lang/tcl/lang-init-oracle.xql	2 May 2001 20:15:34 -0000	1.1
+++ openacs-4/packages/acs-lang/tcl/lang-init-oracle.xql	9 Oct 2002 21:05:17 -0000	1.1.4.1
@@ -1,5 +1,6 @@
 <?xml version="1.0"?>
 <queryset>
+<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
 <fullquery name="select_lang_keys">      
       <querytext>
Index: openacs-4/packages/acs-lang/tcl/lang-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/tcl/Attic/lang-procs-oracle.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/acs-lang/tcl/lang-procs-oracle.xql	2 May 2001 20:15:34 -0000	1.1
+++ openacs-4/packages/acs-lang/tcl/lang-procs-oracle.xql	9 Oct 2002 21:05:17 -0000	1.1.4.1
@@ -1,5 +1,6 @@
 <?xml version="1.0"?>
 <queryset>
+<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
 <fullquery name="lang_message_register.lang_message_update">      
       <querytext>
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.2 -r1.2.4.1
--- openacs-4/packages/acs-subsite/www/pvt/home.xql	15 May 2001 16:59:01 -0000	1.2
+++ openacs-4/packages/acs-subsite/www/pvt/home.xql	9 Oct 2002 21:05:18 -0000	1.2.4.1
@@ -5,7 +5,7 @@
       <querytext>
       
     select first_names, last_name, email, url,
-    coalesce(screen_name,'&lt none set up &gt') as screen_name
+    coalesce(screen_name,'&lt; none set up &gt;') as screen_name
     from cc_users 
     where user_id=:user_id
 
Index: openacs-4/packages/address-book/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/address-book/www/index-oracle.xql,v
diff -u -r1.2 -r1.2.4.1
--- openacs-4/packages/address-book/www/index-oracle.xql	1 Sep 2001 20:34:19 -0000	1.2
+++ openacs-4/packages/address-book/www/index-oracle.xql	9 Oct 2002 21:05:19 -0000	1.2.4.1
@@ -12,15 +12,15 @@
 <fullquery name="sql_query">
   <querytext>
     select contact_id,
-           nvl(last_name,'<br>') as last_name,
-           nvl(first_names,'<br>') as first_names,
-           nvl(title,'<br>') as title,
-           nvl(organization,'<br>') as organization,
-           nvl(work_phone,'<br>') as work_phone,
-           nvl(home_phone,'<br>') as home_phone,
-           nvl(fax,'<br>') as fax,
-           nvl(other,'<br>') as other,
-           nvl(email,'<br>') as email,
+           nvl(last_name,'<br />') as last_name,
+           nvl(first_names,'<br />') as first_names,
+           nvl(title,'<br />') as title,
+           nvl(organization,'<br />') as organization,
+           nvl(work_phone,'<br />') as work_phone,
+           nvl(home_phone,'<br />') as home_phone,
+           nvl(fax,'<br />') as fax,
+           nvl(other,'<br />') as other,
+           nvl(email,'<br />') as email,
            acs_permission.permission_p(acr.rel_id,:user_id,'delete') as delete_p,
            acr.rel_id
       from ab_contacts_related acr
Index: openacs-4/packages/address-book/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/address-book/www/index-postgresql.xql,v
diff -u -r1.3 -r1.3.4.1
--- openacs-4/packages/address-book/www/index-postgresql.xql	1 Sep 2001 20:34:19 -0000	1.3
+++ openacs-4/packages/address-book/www/index-postgresql.xql	9 Oct 2002 21:05:19 -0000	1.3.4.1
@@ -12,15 +12,15 @@
 <fullquery name="sql_query">
   <querytext>
     select contact_id,
-           coalesce(last_name,'<br>') as last_name,
-           coalesce(first_names,'<br>') as first_names,
-           coalesce(title,'<br>') as title,
-           coalesce(organization,'<br>') as organization,
-           coalesce(work_phone,'<br>') as work_phone,
-           coalesce(home_phone,'<br>') as home_phone,
-           coalesce(fax,'<br>') as fax,
-           coalesce(other,'<br>') as other,
-           coalesce(email,'<br>') as email,
+           coalesce(last_name,'<br />') as last_name,
+           coalesce(first_names,'<br />') as first_names,
+           coalesce(title,'<br />') as title,
+           coalesce(organization,'<br />') as organization,
+           coalesce(work_phone,'<br />') as work_phone,
+           coalesce(home_phone,'<br />') as home_phone,
+           coalesce(fax,'<br />') as fax,
+           coalesce(other,'<br />') as other,
+           coalesce(email,'<br />') as email,
            acs_permission__permission_p(acr.rel_id,:user_id,'delete') as delete_p,
            acr.rel_id
       from ab_contacts_related acr
Index: openacs-4/packages/bookmarks/www/bookmarks-check-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/bookmarks/www/bookmarks-check-oracle.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/bookmarks/www/bookmarks-check-oracle.xql	23 Jul 2001 03:01:40 -0000	1.1
+++ openacs-4/packages/bookmarks/www/bookmarks-check-oracle.xql	9 Oct 2002 21:05:20 -0000	1.1.4.1
@@ -6,7 +6,7 @@
 
 <partialquery name="set_last_live_date_to_now">
 	<querytext>
-		now()
+              sysdate
 	</querytext>
 </partialquery>
  
Index: openacs-4/packages/clickthrough/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/clickthrough/www/index-oracle.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/clickthrough/www/index-oracle.xql	4 Jun 2001 03:19:13 -0000	1.1
+++ openacs-4/packages/clickthrough/www/index-oracle.xql	9 Oct 2002 21:05:21 -0000	1.1.4.1
@@ -1,5 +1,7 @@
 <?xml version="1.0"?>
 <queryset>
+<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
 <fullquery name="parent_package_sql">
 	<querytext>
 select sn2.object_id as parent_package_id, 
Index: openacs-4/packages/cms/tcl/form-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/tcl/form-procs-postgresql.xql,v
diff -u -r1.18 -r1.18.4.1
--- openacs-4/packages/cms/tcl/form-procs-postgresql.xql	8 Dec 2001 01:17:59 -0000	1.18
+++ openacs-4/packages/cms/tcl/form-procs-postgresql.xql	9 Oct 2002 21:05:22 -0000	1.18.4.1
@@ -63,7 +63,7 @@
       attributes.attribute_id = params.attribute_id
 
 	</querytext>
-</fullquery>
+</partialquery>
 
 <partialquery name="content::create_form_element.cfe_attribute_name_to_char">
 	<querytext>
Index: openacs-4/packages/cms/tcl/pagination-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/tcl/Attic/pagination-procs-oracle.xql,v
diff -u -r1.2 -r1.2.4.1
--- openacs-4/packages/cms/tcl/pagination-procs-oracle.xql	22 Aug 2001 02:24:49 -0000	1.2
+++ openacs-4/packages/cms/tcl/pagination-procs-oracle.xql	9 Oct 2002 21:05:22 -0000	1.2.4.1
@@ -1,5 +1,6 @@
 <?xml version="1.0"?>
 <queryset>
+<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
 <partialquery name="pagination::paginate_query.pg_paginate_query">
 	<querytext>
Index: openacs-4/packages/cms/tcl/pagination-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/tcl/Attic/pagination-procs-postgresql.xql,v
diff -u -r1.2 -r1.2.4.1
--- openacs-4/packages/cms/tcl/pagination-procs-postgresql.xql	12 Aug 2001 14:49:52 -0000	1.2
+++ openacs-4/packages/cms/tcl/pagination-procs-postgresql.xql	9 Oct 2002 21:05:22 -0000	1.2.4.1
@@ -1,5 +1,6 @@
 <?xml version="1.0"?>
 <queryset>
+<rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
 <partialquery name="pagination::paginate_query.pg_paginate_query">
 	<querytext>
Index: openacs-4/packages/cms/www/modules/types/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/types/index-oracle.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/cms/www/modules/types/index-oracle.xql	25 May 2001 23:49:05 -0000	1.1
+++ openacs-4/packages/cms/www/modules/types/index-oracle.xql	9 Oct 2002 21:05:23 -0000	1.1.4.1
@@ -32,7 +32,7 @@
     attr.attribute_id, attr.attribute_name, attr.object_type,
     attr.pretty_name as attribute_name_pretty,
     datatype, types.pretty_name as pretty_name,
-    nvl(description_key,'&nbsp') as description_key, 
+    nvl(description_key,'&nbsp;') as description_key, 
     description, widget
   from 
     acs_attributes attr, acs_attribute_descriptions d,
Index: openacs-4/packages/cms/www/modules/types/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/types/index-postgresql.xql,v
diff -u -r1.4 -r1.4.4.1
--- openacs-4/packages/cms/www/modules/types/index-postgresql.xql	8 Dec 2001 01:18:00 -0000	1.4
+++ openacs-4/packages/cms/www/modules/types/index-postgresql.xql	9 Oct 2002 21:05:23 -0000	1.4.4.1
@@ -30,7 +30,7 @@
     attr.attribute_id, attr.attribute_name, attr.object_type,
     attr.pretty_name as attribute_name_pretty,
     datatype, types.pretty_name as pretty_name,
-    coalesce(description_key,'&nbsp') as description_key, 
+    coalesce(description_key,'&nbsp;') as description_key, 
     description, widget
   from 
     acs_attributes attr left outer join cm_attribute_widgets w using (attribute_id)
Index: openacs-4/packages/ecommerce/www/product-search-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/product-search-oracle.xql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/ecommerce/www/product-search-oracle.xql	26 May 2002 04:36:50 -0000	1.2
+++ openacs-4/packages/ecommerce/www/product-search-oracle.xql	9 Oct 2002 21:05:24 -0000	1.2.2.1
@@ -16,7 +16,7 @@
       and pseudo_contains(p.product_name || p.one_line_description ||  p.detailed_description || p.search_keywords, :search_text) > 0
       order by score desc
     </querytext>
-  </fullquery>
+  </partialquery>
 
   <partialquery name="search_subcategory">      
     <querytext>
@@ -28,7 +28,7 @@
       and pseudo_contains(p.product_name || p.one_line_description ||  p.detailed_description || p.search_keywords, :search_text) > 0
       order by score desc
     </querytext>
-  </fullquery>
+  </partialquery>
 
   <partialquery name="search_all">      
     <querytext>
@@ -38,6 +38,6 @@
       where pseudo_contains(p.product_name || p.one_line_description ||  p.detailed_description || p.search_keywords, :search_text) > 0
       order by score desc
     </querytext>
-  </fullquery>
+  </partialquery>
 
 </queryset>
Index: openacs-4/packages/ecommerce/www/product-search-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/product-search-postgresql.xql,v
diff -u -r1.2 -r1.2.2.1
--- openacs-4/packages/ecommerce/www/product-search-postgresql.xql	26 May 2002 04:36:50 -0000	1.2
+++ openacs-4/packages/ecommerce/www/product-search-postgresql.xql	9 Oct 2002 21:05:24 -0000	1.2.2.1
@@ -16,7 +16,7 @@
       and pseudo_contains(coalesce(p.product_name, '') || coalesce(p.one_line_description, '') ||  coalesce(p.detailed_description, '') || coalesce(p.search_keywords,''), :search_text) > 0
       order by score desc
     </querytext>
-  </fullquery>
+  </partialquery>
 
   <partialquery name="search_subcategory">      
     <querytext>
@@ -28,7 +28,7 @@
       and pseudo_contains(coalesce(p.product_name, '') || coalesce(p.one_line_description, '') ||  coalesce(p.detailed_description, '') || coalesce(p.search_keywords,''), :search_text) > 0
       order by score desc
     </querytext>
-  </fullquery>
+  </partialquery>
 
   <partialquery name="search_all">      
     <querytext>
@@ -38,6 +38,6 @@
       where pseudo_contains(coalesce(p.product_name, '') || coalesce(p.one_line_description, '') ||  coalesce(p.detailed_description, '') || coalesce(p.search_keywords,''), :search_text) > 0
       order by score desc
     </querytext>
-  </fullquery>
+  </partialquery>
 
 </queryset>
Index: openacs-4/packages/ecommerce/www/admin/orders/items-void.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/items-void.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/ecommerce/www/admin/orders/items-void.xql	10 Jul 2001 20:33:53 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/orders/items-void.xql	9 Oct 2002 21:05:25 -0000	1.1.4.1
@@ -3,7 +3,7 @@
 
 <fullquery name="num_non_void_items_select">      
       <querytext>
-      select count(*) from ec_items where order_id=:order_id and product_id=:product_id and item_state<>'void'
+      select count(*) from ec_items where order_id=:order_id and product_id=:product_id and item_state <> 'void'
       </querytext>
 </fullquery>
 
Index: openacs-4/packages/ecommerce/www/admin/products/categories-upload-2-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/products/categories-upload-2-postgresql.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/ecommerce/www/admin/products/categories-upload-2-postgresql.xql	24 Nov 2001 03:44:26 -0000	1.1
+++ openacs-4/packages/ecommerce/www/admin/products/categories-upload-2-postgresql.xql	9 Oct 2002 21:05:25 -0000	1.1.4.1
@@ -1,10 +1,11 @@
 <?xml version="1.0"?>
 <queryset>
+  <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
   <fullquery name="product_check">      
     <querytext>
       select product_id from ec_products 
-      where sku = :sku;
+      where sku = :sku
     </querytext>
   </fullquery>
 
Index: openacs-4/packages/news/www/item-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/Attic/item-oracle.xql,v
diff -u -r1.2 -r1.2.4.1
--- openacs-4/packages/news/www/item-oracle.xql	16 Oct 2001 10:10:19 -0000	1.2
+++ openacs-4/packages/news/www/item-oracle.xql	9 Oct 2002 21:05:26 -0000	1.2.4.1
@@ -10,7 +10,7 @@
        publish_title,
        html_p,
        publish_date,
-       '<a href=/shared/community-member?user_id=' || creation_user || '>' || item_creator ||  '</a>' as creator_link
+       '<a href="/shared/community-member?user_id=' || creation_user || '">' || item_creator ||  '</a>' as creator_link
 from   news_items_live_or_submitted
 where  item_id = :item_id
       </querytext>
Index: openacs-4/packages/news/www/item-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/Attic/item-postgresql.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/news/www/item-postgresql.xql	15 Oct 2001 13:41:03 -0000	1.1
+++ openacs-4/packages/news/www/item-postgresql.xql	9 Oct 2002 21:05:26 -0000	1.1.4.1
@@ -11,7 +11,7 @@
        html_p,
        publish_date,
        publish_body,
-       '<a href=/shared/community-member?user_id=' || creation_user || '>' || item_creator ||  '</a>' as creator_link
+       '<a href="/shared/community-member?user_id=' || creation_user || '">' || item_creator ||  '</a>' as creator_link
 from   news_items_live_or_submitted
 where  item_id = :item_id
       </querytext>
Index: openacs-4/packages/news/www/admin/revision-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/admin/revision-oracle.xql,v
diff -u -r1.2 -r1.2.4.1
--- openacs-4/packages/news/www/admin/revision-oracle.xql	16 Oct 2001 10:10:19 -0000	1.2
+++ openacs-4/packages/news/www/admin/revision-oracle.xql	9 Oct 2002 21:05:27 -0000	1.2.4.1
@@ -15,7 +15,7 @@
            archive_date,
            creation_ip,
            creation_date,
-           '<a href=/shared/community-member?user_id=' || creation_user || '>' || item_creator ||  '</a>' as creator_link
+           '<a href="/shared/community-member?user_id=' || creation_user || '">' || item_creator ||  '</a>' as creator_link
     from   news_item_revisions
     where  item_id = :item_id
     and    revision_id = :revision_id
Index: openacs-4/packages/news/www/admin/revision-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/news/www/admin/revision-postgresql.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/news/www/admin/revision-postgresql.xql	15 Oct 2001 13:41:03 -0000	1.1
+++ openacs-4/packages/news/www/admin/revision-postgresql.xql	9 Oct 2002 21:05:27 -0000	1.1.4.1
@@ -16,7 +16,7 @@
            creation_ip,
            creation_date,
 	   publish_body,
-           '<a href=/shared/community-member?user_id=' || creation_user || '>' || item_creator ||  '</a>' as creator_link
+           '<a href="/shared/community-member?user_id=' || creation_user || '">' || item_creator ||  '</a>' as creator_link
     from   news_item_revisions
     where  item_id = :item_id
     and    revision_id = :revision_id
Index: openacs-4/packages/notes/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notes/www/index-oracle.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/notes/www/index-oracle.xql	3 May 2001 18:23:35 -0000	1.1
+++ openacs-4/packages/notes/www/index-oracle.xql	9 Oct 2002 21:05:28 -0000	1.1.4.1
@@ -1,5 +1,6 @@
 <?xml version="1.0"?>
 <queryset>
+<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
 <fullquery name="notes">      
       <querytext>
Index: openacs-4/packages/robot-detection/tcl/robot-detection-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/robot-detection/tcl/robot-detection-procs-oracle.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/robot-detection/tcl/robot-detection-procs-oracle.xql	3 May 2001 20:00:36 -0000	1.1
+++ openacs-4/packages/robot-detection/tcl/robot-detection-procs-oracle.xql	9 Oct 2002 21:05:29 -0000	1.1.4.1
@@ -1,6 +1,7 @@
 <?xml version="1.0"?>
 <queryset>
- 
+<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
 <fullquery name="ad_update_robot_list.days_since_last_update">      
       <querytext>
 	    select trunc(sysdate - max(nvl(modified_date, insertion_date))) from robots
Index: openacs-4/packages/robot-detection/tcl/robot-detection-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/robot-detection/tcl/robot-detection-procs-postgresql.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/robot-detection/tcl/robot-detection-procs-postgresql.xql	3 May 2001 20:00:36 -0000	1.1
+++ openacs-4/packages/robot-detection/tcl/robot-detection-procs-postgresql.xql	9 Oct 2002 21:05:29 -0000	1.1.4.1
@@ -1,6 +1,7 @@
 <?xml version="1.0"?>
 <queryset>
- 
+<rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
 <fullquery name="ad_update_robot_list.days_since_last_update">      
       <querytext>
 		select trunc(current_time - max(coalesce(modified_date, insertion_date))) from robots
Index: openacs-4/packages/simple-survey/www/admin/view-text-responses-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/simple-survey/www/admin/view-text-responses-oracle.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/simple-survey/www/admin/view-text-responses-oracle.xql	2 Jul 2001 21:46:55 -0000	1.1
+++ openacs-4/packages/simple-survey/www/admin/view-text-responses-oracle.xql	9 Oct 2002 21:05:30 -0000	1.1.4.1
@@ -1,5 +1,6 @@
 <?xml version="1.0"?>
 <queryset>
+<rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
 <fullquery name="all_responses_to_question">      
       <querytext>
Index: openacs-4/packages/simple-survey/www/admin/view-text-responses-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/simple-survey/www/admin/view-text-responses-postgresql.xql,v
diff -u -r1.2 -r1.2.4.1
--- openacs-4/packages/simple-survey/www/admin/view-text-responses-postgresql.xql	5 Jul 2001 16:15:20 -0000	1.2
+++ openacs-4/packages/simple-survey/www/admin/view-text-responses-postgresql.xql	9 Oct 2002 21:05:30 -0000	1.2.4.1
@@ -1,5 +1,6 @@
 <?xml version="1.0"?>
 <queryset>
+<rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
 <fullquery name="all_responses_to_question">      
       <querytext>