Displaying 1 result from an estimated 1 matches for "district_control".
2005 Aug 04
0
Finding rows in table a with zero related rows in table b, part ii
...:finder_sql => "select a.* from applicants a left join
applicants_interviewers ai " +
"on a.id = ai.applicant_id where ai.applicant_id is null"
end
Running that SQL through the mysql command-line tool returns exactly the
data I''m looking for. However, in my district_controller.rb file, I''ve
got this method:
def unassigned_list
@dist = District.find( params[:dist_id] )
@applicants = @dist.unassigned_applicants.find( :all )
@sub_title = "Unassigned Applicants (" + @applicants.size.to_s + ")"
render :template => "district/a...