diff options
author | Melanie Thielker | 2008-09-02 13:43:49 +0000 |
---|---|---|
committer | Melanie Thielker | 2008-09-02 13:43:49 +0000 |
commit | 930b2ec602488f1f05e80cb32d6168e071802d7b (patch) | |
tree | 7bdc5eaf4d02ce11dd1c613a598dbc4fc3202bb9 /OpenSim/Data/MSSQL/MSSQLRegionData.cs | |
parent | Fix and reactivate the unit tests on the XEngine (diff) | |
download | opensim-SC-930b2ec602488f1f05e80cb32d6168e071802d7b.zip opensim-SC-930b2ec602488f1f05e80cb32d6168e071802d7b.tar.gz opensim-SC-930b2ec602488f1f05e80cb32d6168e071802d7b.tar.bz2 opensim-SC-930b2ec602488f1f05e80cb32d6168e071802d7b.tar.xz |
Mantis #2102
Thank you, RuudL, for a patch that supplements the previous MSSQL
patch.
Diffstat (limited to 'OpenSim/Data/MSSQL/MSSQLRegionData.cs')
-rw-r--r-- | OpenSim/Data/MSSQL/MSSQLRegionData.cs | 3 |
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 | ||