Hi Simon
I found that the best way of getting the data out of the table was to use a
WITH RECURSIVE query. Hope that is of interest.
Regards, D
On Tuesday, April 3, 2012 1:21:12 AM UTC+1, Simon Ashley wrote:
>
> Pretty new to this and stumbling a little.
> We need to generate a Treeview structure with the bottom node ending with
> some links to other pages (graphs etc)
>
> Have a 7 level deep structure (each level in a different table) with each
> level have a table format simple to the following:
> db.define_table('node', Field('parent',db.parent), Field('node_name'))
> Tables will be maintained using smartgrid
>
> The intention is to use jsTree or similiar loaded/ rendered from a JSON
> response.
> (structure could get big so may need to look at some dynamic loading)
>
> Was wondering if there is some sample code/ app that some one is will to
> share to shed some light on which way to go?
> (have looked at sqlabs but that's not giving us the fuller picture)
>
> TIA
>
--
