Rails - Feb 2006 - sql logic is killing me

I know my thinking is sloppy.

I want to know how many clients currently in my facility are male...

My facilities_controller.rb

  def list_fac
    @placement_pages, @placements = paginate(
      :placements, 
      :conditions => ["placements.facility_id = ?",
        params[:facility_id] ],
      :include => [:facility, :client],
      :order_by => ''facilities.name, clients.last_name,
      :per_page => 14)
    @facility = Facility.find(:first,
      :conditions => ["id = ?", params[:facility_id] ])
    @beds_total = @facility.beds_m + @facility.beds_f + @facility.beds_a
    @beds_m_cnt = Client.count_by_sql("select count(*) " +
      " from clients where sex = ''M'' ")
  end

the @beds_m_cnt gives me count of all Male clients but I only need the
ones in @placements which I can''t seem to use in the @beds_m_cnt
assignment. Is this an issue of iteration that I don''t understand or
logic which I apparently don''t have?

Help?

Craig

Please ignore - I actually figured it out myself...I did have to
iterate.

Thanks

Craig

On Fri, 2006-02-17 at 21:34 -0700, Craig White wrote:
> I know my thinking is sloppy.
> 
> I want to know how many clients currently in my facility are male...
> 
> My facilities_controller.rb
> 
>   def list_fac
>     @placement_pages, @placements = paginate(
>       :placements, 
>       :conditions => ["placements.facility_id = ?",
>         params[:facility_id] ],
>       :include => [:facility, :client],
>       :order_by => ''facilities.name, clients.last_name,
>       :per_page => 14)
>     @facility = Facility.find(:first,
>       :conditions => ["id = ?", params[:facility_id] ])
>     @beds_total = @facility.beds_m + @facility.beds_f + @facility.beds_a
>     @beds_m_cnt = Client.count_by_sql("select count(*) " +
>       " from clients where sex = ''M'' ")
>   end
> 
> the @beds_m_cnt gives me count of all Male clients but I only need the
> ones in @placements which I can''t seem to use in the @beds_m_cnt
> assignment. Is this an issue of iteration that I don''t understand
or
> logic which I apparently don''t have?
> 
> Help?
> 
> Craig
> 
> _______________________________________________
> Rails mailing list
> Rails@lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails