diff options
author | Justin Clarke Casey | 2009-03-09 18:04:23 +0000 |
---|---|---|
committer | Justin Clarke Casey | 2009-03-09 18:04:23 +0000 |
commit | ee73d72f1df4773ce08c14e64d157b836671e6d9 (patch) | |
tree | f49d6c7955372f4bc9284d7807743e19cbf5f3a5 /OpenSim/Data/MSSQL/MSSQLAssetData.cs | |
parent | * Address http://opensimulator.org/mantis/view.php?id=3207 (diff) | |
download | opensim-SC-ee73d72f1df4773ce08c14e64d157b836671e6d9.zip opensim-SC-ee73d72f1df4773ce08c14e64d157b836671e6d9.tar.gz opensim-SC-ee73d72f1df4773ce08c14e64d157b836671e6d9.tar.bz2 opensim-SC-ee73d72f1df4773ce08c14e64d157b836671e6d9.tar.xz |
* Apply http://opensimulator.org/mantis/view.php?id=3280
* Some small syntax and refactoring tweaks for asset and inventory MSSQL
* This means the MSSQL db plugin now requires SQL Server 2005
Diffstat (limited to 'OpenSim/Data/MSSQL/MSSQLAssetData.cs')
-rw-r--r-- | OpenSim/Data/MSSQL/MSSQLAssetData.cs | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/OpenSim/Data/MSSQL/MSSQLAssetData.cs b/OpenSim/Data/MSSQL/MSSQLAssetData.cs index edacf08..54578bc 100644 --- a/OpenSim/Data/MSSQL/MSSQLAssetData.cs +++ b/OpenSim/Data/MSSQL/MSSQLAssetData.cs | |||
@@ -258,7 +258,7 @@ namespace OpenSim.Data.MSSQL | |||
258 | { | 258 | { |
259 | List<AssetMetadata> retList = new List<AssetMetadata>(count); | 259 | List<AssetMetadata> retList = new List<AssetMetadata>(count); |
260 | 260 | ||
261 | using (AutoClosingSqlCommand command = database.Query("SELECT name,description,assetType,temporary,id FROM assets LIMIT @start, @count")) | 261 | using (AutoClosingSqlCommand command = database.Query("SELECT (name,description,assetType,temporary,id), Row = ROW_NUMBER() OVER (ORDER BY (some column to order by)) WHERE Row >= @Start AND Row < @Start + @Count")) |
262 | { | 262 | { |
263 | command.Parameters.Add(database.CreateParameter("start", start)); | 263 | command.Parameters.Add(database.CreateParameter("start", start)); |
264 | command.Parameters.Add(database.CreateParameter("count", count)); | 264 | command.Parameters.Add(database.CreateParameter("count", count)); |