Re: [web2py] Re: DAL db.table.field.contains

2013-11-22 Thread Richard Vézina
:) On Fri, Nov 22, 2013 at 10:20 AM, Kevin Bethke wrote: > thats why. > thanks richard for your solution it works perfectly. > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py

Re: [web2py] Re: DAL db.table.field.contains

2013-11-22 Thread Kevin Bethke
thats why. thanks richard for your solution it works perfectly. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are

Re: [web2py] Re: DAL db.table.field.contains

2013-11-22 Thread Richard Vézina
I guess because his Author reference field is of type list:reference ?! Richard On Thu, Nov 21, 2013 at 3:12 PM, Niphlod wrote: > why contains instead of == ? > db(db.Book.Author == Author.id).select(db.Book.ALL, orderby=db.Book.Name) > > > On Thursday, November 21, 2013 4:31:53 PM UTC+1, Rich

Re: [web2py] Re: DAL db.table.field.contains

2013-11-21 Thread Niphlod
why contains instead of == ? db(db.Book.Author == Author.id).select(db.Book.ALL, orderby=db.Book.Name) On Thursday, November 21, 2013 4:31:53 PM UTC+1, Richard wrote: > > Ok, figured out, I think, what happen is that you use index to get record > in l (that actually is a pretty bad variable name

Re: [web2py] Re: DAL db.table.field.contains

2013-11-21 Thread Richard Vézina
Ok, figured out, I think, what happen is that you use index to get record in l (that actually is a pretty bad variable name since it could be confused with 1 - ONE with some fonts)... By using an index you always get only the first row in rows because your "l" variable is a rows object that contain

[web2py] Re: DAL db.table.field.contains

2013-11-21 Thread BlueShadow
def Authors(): AL=db().select(db.Author.ALL, orderby=db.Author.Name) TheList=[] for Author in AL: l=db(db.Book.Author.contains(Author.id)).select(db.Book.ALL, orderby =db.Book.Name) if len(l)>0: TheList.append([l[0]]) else: TheList.append(