Index: openacs-4/packages/dotlrn/www/members-chunk-table-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/members-chunk-table-postgresql.xql,v diff -u -N -r1.4 -r1.5 --- openacs-4/packages/dotlrn/www/members-chunk-table-postgresql.xql 17 May 2004 15:15:02 -0000 1.4 +++ openacs-4/packages/dotlrn/www/members-chunk-table-postgresql.xql 8 Aug 2006 21:26:24 -0000 1.5 @@ -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