How can i use Filter property of the Recordset to create an unodered list then?
My recordset
| ID | ParentID | Category |
1 0 Category 1
2 0 Category 2
3 0 Category 3
4 1 Category 1.1
5 1 Category 1.2
6 4...
Dim page
page = CInt(Request.QueryString("PageID"))
If page < 2 OR page > 17 Then
Response.redirect("page_error.asp")
Else
Response.Redirect(URL)
End
Something like that maybe?
Sorry my code...
This row: If CStr(category_array(categoryID, iRowLoop)) = CStr(nodID) Then
Should be: If CStr(category_array(parentCategoryID, iRowLoop)) = CStr(nodID) Then
Hi thanks for trying to help me.
I'll try to explain a little bit better.
I have a database table that stores categories like this example.
| ID | ParentID | Category |
1 0 Category 1
2 0 Category 2
3 0 Category 3
4 1 Category 1.1
5...
I have a dababase table with the following setup
| ID | ParentID | Category |
I Create a recordset and then an array using getRows()
' Create recordset
Set rsMenu = Server.CreateObject("ADODB.Recordset")
rsMenu.ActiveConnection = cnn
rsMenu.Source = "SELECT categoryID, ParentID, Category FROM...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.