db.define_table('some',
     SQLField('name', 'string'),
     SQLField('parent', 'referece some'))

On Feb 20, 6:01 pm, Jaime Barciela <[email protected]> wrote:
> Hello all,
>
> I have not found answers for these two questions in the manual or the
> site:
>
> 1.- In a many-to-many relationship you end up with a "friendship" kind
> of table, how can you avoid duplicates in that table without defining
> a custom index?
>
> 2.- A typical -- not the only one -- implementation of a tree in a
> RDBMS is a table with a foreign key pointing to its own primary key. I
> tried something like this:
>
> db.define_table('some',
>     SQLField('name', 'string'),
>     SQLField('parent', db.some))
>
> but I get an error because db.some is not defined yet when referenced
> by 'parent'.
>
> How can you implement references to self in the DAL?
>
> Thanks!
> Jaime
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to 
[email protected]
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to