diff options
| author | Diva Canto | 2013-07-02 16:10:09 -0700 |
|---|---|---|
| committer | Diva Canto | 2013-07-02 16:10:09 -0700 |
| commit | 316e8f92391f561d459bc6240ccd78b0a98c20c6 (patch) | |
| tree | 4934f596fd528c3ebea938b96b6a2e9edd590496 | |
| parent | Do the same for SQLite and MSSQL (diff) | |
| download | opensim-SC_OLD-316e8f92391f561d459bc6240ccd78b0a98c20c6.zip opensim-SC_OLD-316e8f92391f561d459bc6240ccd78b0a98c20c6.tar.gz opensim-SC_OLD-316e8f92391f561d459bc6240ccd78b0a98c20c6.tar.bz2 opensim-SC_OLD-316e8f92391f561d459bc6240ccd78b0a98c20c6.tar.xz | |
Fix SQL statement
| -rw-r--r-- | OpenSim/Data/MSSQL/MSSQLGridUserData.cs | 2 | ||||
| -rw-r--r-- | OpenSim/Data/MySQL/MySQLGridUserData.cs | 2 | ||||
| -rw-r--r-- | OpenSim/Data/SQLite/SQLiteGridUserData.cs | 2 |
3 files changed, 3 insertions, 3 deletions
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 | |||
| 62 | 62 | ||
| 63 | public GridUserData[] GetAll(string userID) | 63 | public GridUserData[] GetAll(string userID) |
| 64 | { | 64 | { |
| 65 | return base.Get(String.Format("UserID LIKE {0}%", userID)); | 65 | return base.Get(String.Format("UserID LIKE '{0}%'", userID)); |
| 66 | } | 66 | } |
| 67 | 67 | ||
| 68 | } | 68 | } |
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 | |||
| 58 | 58 | ||
| 59 | public GridUserData[] GetAll(string userID) | 59 | public GridUserData[] GetAll(string userID) |
| 60 | { | 60 | { |
| 61 | return base.Get(String.Format("UserID LIKE {0}%", userID)); | 61 | return base.Get(String.Format("UserID LIKE '{0}%'", userID)); |
| 62 | } | 62 | } |
| 63 | } | 63 | } |
| 64 | } \ No newline at end of file | 64 | } \ 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 | |||
| 58 | 58 | ||
| 59 | public GridUserData[] GetAll(string userID) | 59 | public GridUserData[] GetAll(string userID) |
| 60 | { | 60 | { |
| 61 | return base.Get(String.Format("UserID LIKE {0}%", userID)); | 61 | return base.Get(String.Format("UserID LIKE '{0}%'", userID)); |
| 62 | } | 62 | } |
| 63 | 63 | ||
| 64 | } | 64 | } |