aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLGenericTableHandler.cs
diff options
context:
space:
mode:
authorJustin Clark-Casey (justincc)2010-03-12 17:58:25 +0000
committerJustin Clark-Casey (justincc)2010-03-12 17:58:25 +0000
commitdb61d66e746df4b1919b031de72bee7cf3a796f3 (patch)
tree770a8101a52222f87f298de79fabbd4aad176333 /OpenSim/Data/MSSQL/MSSQLGenericTableHandler.cs
parentminor: add some more documentation for IHttpServer.AddHTTPHandler() to tell t... (diff)
parentChanged some properties and methods from private to protected in LLLoginRespo... (diff)
downloadopensim-SC-db61d66e746df4b1919b031de72bee7cf3a796f3.zip
opensim-SC-db61d66e746df4b1919b031de72bee7cf3a796f3.tar.gz
opensim-SC-db61d66e746df4b1919b031de72bee7cf3a796f3.tar.bz2
opensim-SC-db61d66e746df4b1919b031de72bee7cf3a796f3.tar.xz
Merge branch 'master' of ssh://justincc@opensimulator.org/var/git/opensim
Diffstat (limited to 'OpenSim/Data/MSSQL/MSSQLGenericTableHandler.cs')
-rw-r--r--OpenSim/Data/MSSQL/MSSQLGenericTableHandler.cs6
1 files changed, 3 insertions, 3 deletions
diff --git a/OpenSim/Data/MSSQL/MSSQLGenericTableHandler.cs b/OpenSim/Data/MSSQL/MSSQLGenericTableHandler.cs
index 506056d..904366e 100644
--- a/OpenSim/Data/MSSQL/MSSQLGenericTableHandler.cs
+++ b/OpenSim/Data/MSSQL/MSSQLGenericTableHandler.cs
@@ -110,7 +110,7 @@ namespace OpenSim.Data.MSSQL
110 { 110 {
111 List<string> constraints = new List<string>(); 111 List<string> constraints = new List<string>();
112 string query = string.Format(@"SELECT 112 string query = string.Format(@"SELECT
113 COL_NAME(ic.object_id,ic.column_id) AS column_name 113 COL_NAME(ic.object_id,ic.column_id) AS column_name
114 FROM sys.indexes AS i 114 FROM sys.indexes AS i
115 INNER JOIN sys.index_columns AS ic 115 INNER JOIN sys.index_columns AS ic
116 ON i.object_id = ic.object_id AND i.index_id = ic.index_id 116 ON i.object_id = ic.object_id AND i.index_id = ic.index_id
@@ -157,7 +157,7 @@ namespace OpenSim.Data.MSSQL
157 string where = String.Join(" AND ", terms.ToArray()); 157 string where = String.Join(" AND ", terms.ToArray());
158 158
159 string query = String.Format("SELECT * FROM {0} WHERE {1}", 159 string query = String.Format("SELECT * FROM {0} WHERE {1}",
160 m_Realm, where); 160 m_Realm, where);
161 161
162 cmd.Connection = conn; 162 cmd.Connection = conn;
163 cmd.CommandText = query; 163 cmd.CommandText = query;
@@ -296,7 +296,7 @@ namespace OpenSim.Data.MSSQL
296 query.AppendFormat("[{0}] = {1} ", names[i], values[i]); 296 query.AppendFormat("[{0}] = {1} ", names[i], values[i]);
297 if (constraints.Count > 0) 297 if (constraints.Count > 0)
298 { 298 {
299 List<string> terms = new List<string>(); 299 List<string> terms = new List<string>();
300 for (int j = 0; j < constraints.Count; j++) 300 for (int j = 0; j < constraints.Count; j++)
301 { 301 {
302 terms.Add(" [" + constraints[j].Key + "] = @" + constraints[j].Key); 302 terms.Add(" [" + constraints[j].Key + "] = @" + constraints[j].Key);