From ee73d72f1df4773ce08c14e64d157b836671e6d9 Mon Sep 17 00:00:00 2001 From: Justin Clarke Casey Date: Mon, 9 Mar 2009 18:04:23 +0000 Subject: * 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 --- OpenSim/Data/MSSQL/MSSQLAssetData.cs | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'OpenSim/Data/MSSQL/MSSQLAssetData.cs') 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 { List retList = new List(count); - using (AutoClosingSqlCommand command = database.Query("SELECT name,description,assetType,temporary,id FROM assets LIMIT @start, @count")) + 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")) { command.Parameters.Add(database.CreateParameter("start", start)); command.Parameters.Add(database.CreateParameter("count", count)); -- cgit v1.1