Hi,
I'm using a nested repeater to build js dhtml menu from two tables in MS
SQL.
Two fold question:
1) This looks like it is going to work well but is there a better way?
2) The submenus have a sequence column in the table, and the js script I
have to write has the items numbered as well. It doesn't matter if I skip
numbers for the js to work, but they do have to be in order. I am using a SP
to pull the data from the table, and can pull the sequence number along with
it, of course. However, I learned by trying that I cannot put an 'order by'
addendum to the Select statement in an SP.
Can someone tell me how to ensure that the menu items are streamed to the
html page in order?
My SP for the sub items:
ALTER proc GetSubs
@ModuleName varchar(100)
As
select SubNavName, SubNavURL, MainNavID, Sequence
from SubNav
where MainNavID in
(Select NavID
from MainNav
where Module = @ModuleName)
(The parent and child repeaters have a relationship
SubNav.MainNavID = MainNav.NavID)
Thanks,
Mike
---
You are currently subscribed to dotnet as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
---------
Administrated by 15 Seconds : http://www.15Seconds.com
List Archives/Search : http://local.15Seconds.com/search
Subscription Information : http://www.15seconds.com/listserv.htm
Advertising Information: http://www.internet.com/mediakit/
