Please add an OrderID column (or something) that allows user control over the return result set.
Example insert sets:
Code: Select all
truncate table aspnet_sitemap;
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (1, '/EPIC', 'Default.aspx', 'Main', 'Home Page', NULL, NULL);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (25, '/EPIC', 'Dashboards/Default.aspx', 'Dashboards', 'Summary Pages for various roles.', NULL, 1);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (50, '/EPIC', 'Wizards/Default.aspx', 'Wizards', 'Wizards Menu Top Level', NULL, 1);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (100, '/EPIC', 'Help/Default.aspx', 'Help', 'Help Main Menu', NULL, 1);
COMMIT;
Code: Select all
truncate table aspnet_sitemap;
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (1, '/EPIC', 'Default.aspx', 'Main', 'Home Page', NULL, NULL);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (25, '/EPIC', 'Dashboards/Default.aspx', 'Dashboards', 'Summary Pages for various roles.', NULL, 1);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (100, '/EPIC', 'Help/Default.aspx', 'Help', 'Help Main Menu', NULL, 1);
Insert into ASPNET_SITEMAP (NODEID, APPLICATIONNAME, URL, NAME, DESCRIPTION, ROLES, PARENTNODEID) Values (50, '/EPIC', 'Wizards/Default.aspx', 'Wizards', 'Wizards Menu Top Level', NULL, 1);
COMMIT;