I've read that, Richard.
When using this I get that error:
def transition_form():
for f, v in request.vars.iteritems():
db.users[f].default = v
form = SQLFORM(db.users, user_signature=True)
if form.process().accepted:
response.flash = 'form accepted'
return dict(form=form)
Still get the same error :
<type 'exceptions.AttributeError'> 'Table' object has no attribute
'_formkey'
On Monday, May 5, 2014 10:34:28 AM UTC-4, Richard wrote:
>
> That what I thought!
>
> How do you validate your form??
>
> Please read the book a bit more about form submission...
>
>
>
> http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM
>
> def display_form():
> form = SQLFORM(db.person)
> if form.process().accepted:
> response.flash = 'form accepted'
> elif form.errors:
> response.flash = 'form has errors'
> else:
> response.flash = 'please fill out the form'
> return dict(form=form)
>
>
> You need to process the form, see if it validate... You shouldn't have to
> insert manually your data if you don't need facy thing and
> form.process().accepted should handle everything for you.
>
> Richard
>
>
>
> On Mon, May 5, 2014 at 10:03 AM, LoveWeb2py <[email protected]<javascript:>
> > wrote:
>
>> 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] <javascript:>.
>> 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.
