aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MSSQL/MSSQLAssetData.cs
diff options
context:
space:
mode:
authorJustin Clarke Casey2009-03-09 18:04:23 +0000
committerJustin Clarke Casey2009-03-09 18:04:23 +0000
commitee73d72f1df4773ce08c14e64d157b836671e6d9 (patch)
treef49d6c7955372f4bc9284d7807743e19cbf5f3a5 /OpenSim/Data/MSSQL/MSSQLAssetData.cs
parent* Address http://opensimulator.org/mantis/view.php?id=3207 (diff)
downloadopensim-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.cs2
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));