dacur/controller.rb

Created September 3, 2014 15:12

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/dacur/131615e7b5b414c69e5d.js"></script>
Save dacur/131615e7b5b414c69e5d to your computer and use it in GitHub Desktop.

Download ZIP

You have a search box where someone can enter a first OR last name. You need to search your database of all first names AND last names looking for the value entered. The code below is ActiveRecord's way of handling this search for you - no SQL required. See here for more info: http://stackoverflow.com/questions/3684311/rails-how-to-chain-scope-q…

Raw

controller.rb

@vendorsfound = Vendor.where("first like ? OR last like ?", "%" + params[:first] + "%", "%" + params[:first] + "%").order("LOWER(last) ASC, first")

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment