Why db.table.reference.Field (I presume you want say
: db.table.reference.fieldname) and not just
orderby=db.table.yourFKfieldname ??
Richard
On Wed, Feb 27, 2013 at 4:17 PM, BlueShadow <kevin.bet...@gmail.com> wrote:
> Hi,
> I got two Tables lets call them table and referencedtable. table has a
> field which is a reference to referenced table. Now I like to select all
> entries from table and order them by a field in the referenced table. In my
> opinion it should work like this:
> #defauft.py
> rows=db().select(db.table.ALL, orderby=db.table.reference.Field)
>
> #db.py
>
> db.define_table('refrencedtable',
> Field('Field',length=512)
> )
>
> db.define_table('table',
> Field('Title',length=1024),
> Field('refrence',db.refrencedtable),
> Field('Test','upload')
> )
> but when I do this I get an error that referncedtable has no Field called
> Field.
>
> --
>
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
