########### VIEW


  <% form_for(:prospect, :url => { :action => 'index' }, :html => { :method => :get }) do |f| %>

    

      

        Search Criteria
      

      

        First Name<%= f.text_field :firstname, :size => 10 %>
        Last Name<%= f.text_field :lastname, :size => 10 %>
        Email<%= f.text_field :email, :size => 15 %>
      

      

        City<%= f.text_field :city, :size => 10 %>
        Province<%= f.text_field :province, :size => 10 %>
        ZipCode<%= f.text_field :zipcode, :size => 5 %>
      

      

        Start Date<%= f.date_select :date_start, :order => [:month, :day, :year], :start_year => 1950 %>
      

      

        End Date<%= f.date_select :date_end, :order => [:month, :day, :year], :start_year => 1950 %>
      

    


    <%= submit_tag 'Search' %>
  <% end %>





############ CONTROLLER
  def index
    cond = EZ::Where::Condition.new :prospects do
      firstname =~ "%#{params[:firstname]}%"
      lastname =~ "%#{params[:lastname]}%"
      city =~ "%#{params[:city]}%"
      province == params[:province]
      zipcode =~ "%#{params[: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

############ DEVELOPMENT.LOG
Processing ProspectsController#index (for 127.0.0.1 at 2006-12-06 10:14:43) [GET]
  Session ID: 5bfd17a4d2a67821b0f4b322a4379b67
  Parameters: {"prospect"=>{"city"=>nil, "zipcode"=>nil, "date_start(1i)"=>"2006", "firstname"=>nil, "lastname"=>"hedge", "date_start(2i)"=>"12", "date_start(3i)"=>"6", "date_end(1i)"=>"2006", "province"=>nil, "date_end(2i)"=>"12", "email"=>nil, "date_end(3i)"=>"6"}, "commit"=>"Search", "action"=>"index", "controller"=>"prospects"}
  Prospect Load (0.000120)   SELECT * FROM prospects
Rendering actionindexcontent_typetext/htmllayoutfalse within layouts/application
Rendering prospects/index
Rendered prospects/_search (0.02863)
  Prospect Columns (0.001257)   SHOW FIELDS FROM prospects
Completed in 0.08267 (12 reqs/sec) | Rendering: 0.06512 (78%) | DB: 0.00138 (1%) | 200 OK [http://localhost/prospects?prospect%5Bfirstname%5D=&prospect%5Blastname%5D=hedge&prospect%5Bemail%5D=&prospect%5Bcity%5D=&prospect%5Bprovince%5D=&prospect%5Bzipcode%5D=&prospect%5Bdate_start%282i%29%5D=12&prospect%5Bdate_start%283i%29%5D=6&prospect%5Bdate_start%281i%29%5D=2006&prospect%5Bdate_end%282i%29%5D=12&prospect%5Bdate_end%283i%29%5D=6&prospect%5Bdate_end%281i%29%5D=2006&commit=Search]