Thanks Savio, I created a clean app to test this out and it works
great. Regards. >Jeff
On Jan 14, 12:28 pm, Savio Sabino <savi...@gmail.com> wrote:
> Hi, the follow model is rigth to crud:
>
> db.define_table('category',iObj,
> Field('parent','reference category'),
> Field('name'),
> format='%(name)s')
> db.category.parent.requires = IS_EMPTY_OR(IS_IN_DB(db,
> db.category.id, '%(name)s'))
> db.category.name.requires = IS_NOT_IN_DB(db, db.category.name)
>
> No need of a custom crud.
>
> On 12 jan, 18:53, SaltyCow <jeff.bienkow...@gmail.com> wrote:
>
>
>
>
>
>
>
> > Hello there...
>
> > I'm hoping that this is a common problem with a simple solution.
>
> > I'm attempting to create an app that uses self-referencing tables, in
> > one case to refer to employees and their managers (who themselves are
> > also employees). I used the app wizard to generate the scaffolding. I
> > am able to add records, but the boilerplate crud read and crud select
> > functions return the following error: Using a recursive select, but
> > encountered a broken reference. Also, the form generated by the crud
> > create function does not generate a drop-down selection box as it
> > normally would for a reference field.
>
> > So, my question is, really, do I need to write custom crud functions
> > to work with self-referencing tables and, if so, does anyone know the
> > best way to do this? I've read the part in the docs about using
> > "with_alias" but I can't seem to make heads or tails of it. (Not a
> > problem with the manual, just my limited knowledge of SQL.)
>
> > I'd appreciate any further direction anyone can give me.
>
> > Thanks...>Jeff
