SQL Site Map Sort Order

tmueller@teewebco.com

Guest

Posts: n/a

25th Sep 2006

Hello,

Has anyone figured out a way to change the sort order of the SiteMap
stored in SQL Server?

Currently it sorts by the ID but if say Home is 20 and About Us is 5,
About us display first. I tried adding sort order to the table and the
query works corretly but the Provider chokes on an invalid key because
the parents get switched around.

« using lock | Semi-Serialization »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change Site sort order in Site/Open dialog ?	+Bob+	Microsoft Frontpage	3	3rd Oct 2007 03:16 AM
Sort order and seconday sort order	=?Utf-8?B?Y29saW4=?=	Microsoft Access Queries	1	5th Apr 2007 04:28 PM
Sort Site Map Nodes	=?Utf-8?B?VG90eSBTYW50YW5h?=	Microsoft ASP .NET	0	17th Nov 2006 05:55 AM
Is it a good idea to put a site map on a site?	Johny	Microsoft Frontpage	2	5th Feb 2005 03:21 PM
SQL Query ORDER BY Sort Order (Variable)	TRB_NV	Microsoft Access Queries	3	19th Nov 2003 08:07 PM