Recursive Navigation

Results 1 to 2 of 2

Thread: Recursive Navigation

  1. #1
    Join Date
    Dec 1969

    Default Recursive Navigation

    I am struggling to implement a Recursive navigation for a website which is similar to the Forum threads at this site. I have tried to use the example at however I keep getting errors ( I.e. wrong number of arguments supplied )<BR><BR>I have an SQL table structure full of main categories and subcategories as follows<BR><BR>ID (Primary key)<BR>Title ( varchar)<BR>Content ( varchar)<BR>ParentID ( this will refer to the primary key of the main category records)<BR><BR>Hope I&#039;m making sense anyway. Has anyone tackled this successfully?<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default Either change DB design...

    ...of do the recursion in VBS code after converting the recordset to an array using GetRows().<BR><BR>There is no reasonable way to do recursion via SQL alone, with only the fields you show.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts