Here is my test.
$ python web2py.py -S welcome
(InteractiveConsole)
>>> import sys
>>> form = SQLFORM.factory(Field('name'))
>>> form.process(onvalidation=lambda
form:sys.stdout.write('check!\n'),formname=None,session=None)
check!
It works. Something else is wrong in your code. If you could post a
complete example we can try help you debug it.
Massimo
On Monday, 21 January 2013 12:03:11 UTC-6, Ramos wrote:
>
> Sorry for insisting,
>
> I ´m using onvalidation in sqlform but if i use it in sqlform.factory i
> get a flash message
> Errors in Form. Please check it out!!!
>
> *Secondly*
> as i am using sqlform.factory to add records how to use it also to update
> or delete?
>
> Thank you
> António
>
> 2013/1/21 Massimo Di Pierro <[email protected] <javascript:>>
>
>> yes.
>>
>>
>> On Monday, 21 January 2013 11:35:00 UTC-6, Ramos wrote:
>>
>>> can onvalidation be used with sqlform.factory ?
>>>
>>> i´m getting error
>>>
>>> Errors in Form. Please check it out!!!
>>>
>>>
>>> Thank you
>>>
>>>
>>> António
>>>
>>> 2013/1/17 Massimo Di Pierro <[email protected]>
>>>
>>> *You are storing the image twice:*
>>>> *
>>>> *
>>>> *if
>>>> trabalhador_form.process(onvalidation=attach_image_to_record).accepted:
>>>> # here after validation *
>>>> *def attach_image_to_record(form):*
>>>> ...
>>>> photo=db.trabalhador.foto.**stor**e(temp,'foto.jpg') # here on
>>>> validation
>>>> * ... *
>>>> form.vars.photo=photo *# here is where someting goes wrong....*
>>>> *
>>>> *
>>>> *The problem is that you altering the form on validation.*
>>>> *
>>>> *
>>>> *
>>>> *
>>>> *This this:*
>>>> *
>>>> *
>>>> **
>>>> *def attach_image_to_record(form):*
>>>> import cgi
>>>> response=requests.get(form.**var**s.fp_url)
>>>> img=Image.open(StringIO(**respon**se.content))
>>>> img.save('foto1231.jpg','JPEG'****)
>>>> photo = cgi.FieldStorage()
>>>> photo.file = open('foto1231.jpg','rb')
>>>> photo.filename = 'foto.jpg'
>>>> form.vars.photo=photo # not this on, you let process do upload
>>>>
>>>>
>>>> **
>>>>
>>>> This is very important for me ,
>>>> *
>>>> *
>>>> *
>>>> *
>>>> On Wednesday, 16 January 2013 07:49:30 UTC-6, Ramos wrote:
>>>>
>>>>> I just noticed one image created in upload folder and one txt file.
>>>>> Inside the txt file i see the name of jpg file created above.
>>>>>
>>>>>
>>>>> why is that?
>>>>>
>>>>> help please :)
>>>>>
>>>>> António
>>>>>
>>>>> 2013/1/16 António Ramos <[email protected]>
>>>>>
>>>>>> can onvalidation set upload file field?
>>>>>>
>>>>>> i was complaining that form.vars was empty.
>>>>>> It is if the controller does not return the form to the view
>>>>>> So i return the form and away with my quest.
>>>>>>
>>>>>> Now, in onvalidation i set the field with the upload file.
>>>>>> I have to becaue i have a different upload button that goes online to
>>>>>> get a file.
>>>>>> Its working but the image file i set goes as a txt file to the
>>>>>> database, why
>>>>>>
>>>>>>
>>>>>> here my code:
>>>>>> (I use PIL module)
>>>>>>
>>>>>> *if trabalhador_form.process(onvalidation=attach_image_to_record
>>>>>> ).accepted:*
>>>>>>
>>>>>> *def attach_image_to_record(form):*
>>>>>>
>>>>>> response=requests.get(form.**var**s.fp_url)
>>>>>> img=Image.open(StringIO(**respon**se.content))
>>>>>> img.save('foto1231.jpg','JPEG'****)
>>>>>> temp=open('foto1231.jpg','rb')
>>>>>> photo=db.trabalhador.foto.**stor**e(temp,'foto.jpg')
>>>>>> * print photo # echoes something like "trabalhador.foto.
>>>>>> 989708787087078.9823492034.jpg*
>>>>>> form.vars.photo=photo *# here is where someting goes wrong....*
>>>>>>
>>>>>> This is very important for me ,
>>>>>> can anyone explain why a jpg is inserted as a txt? how to force jpg ?
>>>>>>
>>>>>> Thank you
>>>>>> António
>>>>>>
>>>>>>
>>>>>> 2013/1/15 António Ramos <[email protected]>
>>>>>>
>>>>>>> I´m testing this book example
>>>>>>> http://web2py.com/books/**defaul**t/chapter/29/07#**onvalidation<http://web2py.com/books/default/chapter/29/07#onvalidation>
>>>>>>> I get error on field named 'a'
>>>>>>>
>>>>>>> Traceback (most recent call last):
>>>>>>> File "C:\web2pyGit\web2py\gluon\**res**tricted.py", line 212, in
>>>>>>> restricted
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> exec ccode in environment
>>>>>>> File "C:/web2pyGit/web2py/**applicati**ons/teste1/models/db.**py"
>>>>>>> <http://127.0.0.1:8000/admin/default/edit/teste1/models/db.py>, line
>>>>>>> 91, in <module>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Field('c', 'integer', readable=False, writable=False))
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> File "C:\web2pyGit\web2py\gluon\**dal**.py", line 7189, in
>>>>>>> define_table
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> table = self.lazy_define_table(tablena****me,*fields,**args)
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> File "C:\web2pyGit\web2py\gluon\**dal**.py", line 7206, in
>>>>>>> lazy_define_table
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> table = table_class(self, tablename, *fields, **args)
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> File "C:\web2pyGit\web2py\gluon\**dal**.py", line 7612, in __init__
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> db.check_reserved_keyword(fiel****d_name)
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> File "C:\web2pyGit\web2py\gluon\**dal**.py", line 6933, in
>>>>>>> check_reserved_keyword
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> 'invalid table/column name "%s" is a "%s" reserved SQL keyword' %
>>>>>>> (name, backend.upper()))
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> SyntaxError: invalid table/column name "a" is a "ALL" reserved SQL
>>>>>>> keyword
>>>>>>>
>>>>>>>
>>>>>>> So i renamed all to a1,b1,c1 and it works !
>>>>>>>
>>>>>>> Now my initial complain is still not working. I will test tomorrow
>>>>>>> and post some code.
>>>>>>> Meanwhile please check why a is not a valid field name and update
>>>>>>> the book if necessary.
>>>>>>> thank you
>>>>>>>
>>>>>>> 2013/1/15 Anthony <[email protected]>
>>>>>>>
>>>>>>> form.vars should work. Can you show more code? Note,
>>>>>>>> form.request_vars is simply a copy of the original request.post_vars,
>>>>>>>> so
>>>>>>>> not equivalent to form.vars.
>>>>>>>>
>>>>>>>> Anthony
>>>>>>>>
>>>>>>>>
>>>>>>>> On Tuesday, January 15, 2013 10:17:08 AM UTC-5, Ramos wrote:
>>>>>>>>>
>>>>>>>>> hello reading the book online i tried the code
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> def my_form_processing(form):
>>>>>>>>> c = form.vars.a
>>>>>>>>>
>>>>>>>>> form.vars.b
>>>>>>>>> if c < 0:
>>>>>>>>> form.errors.b = 'a'
>>>>>>>>> else:
>>>>>>>>> form.vars.c = c
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> but form.vars was empty
>>>>>>>>>
>>>>>>>>> to access my form vars i changed to form.request_vars
>>>>>>>>>
>>>>>>>>> *Is the book wrong?*
>>>>>>>>>
>>>>>>>>> Thank you
>>>>>>>>> António
>>>>>>>>>
>>>>>>>> --
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>> --
>>>>
>>>>
>>>>
>>>>
>>>
>>> --
>>
>>
>>
>>
>
>
--
