Perhaps you can pack and attach a minimal app that reproduces the problem
(or at least show more code). It's still not clear where that id comes from
or what's happening to it.
Anthony
On Wednesday, August 22, 2012 9:04:24 AM UTC-4, Christian Espinoza wrote:
>
> I'm sending the id var from a user list view on this way:
>
> edit_user.html:
>
> *<a href="{{=URL('admin', 'change_membership', args=(), vars=dict(id=id,
> type='user'))}}" class="nyroModal">Change Membership</a>*
>
> edit_user.py:
>
> def edit_user():
>
> if request.vars.id:
>
> etc....
>
> return dict(form=form, id=request.vars.id)
>
> the id var come from another view when I was iterating over a query to get
> auth_user.id:
>
> but on every step, I can trace the id value, I traced it with web2py
> debugger...
>
> Maybe I'm not clear with web2py Post procedure, because all is right until
> I submit the last form, it come with the right id's
>
> If I try with a literal var number it's works without problems....
>
> Thanks in advance.
> Christian
>
> 2012/8/21 Anthony <[email protected] <javascript:>>
>
>> How is request.vars.id being set -- in the query string? What is its
>> value when the form is created, and what is the value when submitted?
>>
>> On Tuesday, August 21, 2012 7:16:18 PM UTC-4, Christian Espinoza wrote:
>>>
>>> Hi Anthony, I was try with .select().first(), but I get a error in the
>>> same way...
>>>
>>> The Error appears after I submit the form with the changes over the
>>> field, the form for a id user works, the problem is when I submit it.
>>>
>>> Thanks.
>>> Christian
>>>
>>> 2012/8/21 Anthony <[email protected]>
>>>
>>>> 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.us****er_id == request.vars.id).
>>>>> sele****ct()
>>>>> 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.u****ser_id == request.vars.id).sel****
>>>>> ect() or redirect(.....)
>>>>>
>>>>>
>>>>>
>>>>> *Bruno Cezar Rocha** - @rochacbruno*
>>>>> [email protected] | 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>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>
>>>>
>>>>
>>>>
>>>
>>> --
>>
>>
>>
>>
>
>
--
