You could also try using $xwiki.sort to sort the spaces.
I think the syntax is:
#set($spacesSorted=$xwiki.sort($xwiki.spaces) )
Then, you can use foreach to loop through as normal using the variable instead:
#foreach($space in $spacesSorted)
* $space
#end
-----Original Message-----
From: users-bounces(a)xwiki.org [mailto:users-bounces@xwiki.org] On Behalf Of Mihails
Agafonovs
Sent: 01 July 2008 09:49
To: users(a)xwiki.org
Subject: [xwiki-users] XWiki Spaces
Hi!
What is the SQL query to get all XWiki spaces? I need this to get them sorted, because
$xwiki.spaces doesn't sort spaces by name.
Ar cieņu, Mihails
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users