It cannot be done. because the same fiels in aliased tables is the
same field.
On 20 Apr, 12:15, Hans <johann.scheibelho...@easytouch-edv.com> wrote:
> Follow on question:
>
> I've defined aliases of db.table.
> When I later in the controller set db.alias1.field2.represent then it
> is applied also to db.table.field2 and ALL other alliases!
>
> How can the representation of only one specific
> db.alias1.field2.represent be set while having different ones on
> db.alias2.field2.represent, db.alias3.field2.represent and so on ?
>
> On Apr 20, 7:10 pm, Hans <johann.scheibelho...@easytouch-edv.com>
> wrote:
>
> > Thanks Massimo!
>
> > The following code worked for me
>
> > db.table.id.represent = lambda value: A(db
> > (db.table.id==value).select(db.table.field2)[0].field2,_href=URL
> > (r=request,f='update',args=value)) if len(db(db.table.id==value).select
> > (db.table.field2))>0 else A('None',_href=URL
> > (r=request,f='create',args='None'))
>
> > On Apr 20, 4:23 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
>
> > > I think you just need
>
> > > db.table.id.represent = lambda value: A(db.table
> > > [value].field2,_href=URL(r=request,f='edit',args=value))
>
> > > On 20 Apr, 08:55, Hans <johann.scheibelho...@easytouch-edv.com> wrote:
>
> > > > The repesent code below produces following A title output:
> > > > 'table.field2 123.456' if the field2 value is 123.456 and
> > > > 'table.field2' if the field2 value is None
>
> > > > What I want to achieve is following A title output:
> > > > '123.456' if the field2 value is 123.456 and
> > > > 'None' if the field2 value is None
>
> > > > How can this be achieved?
>
> > > > Thanks,
> > > > Hans
>
> > > > db.table.id.represent = lambda value: A('%s' % (db
> > > > (db.table.id==value).select(db.table.field2)),_href=URL
> > > > (r=request,f='edit',args=value))
>
> > > > records=SQLTABLE(db(query).select(
> > > > db.table2.code,
> > > > db.table3.code,
> > > > db.table.id,
> > > > left=[db.table2.on(rows_table2),
> > > > db.table3.on(rows_table3),
> > > > db.table.on(rows_table)
> > > > ],
> > > > orderby=db.table3.code|db.table2.code),
> > > > headers=headers
> > > > )
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
