Pastie Support Pastie or read my Pastie << self blog

Language: ActionScript C/C++ CSS Diff HTML (ERB / Rails) HTML / XML Java Javascript Objective C/C++ Pascal Perl PHP Plain text Python Ruby Ruby (on Rails) Shell Script (Bash) SQL YAML  

## mark a section (Learn more)

This paste will be private.

########### VIEW <div id="toggle_hidden"> <% form_for(:prospect, :url => { :action => 'index' }, :html => { :method => :get }) do |f| %> <table width="100%"> <tr> <th colspan="6">Search Criteria</th> </tr> <tr> <td>First Name</td><td><%= f.text_field :firstname, :size => 10 %></td> <td>Last Name</td><td><%= f.text_field :lastname, :size => 10 %></td> <td>Email</td><td><%= f.text_field :email, :size => 15 %></td> </tr> <tr> <td>City</td><td><%= f.text_field :city, :size => 10 %></td> <td>Province</td><td><%= f.text_field :province, :size => 10 %></td> <td>ZipCode</td><td><%= f.text_field :zipcode, :size => 5 %></td> </tr> <tr> <td>Start Date</td><td colspan="4"><%= f.date_select :date_start, :order => [:month, :day, :year], :start_year => 1950 %></td> </tr> <tr> <td>End Date</td><td colspan="4"><%= f.date_select :date_end, :order => [:month, :day, :year], :start_year => 1950 %></td> </tr> </table> <%= submit_tag 'Search' %> <% end %> </div> <br /> ############ 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]