aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite
diff options
context:
space:
mode:
authorSean Dague2007-11-14 15:52:39 +0000
committerSean Dague2007-11-14 15:52:39 +0000
commit02b6f6ca62a970788c914aab45572e45f37fbd7a (patch)
tree98296deba5115d7c96e8489478403f81272c9757 /OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite
parentfurther adventures in .NET workarounds (diff)
downloadopensim-SC-02b6f6ca62a970788c914aab45572e45f37fbd7a.zip
opensim-SC-02b6f6ca62a970788c914aab45572e45f37fbd7a.tar.gz
opensim-SC-02b6f6ca62a970788c914aab45572e45f37fbd7a.tar.bz2
opensim-SC-02b6f6ca62a970788c914aab45572e45f37fbd7a.tar.xz
get rid of parametrized query, in case this is the .NET issue (I hope not)
Diffstat (limited to 'OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite')
-rw-r--r--OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs10
1 files changed, 5 insertions, 5 deletions
diff --git a/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs b/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs
index 7d96e55..f2db41c 100644
--- a/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs
+++ b/OpenSim/Region/Storage/OpenSim.DataStore.MonoSqlite/MonoSqliteDataStore.cs
@@ -269,15 +269,15 @@ namespace OpenSim.DataStore.MonoSqlite
269 double[,] terret = new double[256,256]; 269 double[,] terret = new double[256,256];
270 terret.Initialize(); 270 terret.Initialize();
271 String sql = "select RegionUUID, Revision, Heightfield from terrain" + 271 String sql = "select RegionUUID, Revision, Heightfield from terrain" +
272 " where RegionUUID=:RegionUUID order by Revision desc limit 1"; 272 " where RegionUUID='" + regionID.ToString() + "' order by Revision desc limit 1";
273 273
274 using (IDbCommand cmd = conn.CreateCommand()) 274 using (IDbCommand cmd = conn.CreateCommand())
275 { 275 {
276 cmd.CommandText = sql; 276 cmd.CommandText = sql;
277 SqliteParameter param = new SqliteParameter(":RegionUUID", regionID.ToString()); 277 // SqliteParameter param = new SqliteParameter(":RegionUUID", regionID.ToString());
278 param.SourceColumn = "RegionUUID"; 278// param.SourceColumn = "RegionUUID";
279 param.SourceVersion = DataRowVersion.Current; 279// param.SourceVersion = DataRowVersion.Current;
280 cmd.Parameters.Add(param); 280// cmd.Parameters.Add(param);
281 281
282 using (IDataReader row = cmd.ExecuteReader()) 282 using (IDataReader row = cmd.ExecuteReader())
283 { 283 {