Commit `062730df`

luu stiles <luuduong@gmail.com>

2012-01-25 01:56:19

added upper so that the searches will be case insensitive

master

1 parent 8f8e655

Changed files (1)

app

controllers

search_controller.rb

@@ -5,8 +5,8 @@ class SearchController < ApplicationController
       @search = nil
     else
       sql = "%"+params[:q]+"%"
-      @creations = Creation.where("name like ? OR story like ?", sql, sql).page(params[:page]).per(8)
-      @members = User.where("name like ?", sql).page(params[:page]).per(8)
+      @creations = Creation.where("upper(name) like upper(?) OR upper(story) like upper(?)", sql, sql).page(params[:page]).per(8)
+      @members = User.where("upper(name) like upper(?)", sql).page(params[:page]).per(8)
       # @creations = Creation.search(params[:q], :include => :user, :match_mode => :extended, :star => true).page(params[:page]).per(6)
       @search = params[:q]
     end

Commit 062730df

Commit `062730df`