I think I understand it. Well I will just use it =]. Thanks for the fast help and reply s!
On 1 aug, 18:08, mdipierro <[email protected]> wrote: > On Aug 1, 10:41 am, Pynthon <[email protected]> wrote: > > > 1. =] Nice! But watch this query: > > > db( db.leden.info == 'Hans' ).select( db.leden.id, db.leden.naam ) > > > It still give me no error so if I enter a where clause the DAL will > > get all the fields? > > No. only the fields you asked (id, naam) > > > 2. You mean if you don't use [0] this will be the output > > > output = [1, 'name', 'info'] And to get it nice you need to use [0]? > > The output will contain a Rows object with a single item matching the > query. The element [0] is a Storage object. So > > rows=db( db.leden.info == 'Hans' ).select( db.leden.id, > db.leden.naam ) > if rows: # if found > row=rows[0] > print row.id, row.naam --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
