GAE ignores the select(*fields). GAE always selects all fields. You just made the case for a new mechanism to filter fields in SQLTABLE.
On Jan 27, 3:27 am, Leandro - ProfessionalIT <lsever...@gmail.com> wrote: > Hi, > I have a table (pampa_produto) with many fields (and many > records), but when I try show only two fields of this table in a page > in GAE, ever show me ALL fields of the table. > > In my controller: > myfields = [db.pampa_produto.id, db.pampa_produto.codigo, > db.pampa_produto.nome_compra] > rows = db(db.pampa_produto.id>0).select(*myfields) > > # this too show all fields > #rows = db(db.pampa_produto.id>0).select(db.pampa_produto.id, > db.pampa_produto.codigo, db.pampa_produto.nome_compra) > > items = SQLTABLE(rows) > > In my page: > {{=items}} > > Its a bug ? > > -- Leandro. -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@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.