aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Region/Storage
diff options
context:
space:
mode:
authorSean Dague2007-08-09 20:07:58 +0000
committerSean Dague2007-08-09 20:07:58 +0000
commitec0dc208dd87f08170041222464f6aa6c7cab0bb (patch)
tree52f8a6c675031f9ca780db7039c13f403eb121e4 /OpenSim/Region/Storage
parentsome more typos about wrong table for shapes (diff)
downloadopensim-SC_OLD-ec0dc208dd87f08170041222464f6aa6c7cab0bb.zip
opensim-SC_OLD-ec0dc208dd87f08170041222464f6aa6c7cab0bb.tar.gz
opensim-SC_OLD-ec0dc208dd87f08170041222464f6aa6c7cab0bb.tar.bz2
opensim-SC_OLD-ec0dc208dd87f08170041222464f6aa6c7cab0bb.tar.xz
build update clauses correctly
Diffstat (limited to 'OpenSim/Region/Storage')
-rw-r--r--OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs7
1 files changed, 6 insertions, 1 deletions
diff --git a/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs b/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs
index cd72f58..c2ef9a5 100644
--- a/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs
+++ b/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs
@@ -184,9 +184,14 @@ namespace OpenSim.DataStore.MonoSqliteStorage
184 private SqliteCommand createUpdateCommand(string table, string pk, Dictionary<string, DbType> defs) 184 private SqliteCommand createUpdateCommand(string table, string pk, Dictionary<string, DbType> defs)
185 { 185 {
186 string sql = "update " + table + " set "; 186 string sql = "update " + table + " set ";
187 string subsql = "";
187 foreach (string key in defs.Keys) { 188 foreach (string key in defs.Keys) {
188 sql += key + "= :" + key + ", "; 189 if (subsql.Length > 0) { //
190 subsql += ", ";
191 }
192 subsql += key + "= :" + key;
189 } 193 }
194 sql += subsql;
190 sql += " where " + pk; 195 sql += " where " + pk;
191 SqliteCommand cmd = new SqliteCommand(sql); 196 SqliteCommand cmd = new SqliteCommand(sql);
192 197