Index: openacs-4/packages/dotlrn/www/members-chunk-table-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/members-chunk-table-oracle.xql,v
diff -u -r1.5 -r1.5.2.1
--- openacs-4/packages/dotlrn/www/members-chunk-table-oracle.xql	17 May 2004 15:15:02 -0000	1.5
+++ openacs-4/packages/dotlrn/www/members-chunk-table-oracle.xql	31 May 2005 23:13:06 -0000	1.5.2.1
@@ -13,7 +13,8 @@
                    acs_users_all.last_name,
                    acs_users_all.email,
                    (select count(*) from acs_rels where rel_type = 'user_portrait_rel' and object_id_one = dotlrn_member_rels_approved.user_id) as portrait_p,
-                   (select count(*) from acs_attribute_values where object_id = dotlrn_member_rels_approved.user_id and attribute_id = :bio_attribute_id and attr_value != '') as bio_p
+                   (select count(*) from acs_attribute_values where object_id = dotlrn_member_rels_approved.user_id and attribute_id = 
+:bio_attribute_id and attr_value is not null) as bio_p
             from acs_users_all,
                  dotlrn_member_rels_approved
             where dotlrn_member_rels_approved.community_id = :community_id