Index: openacs-4/packages/directory/www/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/directory/www/index.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/directory/www/index.xql 21 Oct 2001 18:16:34 -0000 1.1
+++ openacs-4/packages/directory/www/index.xql 21 Oct 2001 21:44:46 -0000 1.2
@@ -3,18 +3,17 @@
-
- select count(1)
- from $table_and_group
+ select count(1)
+ from $table_and_group
-
- select count(1)
- from $table_and_group
+ select count(1)
+ from $table_and_group
+ $where_clause
@@ -30,4 +29,50 @@
+
+
+ order by lower(last_name)
+
+
+
+
+
+ order by lower(email)
+
+
+
+
+
+ order by lower(last_name) desc
+
+
+
+
+
+ order by lower(email) desc
+
+
+
+
+
+ and (lower(first_names) like '%' || lower(:search) || '%'
+ or lower(last_name) like '%' || lower(:search) || '%'
+ or lower(email) like '%' || lower(:search) || '%')
+
+
+
+
+
+ and upper(last_name) like :letter || '%'
+
+
+
+
+
+ select m.* from $table_and_group
+ $where_clause
+ $order_clause
+
+
+