diff options
| author | francis <francis> | 2008-07-28 17:59:40 +0000 |
|---|---|---|
| committer | francis <francis> | 2008-07-28 17:59:40 +0000 |
| commit | 0a9ea20e7501ac0c4b7b518de7226a72da019edd (patch) | |
| tree | 14099c149d8cc3c88a244825533096c46eed19c7 /app/controllers/admin_public_body_controller.rb | |
| parent | eb1a96628ed541f778a7c4cbcd56246f3ee56925 (diff) | |
ILIKE is not in the SQL standard, but is a PostgreSQL extension. Stop using it.
Diffstat (limited to 'app/controllers/admin_public_body_controller.rb')
| -rw-r--r-- | app/controllers/admin_public_body_controller.rb | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/app/controllers/admin_public_body_controller.rb b/app/controllers/admin_public_body_controller.rb index b0cdcac78..0c3b5cb8b 100644 --- a/app/controllers/admin_public_body_controller.rb +++ b/app/controllers/admin_public_body_controller.rb @@ -4,7 +4,7 @@ # Copyright (c) 2007 UK Citizens Online Democracy. All rights reserved. # Email: francis@mysociety.org; WWW: http://www.mysociety.org/ # -# $Id: admin_public_body_controller.rb,v 1.15 2008-05-26 12:25:36 francis Exp $ +# $Id: admin_public_body_controller.rb,v 1.16 2008-07-28 17:59:40 francis Exp $ class AdminPublicBodyController < ApplicationController layout "admin" @@ -18,9 +18,9 @@ class AdminPublicBodyController < ApplicationController def list @query = params[:query] @public_bodies = PublicBody.paginate :order => "name", :page => params[:page], :per_page => 100, - :conditions => @query.nil? ? nil : ["name ilike '%'||?||'%' or - short_name ilike '%'||?||'%' or - request_email ilike '%'||?||'%'", @query, @query, @query] + :conditions => @query.nil? ? nil : ["lower(name) = lower('%'||?||'%') or + lower(short_name) = lower('%'||?||'%') or + lower(request_email) = lower('%'||?||'%')", @query, @query, @query] @public_bodies_by_tag = PublicBody.find_by_tag(@query) end |