Josh Berkus wrote:
> Chris,
>
>> Unfortunately, SQL is pretty bad at handling arbitrary-depth menus
>> (esp. without WITH RECURSIVE or CONNECT BY). Fortunately, the amount
>> of data is likely to be pretty small, so it is not too bad using
>> stored procedures.
>
> See connect_by() in tablefunc.
Chris,
> Unfortunately, SQL is pretty bad at handling arbitrary-depth menus
> (esp. without WITH RECURSIVE or CONNECT BY). Fortunately, the amount
> of data is likely to be pretty small, so it is not too bad using
> stored procedures.
See connect_by() in tablefunc. Please don't reinvent the whe
Hi all;
As part of the refactoring effort, I looking at moving the menu
handling into the database. This will allow add-on modules to add
menu items, allow system administrators to refactor menus using SQL
statements and the like.
Unfortunately, SQL is pretty bad at handling arbitrary-depth menu
http://www.tiggs.net/lsmb_resources.zip
A little later than I wanted but here's what I promised, in all it's bug
ugly, messy glory. I'll explain a little. Please bear in mind that
I've never released any code to a larger community like this so there
may be pieces/components needed that I did
