Index: openacs-4/packages/recruiting/www/admin/view-one-candidate.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/recruiting/www/admin/view-one-candidate.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/recruiting/www/admin/view-one-candidate.xql	1 Aug 2002 22:14:37 -0000	1.2
+++ openacs-4/packages/recruiting/www/admin/view-one-candidate.xql	7 Aug 2002 23:39:19 -0000	1.3
@@ -6,9 +6,13 @@
                   p.person_id,
                   p.first_names,
                   p.last_name,
-                  (select count(*) 
-                     from recruiting_ratings r
-                    where r.interview_id = i.interview_id) as num_ratings
+                  (CASE
+                     WHEN (select count(*) 
+                             from recruiting_ratings r
+                            where r.interview_id = i.interview_id) = 0
+                     THEN 'No'
+                     ELSE 'Yes'
+                  END) as completed_p
              from persons p,
                   recruiting_interviews i
             where i.interviewer_id = p.person_id