From 316e8f92391f561d459bc6240ccd78b0a98c20c6 Mon Sep 17 00:00:00 2001
From: Diva Canto
Date: Tue, 2 Jul 2013 16:10:09 -0700
Subject: Fix SQL statement

---
 OpenSim/Data/MSSQL/MSSQLGridUserData.cs   | 2 +-
 OpenSim/Data/MySQL/MySQLGridUserData.cs   | 2 +-
 OpenSim/Data/SQLite/SQLiteGridUserData.cs | 2 +-
 3 files changed, 3 insertions(+), 3 deletions(-)

(limited to 'OpenSim/Data')

diff --git a/OpenSim/Data/MSSQL/MSSQLGridUserData.cs b/OpenSim/Data/MSSQL/MSSQLGridUserData.cs
index 7d10955..8ec8d49 100644
--- a/OpenSim/Data/MSSQL/MSSQLGridUserData.cs
+++ b/OpenSim/Data/MSSQL/MSSQLGridUserData.cs
@@ -62,7 +62,7 @@ namespace OpenSim.Data.MSSQL
 
         public GridUserData[] GetAll(string userID)
         {
-            return base.Get(String.Format("UserID LIKE {0}%", userID));
+            return base.Get(String.Format("UserID LIKE '{0}%'", userID));
         }
 
     }
diff --git a/OpenSim/Data/MySQL/MySQLGridUserData.cs b/OpenSim/Data/MySQL/MySQLGridUserData.cs
index f476fd2..00560c1 100644
--- a/OpenSim/Data/MySQL/MySQLGridUserData.cs
+++ b/OpenSim/Data/MySQL/MySQLGridUserData.cs
@@ -58,7 +58,7 @@ namespace OpenSim.Data.MySQL
 
         public GridUserData[] GetAll(string userID)
         {
-            return base.Get(String.Format("UserID LIKE {0}%", userID));
+            return base.Get(String.Format("UserID LIKE '{0}%'", userID));
         }
     }
 }
\ No newline at end of file
diff --git a/OpenSim/Data/SQLite/SQLiteGridUserData.cs b/OpenSim/Data/SQLite/SQLiteGridUserData.cs
index 799df91..d8c52f8 100644
--- a/OpenSim/Data/SQLite/SQLiteGridUserData.cs
+++ b/OpenSim/Data/SQLite/SQLiteGridUserData.cs
@@ -58,7 +58,7 @@ namespace OpenSim.Data.SQLite
 
         public GridUserData[] GetAll(string userID)
         {
-            return base.Get(String.Format("UserID LIKE {0}%", userID));
+            return base.Get(String.Format("UserID LIKE '{0}%'", userID));
         }
 
     }
-- 
cgit v1.1