diff options
Diffstat (limited to 'OpenSim/Framework/Data.MSSQL/MSSQLAssetData.cs')
-rw-r--r-- | OpenSim/Framework/Data.MSSQL/MSSQLAssetData.cs | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/OpenSim/Framework/Data.MSSQL/MSSQLAssetData.cs b/OpenSim/Framework/Data.MSSQL/MSSQLAssetData.cs index e933a5b..cc0422c 100644 --- a/OpenSim/Framework/Data.MSSQL/MSSQLAssetData.cs +++ b/OpenSim/Framework/Data.MSSQL/MSSQLAssetData.cs | |||
@@ -72,7 +72,7 @@ namespace OpenSim.Framework.Data.MSSQL | |||
72 | AssetBase asset = null; | 72 | AssetBase asset = null; |
73 | 73 | ||
74 | Dictionary<string, string> param = new Dictionary<string, string>(); | 74 | Dictionary<string, string> param = new Dictionary<string, string>(); |
75 | param["id"] = assetID.ToStringHyphenated(); | 75 | param["id"] = assetID.ToString(); |
76 | 76 | ||
77 | IDbCommand result = database.Query("SELECT * FROM assets WHERE id = @id", param); | 77 | IDbCommand result = database.Query("SELECT * FROM assets WHERE id = @id", param); |
78 | IDataReader reader = result.ExecuteReader(); | 78 | IDataReader reader = result.ExecuteReader(); |
@@ -105,8 +105,8 @@ namespace OpenSim.Framework.Data.MSSQL | |||
105 | { | 105 | { |
106 | 106 | ||
107 | //SqlParameter p = cmd.Parameters.Add("id", SqlDbType.NVarChar); | 107 | //SqlParameter p = cmd.Parameters.Add("id", SqlDbType.NVarChar); |
108 | //p.Value = asset.FullID.ToStringHyphenated(); | 108 | //p.Value = asset.FullID.ToString(); |
109 | cmd.Parameters.AddWithValue("id", asset.FullID.ToStringHyphenated()); | 109 | cmd.Parameters.AddWithValue("id", asset.FullID.ToString()); |
110 | cmd.Parameters.AddWithValue("name", asset.Name); | 110 | cmd.Parameters.AddWithValue("name", asset.Name); |
111 | cmd.Parameters.AddWithValue("description", asset.Description); | 111 | cmd.Parameters.AddWithValue("description", asset.Description); |
112 | SqlParameter e = cmd.Parameters.Add("assetType", SqlDbType.TinyInt); | 112 | SqlParameter e = cmd.Parameters.Add("assetType", SqlDbType.TinyInt); |
@@ -145,7 +145,7 @@ namespace OpenSim.Framework.Data.MSSQL | |||
145 | "temporary = @temporary," + | 145 | "temporary = @temporary," + |
146 | "data = @data where " + | 146 | "data = @data where " + |
147 | "id = @keyId;", database.getConnection()); | 147 | "id = @keyId;", database.getConnection()); |
148 | SqlParameter param1 = new SqlParameter("@id", asset.FullID.ToStringHyphenated()); | 148 | SqlParameter param1 = new SqlParameter("@id", asset.FullID.ToString()); |
149 | SqlParameter param2 = new SqlParameter("@name", asset.Name); | 149 | SqlParameter param2 = new SqlParameter("@name", asset.Name); |
150 | SqlParameter param3 = new SqlParameter("@description", asset.Description); | 150 | SqlParameter param3 = new SqlParameter("@description", asset.Description); |
151 | SqlParameter param4 = new SqlParameter("@assetType", asset.Type); | 151 | SqlParameter param4 = new SqlParameter("@assetType", asset.Type); |
@@ -153,7 +153,7 @@ namespace OpenSim.Framework.Data.MSSQL | |||
153 | SqlParameter param6 = new SqlParameter("@local", asset.Local); | 153 | SqlParameter param6 = new SqlParameter("@local", asset.Local); |
154 | SqlParameter param7 = new SqlParameter("@temporary", asset.Temporary); | 154 | SqlParameter param7 = new SqlParameter("@temporary", asset.Temporary); |
155 | SqlParameter param8 = new SqlParameter("@data", asset.Data); | 155 | SqlParameter param8 = new SqlParameter("@data", asset.Data); |
156 | SqlParameter param9 = new SqlParameter("@keyId", asset.FullID.ToStringHyphenated()); | 156 | SqlParameter param9 = new SqlParameter("@keyId", asset.FullID.ToString()); |
157 | command.Parameters.Add(param1); | 157 | command.Parameters.Add(param1); |
158 | command.Parameters.Add(param2); | 158 | command.Parameters.Add(param2); |
159 | command.Parameters.Add(param3); | 159 | command.Parameters.Add(param3); |
@@ -224,4 +224,4 @@ namespace OpenSim.Framework.Data.MSSQL | |||
224 | 224 | ||
225 | #endregion | 225 | #endregion |
226 | } | 226 | } |
227 | } \ No newline at end of file | 227 | } |