From: Martin Robertson <info@...>
Date: 2007-11-12T09:47:47+09:00
Subject: newbie stuck with multiple conditions

Hi

I am new to rails and programming.

I am trying to get a conditional search from form results for a property
search.

I want to be able to contruct a search that will search (:all) if ID for
all is returned or by individual ID

 The code below does not work for the all condition

def results

   suburb_id=params[:suburb][:id]
   bedroom_id=params[:bedroom][:id]
   garage_id=params[:garage][:id]
   @listings=ListingDetail.find(
   :all,
   :conditions =>["suburb_id =:suburb_id and bedroom_id=:bedroom_id and
garage_id=:garage_id",
   {
   :suburb_id =>suburb_id,
   :bedroom_id=>bedroom_id,
   :garage_id=>garage_id
   }
   ]
   )
end

I have also tried use case and if as below

   def results

  bedroom_id=params[:bedroom][:id]
  case bedroom_id
  when 6
  @listings=ListingDetail.find_all_by_bedroom_id(:all)
  else
    @listings=ListingDetail.find_all_by_bedroom_id(bedroom_id)
    end
   garage_id=params[:garage][:id]
    case garage_id
    when 4
    @listings=ListingDetail.find_all_by_garage_id(:all)
    else
    @listings=ListingDetail.find_all_by_garage_id(garage_id)
  end

   end

Any help would be appreciated

Martin
-- 
Posted via http://www.ruby-forum.com/.