Also, note the .select().first() returns the first row or None if there are no results, so you don't have to test whether there are any records before selecting the first row.
Anthony On Tuesday, August 21, 2012 6:58:47 PM UTC-4, rochacbruno wrote: > > You are getting an empty rows object > > > def change_membership(): > > if request.vars.id: > > row = db(db.auth_membership.user_id == request.vars.id).select() > if not row: > redirect(.........) > id = row[0].id > form = SQLFORM(db.auth_membership, > id, > fields=['group_id'], > _action=URL() > ) > if form.process().accepted: > ...redirect back to user list > > if form.errors: > response.flash = 'form has errors' > > return dict(form=form) > > also can be done with > > row = db(db.auth_membership.user_id == request.vars.id).select() or > redirect(.....) > > > > *Bruno Cezar Rocha** - @rochacbruno* > [email protected] <javascript:> | Mobile: +55 (11) 99210-8821 > www.CursoDePython.com.br | www.rochacbruno.com.br > Blog: WEB APPS THAT WORTH A > TRY<http://rochacbruno.com.br/web-apps-that-worth-a-try/> > Get a signature like this. > <http://r1.wisestamp.com/r/landing?promo=18&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_18> > Click > here.<http://r1.wisestamp.com/r/landing?promo=18&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_18> > > > > --
