aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLRegionData.cs
diff options
context:
space:
mode:
authorMelanie Thielker2008-09-02 13:43:49 +0000
committerMelanie Thielker2008-09-02 13:43:49 +0000
commit930b2ec602488f1f05e80cb32d6168e071802d7b (patch)
tree7bdc5eaf4d02ce11dd1c613a598dbc4fc3202bb9 /OpenSim/Data/MSSQL/MSSQLRegionData.cs
parentFix and reactivate the unit tests on the XEngine (diff)
downloadopensim-SC_OLD-930b2ec602488f1f05e80cb32d6168e071802d7b.zip
opensim-SC_OLD-930b2ec602488f1f05e80cb32d6168e071802d7b.tar.gz
opensim-SC_OLD-930b2ec602488f1f05e80cb32d6168e071802d7b.tar.bz2
opensim-SC_OLD-930b2ec602488f1f05e80cb32d6168e071802d7b.tar.xz
Mantis #2102
Thank you, RuudL, for a patch that supplements the previous MSSQL patch.
Diffstat (limited to '')
-rw-r--r--OpenSim/Data/MSSQL/MSSQLRegionData.cs3
1 files changed, 2 insertions, 1 deletions
diff --git a/OpenSim/Data/MSSQL/MSSQLRegionData.cs b/OpenSim/Data/MSSQL/MSSQLRegionData.cs
index 7af3e7e..e26b03d 100644
--- a/OpenSim/Data/MSSQL/MSSQLRegionData.cs
+++ b/OpenSim/Data/MSSQL/MSSQLRegionData.cs
@@ -644,7 +644,7 @@ VALUES
644 RegionSettings regionSettings; 644 RegionSettings regionSettings;
645 using (AutoClosingSqlCommand cmd = _Database.Query(sql)) 645 using (AutoClosingSqlCommand cmd = _Database.Query(sql))
646 { 646 {
647 cmd.Parameters.AddWithValue("@regionUUID", regionUUID.ToString()); 647 cmd.Parameters.Add(_Database.CreateParameter("@regionUUID", regionUUID.ToString()));
648 using(SqlDataReader reader = cmd.ExecuteReader()) 648 using(SqlDataReader reader = cmd.ExecuteReader())
649 { 649 {
650 if (reader.Read()) 650 if (reader.Read())
@@ -678,6 +678,7 @@ VALUES
678 string regionUUID = null; 678 string regionUUID = null;
679 using (AutoClosingSqlCommand cmd = _Database.Query("SELECT regionUUID FROM regionsettings WHERE regionUUID = @regionUUID")) 679 using (AutoClosingSqlCommand cmd = _Database.Query("SELECT regionUUID FROM regionsettings WHERE regionUUID = @regionUUID"))
680 { 680 {
681 cmd.Parameters.Add(_Database.CreateParameter("@regionUUID", regionSettings.RegionUUID));
681 regionUUID = cmd.ExecuteScalar().ToString(); 682 regionUUID = cmd.ExecuteScalar().ToString();
682 } 683 }
683 684