Does anyone have an idea to display the categories in non-
alphabetical order?
The "Using Microsoft Sharepoint Portal Server" p. 111 says that the
categories are stored in SPS in the order that they are created. I
think that it has been changed since the book has been published
since the categories on my portal display in alphabetical order.
I think that the SQL query option "ORDER BY DAV:displayname" is the
one that creates the collection ordered by name. I don't know what
other option we could use. I was thinking about adding a number
keyword that would be the order for the display and change the SQL
query... Anyone who could help here?
"
strTopCategoriesSqlQuery = _
" SELECT " & vbCRLF & _
" ""DAV:href"", ""DAV:displayname"", ""DAV:contentclass""
, ""urn:schemas-microsoft-com:office:office#Description"" " & vbCRLF
& _
" FROM SCOPE('SHALLOW TRAVERSAL OF ""/" & GetWorkspaceName
() & "/" & GetWorkspacePropertyByUri(g_cdostrURI_CategoriesFolder) &
strCategoryPath & """')" & vbCRLF & _
" WHERE ""DAV:contentclass"" = 'urn:content-
classes:categoryfolder'" & vbCRLF & _
" ORDER BY ""DAV:displayname"" ASC" & vbCRLF