Pastie Support Pastie or read my Pastie << self blog

# try this

  def index
    ps = params[:prospect] || {}
    cond = EZ::Where::Condition.new :prospects do
      firstname =~ "%#{ps[:firstname]}%"
      lastname =~ "%#{ps[:lastname]}%"
      city =~ "%#{ps[:city]}%"
      province == ps[:province]
      zipcode =~ "%#{ps[:zipcode]}%"
    end
    @prospects = Prospect.find :all, :conditions => cond.to_sql
    respond_to do |format|
      format.html
      format.xml  { render :xml => @prospects.to_xml }
    end
  end