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.1 -r1.2
--- openacs-4/packages/address-book/www/index-oracle.xql	22 Aug 2001 23:11:49 -0000	1.1
+++ openacs-4/packages/address-book/www/index-oracle.xql	1 Sep 2001 20:34:19 -0000	1.2
@@ -9,5 +9,25 @@
       </querytext>
 </fullquery>
 
+<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,
+           acs_permission.permission_p(acr.rel_id,:user_id,'delete') as delete_p,
+           acr.rel_id
+      from ab_contacts_related acr
+     where acs_permission.permission_p(contact_id,:user_id,'read') = 't'
+       and object_id = :instance_id
+      [value_if_exists search_filter]
+  </querytext>
+</fullquery>
  
 </queryset>