From 9937b32d7394e77fa89915b66f9645024ccb2009 Mon Sep 17 00:00:00 2001
From: "Ira W. Snyder" <devel@irasnyder.com>
Date: Thu, 22 Nov 2007 10:38:15 -0800
Subject: [PATCH] Use LIKE queries in the searches

Signed-off-by: Ira W. Snyder <devel@irasnyder.com>
---
 app/controllers/customer_controller.rb |   2 +-
 app/controllers/game_controller.rb     |   2 +-
 app/controllers/video_controller.rb    |   2 +-
 db/development.sqlite3                 | Bin 9216 -> 9216 bytes
 4 files changed, 3 insertions(+), 3 deletions(-)

diff --git a/app/controllers/customer_controller.rb b/app/controllers/customer_controller.rb
index d741644..9aba977 100644
--- a/app/controllers/customer_controller.rb
+++ b/app/controllers/customer_controller.rb
@@ -55,6 +55,6 @@ class CustomerController < ApplicationController
 
   def searchresults
     query = params[:q]
-    @customers = Customer.find(:all, :conditions => ["name = ?", query])
+    @customers = Customer.find(:all, :conditions => ["name like ?", query[0]+"%"] )
   end
 end
diff --git a/app/controllers/game_controller.rb b/app/controllers/game_controller.rb
index 39f5485..42a037e 100644
--- a/app/controllers/game_controller.rb
+++ b/app/controllers/game_controller.rb
@@ -55,6 +55,6 @@ class GameController < ApplicationController
 
   def searchresults
     query = params[:q]
-    @games = Game.find(:all, :conditions => ["title = ?", query])
+    @games = Game.find(:all, :conditions => ["title like ?", query[0]+"%"])
   end
 end
diff --git a/app/controllers/video_controller.rb b/app/controllers/video_controller.rb
index bf283ef..31575d8 100644
--- a/app/controllers/video_controller.rb
+++ b/app/controllers/video_controller.rb
@@ -55,6 +55,6 @@ class VideoController < ApplicationController
 
   def searchresults
     query = params[:q]
-    @videos = Video.find(:all, :conditions => ["title = ?", query])
+    @videos = Video.find(:all, :conditions => ["title like ?", query[0]+"%"])
   end
 end
diff --git a/db/development.sqlite3 b/db/development.sqlite3
index 7673ae7b7a5d46d7124caef9a5c3c122d714a840..ce0b240afc515137a5ba9e0340b4d186f9d6503b 100644
GIT binary patch
delta 117
zcmZqhXz-XI&3JL6%nNodW~Sc^Ouw0zGG}gVe9JWXH&;}ExMHZeDx*tco<eY5WlCz1
ziLtqY6*D`7sHG}cI6W~xwUn0&oy@ItNX<>m%+X8E&owkM)-^UU)ipIUw_w=3lsj4i
E0G>7@vj6}9

delta 62
zcmV-E0Kxx&NPtL?8v)R<9OwrK0s{L00{a7{v4QUbllux<15+VYldB6I4<Jx%VPj=(
UbZKEMAVWbQli3R)v!x4L7|0YA+5i9m

-- 
2.25.1