by the way, to be able in db admin
to have dropdown reference to entered records (trunk/branches)
I need to have
db.TreeStructure.parentID.requires=IS_IN_DB(db, 'TreeStructure.id')


but that is problem if I am creating the first (root) element
(as workaround I  commented out the IS_IN_DB line for this task,
or could add it in code at some init stage)

but would it be hard to make a drop-down binding, only when there are records
and leave integer box if there are none..?
I have web2py 1.56.4 (but didn't notice  in158  changelog address this issue)


On Fri, Mar 6, 2009 at 3:35 AM, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> Your suggestions works but it will not be enforced at the database
> level:
>
> I suggest instead
>
> db.define_table("TreeStructure",
>       SQLField("name", "string",notnull=True, default=None),
>       SQLField("parentID", "reference TreeStructure"))
>
> Massimo
>
> On Mar 5, 4:40 pm, DenesL <denes1...@yahoo.ca> wrote:
>> db.define_table("TreeStructure",
>>       SQLField("name", "string",notnull=True, default=None),
>>       SQLField("parentID", "integer"))
>>
>> db.TreeStructure.parentID.type="reference TreeStructure"
> >
>



-- 
Jurgis Pralgauskis
tel: 8-616 77613;
jabber: jur...@akl.lt; skype: dz0rdzas;
Don't worry, be happy and make things better ;)
http://sagemath.visiems.lt

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to 
web2py+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to