Sorry forgot to add .iteritems(): this is the most updated version.
On Monday, May 5, 2014 10:01:46 AM UTC-4, LoveWeb2py wrote:
>
> Hi Richard,
>
> Here is what I have so far:
>
> Controllers:
> def user_list():
> grid=SQLFORM.smartgrid(db.users, paginate=20, links_placement='left',
> _href=URL('transition_form', vars=dict((f, row[f]) for f in
> db.users.fields))))], user_signature=True)
> return dict(grid=grid)
>
> def transition_form():
> for f, v in request.vars.iteritems():
> db.table[f].default = v
> form = SQLFORM(db.table, user_signature=True)
> return dict(form=form)
>
> View:
> user_list.html
> {{=form}}
>
> This properly populates the values. but it isn't submitting properly.
> After the form submits I would like it to return to the database and show
> me the user that was just added. Also, I set my database to autoincrement
> the ID which should solve the "id problem"
>
> I was thinking I could set something in my transition_form function that
> if form.process().accepted: redirect(URL('user_list')), but I get an error
> saying table object has no attribute '_formkey' does this mean I need to do
> some type of form validation?
>
> On Monday, May 5, 2014 9:53:38 AM UTC-4, Richard wrote:
>>
>> Please show code!!
>>
>> Richard
>>
>>
>> On Mon, May 5, 2014 at 8:50 AM, LoveWeb2py <[email protected]> wrote:
>>
>>> Also,
>>>
>>> When I click the submit button in {{=form}} it doesn't actually submit
>>> anything. It just doubles the values that are already in the fields and
>>> puts them into a list. I think I need to do something like db.insert with a
>>> new ID number for the submit button.
>>>
>>>
>>> On Monday, May 5, 2014 8:46:25 AM UTC-4, LoveWeb2py wrote:
>>>>
>>>> Richard/Niphold,
>>>>
>>>> Thank you so much. It's almost done. Just getting attribute error now
>>>> but I am going to try to fix that with exception handling.
>>>>
>>>> <type 'exceptions.AttributeError'> 'str' object has no attribute 'year'
>>>>
>>>> I have a modified_on field which is set to datetime. WHen I comment
>>>> that out it transfers to the next page with no problem. Any thoughts on
>>>> how
>>>> I could fix?
>>>>
>>>> On Sunday, May 4, 2014 9:10:55 AM UTC-4, Richard wrote:
>>>>>
>>>>> Sorry for miss leading, Niphold is true...
>>>>>
>>>>> So,
>>>>>
>>>>> for f, v in request.vars.iteritmes():
>>>>> db.table[f].default = v
>>>>>
>>>>>
>>>>> On Sat, May 3, 2014 at 8:47 AM, Niphlod <[email protected]> wrote:
>>>>>
>>>>>> request.vars is like a dict. Surely you're hitting that issue :-P
>>>>>>
>>>>>> >>> test = dict(a=1,b=2)
>>>>>> >>> for k,v in test:
>>>>>> ... print k, v
>>>>>> ...
>>>>>> Traceback (most recent call last):
>>>>>> File "<stdin>", line 1, in <module>
>>>>>> ValueError: need more than 1 value to unpack
>>>>>> >>>
>>>>>>
>>>>>> Add an "iteritems()" and you're good to go
>>>>>>
>>>>>> >>> for k,v in test.iteritems():
>>>>>> ... print k,v
>>>>>> ...
>>>>>> a 1
>>>>>> b 2
>>>>>>
>>>>>> >>>
>>>>>>
>>>>>> On Friday, May 2, 2014 11:20:40 PM UTC+2, LoveWeb2py wrote:
>>>>>>>
>>>>>>> Web2py admin console has a red line at for f, v in request.vars: and
>>>>>>> then says too many values to unpack.
>>>>>>>
>>>>>>> my function is def transition_form():
>>>>>>> for f, v in request.vars:
>>>>>>> db.table[f].default = v
>>>>>>> form = SQLFORM(db.table, user_signature=True)
>>>>>>> return dict(form=form)
>>>>>>>
>>>>>>> Should I have extra values in the dict method?
>>>>>>>
>>>>>> --
>>>>>> 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 subscribed to the Google
>>>>>> Groups "web2py-users" group.
>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>> send an email to [email protected].
>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>
>>>>>
>>>>> --
>>> 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 subscribed to the Google
>>> Groups "web2py-users" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to [email protected].
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
--
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 subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
