[web2py] what distinguishes update form from create form

2010-02-22 Thread hamdy.a.farag
Hi I was curious , what distinguishes update form from create from in crud, and SQLFORM ? I mean when form is submitted what makes web2py distinguish between both criteria -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group,

Re: [web2py] Re: small improvement to TK gui

2010-02-22 Thread Jason Brower
+1 And it would be nice to see a list of error links and they happen on the server. Or a link or viewer for the error logs. Etc... That brings up another point. I would like to have an error log viewer that I can run from the console as well, so I can easily parse through errors on my server.

[web2py] Question about web2py license

2010-02-22 Thread Miguel Lopes
Hello Massimo, I wonder if web2py's license would allow for a SaaS kind of application? By SaaS I mean access to the site (web app) would be paid for. In practice end users would pay a fee for accessing the site functionality. This seems very, very borderline to me. I know you are not laywers.

[web2py] Re: Saving Thumbnail Files

2010-02-22 Thread ls1
Hi, I've had the same issue before and did it that way: Since your object is to upload a file and make a thumbnail at the same time, then: 1. Hide thumbnail field in a form. User will add image only and web2py do the rest. In your controller: fields=['Name','MainPic'] form=SQLFORM(db.yourtable,

[web2py] Re: Saving Thumbnail Files

2010-02-22 Thread ls1
small typo error in my previous post: should be: def makeThumbnail(ImageID):     try:    thisImage=db(db.yourtable.id==ImageID).select()[0]     except: return     im=Image.open(request.folder + 'uploads/' + thisImage.MainPic)     im.thumbnail((200,150),Image.ANTIALIAS)    

[web2py] Re: Groups.

2010-02-22 Thread hamdy.a.farag
Hi Matt add auth.settings.create_user_groups = True in db.py then for every user created a new group is created for him with the name 'user_id' To add a custom group once, you may add a function to your model that do the post-registeration stuff [including adding groups] def

Re: [web2py] Question about web2py license

2010-02-22 Thread Kuba Kucharski
I think short answer is this is allowed. http://osdir.com/ml/web2py/2009-09/msg01859.html -- Kuba -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group,

Re: [web2py] Re: appadmin fails on gae

2010-02-22 Thread Carles Gonzalez
No, it does not work either. it raises (from chromium): Error 107 (net::ERR_SSL_PROTOCOL_ERROR): Error desconegut. The app is quite simple, almost no code. Just a table, crud and webgrid. On Fri, Feb 19, 2010 at 2:07 PM, mdipierro mdipie...@cs.depaul.edu wrote: I do not know. I have never

[web2py] Multiple Select Widget

2010-02-22 Thread Michael Howden
Hey, I have a need to allow the user to select multiple countries for a single record (in this case the record is a project - which could be occurring in a number of different countries). I've developed a widget which allows the user to select a country from a drop down, then click a button

Re: [web2py] Multiple Select Widget

2010-02-22 Thread Tiago Almeida
Is there a better way to do this type of functionality rather than using a hidden multiple widget? Why not make a simple table/list of checkboxes next to each country? --- Tiago On Mon, Feb 22, 2010 at 10:46 AM, Michael Howden michael.how...@gmail.comwrote: Hey, I have a need to allow

[web2py] RESTful web2py???

2010-02-22 Thread Snaky Love
Hi, there was some interesting thread about making web2py more RESTful here: http://groups.google.com/group/web2py/browse_thread/thread/70797300effc1252/bafd25e95957d5fe unfortunately the discussion ends without any results. I would like to ask, if there was / is / will be any change going on

Re: [web2py] what distinguishes update form from create form

2010-02-22 Thread Thadeus Burgess
Whether it is performing an db.update or a db.insert. With sqlform, when passing a record it assumes db.update -Thadeus On Mon, Feb 22, 2010 at 2:12 AM, hamdy.a.farag hamdy.a.fa...@inbox.com wrote: Hi I was curious , what distinguishes update form from create from in crud, and SQLFORM ?

Re: [web2py] Re: small improvement to TK gui

2010-02-22 Thread Thadeus Burgess
errors are just pickle files. Have at it :) -Thadeus On Mon, Feb 22, 2010 at 2:28 AM, Jason Brower encomp...@gmail.com wrote: +1 And it would be nice to see a list of error links and they happen on the server.  Or a link or viewer for the error logs. Etc... That brings up another point.

[web2py] google app engine, file size limits

2010-02-22 Thread what_ho
Hi all - I wonder if anyone else has hit the file-size upload limits on GAE? This limit is supposed to be 10MB which for my needs would be fine. The GAE file system is read-only so I save upload data in the database like this: Field('file','upload',uploadfield='file_binary', ...

Re: [web2py] google app engine, file size limits

2010-02-22 Thread Thadeus Burgess
Well, with RAR files you can split them up into 1MB files. So you get the uploaded file, rar it in .9MB splits, upload to a table that stores chunks. Now when you need the file, pull the chunks out of your table, and unrar them. I know that this works on the unix command line, not sure if the

[web2py] Re: google app engine, file size limits

2010-02-22 Thread what_ho
Using rar to compress and chunk up the file at the same time could be a good option, especially if this can be done on the client (for example using a java-applet as a file download/upload manager). Chunking on the client would be the only way to go over the 10MB limit as well. GAE app

[web2py] Re: Saving Thumbnail Files

2010-02-22 Thread villas
Hi Lukasz, I made a web2pyslice from the code I eventually used, which I think was rather similar to that which you proposed. http://www.web2pyslices.com/main/slices/take_slice/62 If you think that 'slice' can be improved, please let me know. I don't believe this solution would work on GAE, so

Re: [web2py] Re: Saving Thumbnail Files

2010-02-22 Thread Thadeus Burgess
What if two requests come in at the same time and they overwrite the thumbnail.jpg file ? Would there be a conflict or does PIL store the image in memory anyways? Also, web2py hashes the filename, so wouldn't it get overwritten if you had multiple thumbnail.jpg of the same size ? -Thadeus

[web2py] OAuth, LinkedIn and Web2py

2010-02-22 Thread PanosJee
Hi everyone, i am new to Python and Web2py and i am developing an app that will use the LinkedIn api I use this library http://code.google.com/p/python-linkedin/ (it includes OAuth). My problem is very strange and that s why i am writing to the list. When i try to connect to LinkedIn from the

[web2py] creating Microsot Excel type charts

2010-02-22 Thread Ramon
Hello, I am going to use web2py for a database project soon. I have a quick question. I would like to create Microsoft Excel type charts for certain tables that will be produced within web2py. Is there any way to do that now. If not, I would settle for exporting the data in the tables as csv

[web2py] Re: creating Microsot Excel type charts

2010-02-22 Thread DenesL
Maybe the code around line 250 in http://trac.sahanapy.org/browser/models/01_RESTlike_controller.py could be modified to do it. On Feb 22, 9:28 am, Ramon ramonnova...@hotmail.com wrote: Hello, I am going to use web2py for a database project soon. I have a quick question. I would like to

Re: [web2py] creating Microsot Excel type charts

2010-02-22 Thread Thadeus Burgess
google has a charting api for python. it can do most any kind of chart excel can do, if you don't mind your data going to google that is. there are plenty of jquery charts that will turn a html table into a chart. -Thadeus On Mon, Feb 22, 2010 at 8:28 AM, Ramon ramonnova...@hotmail.com

[web2py] Re: How to plan building an webapp that runs on GAE with web2py?

2010-02-22 Thread what_ho
Hi Snaky - Identical source code can be deployed both to GAE and elsewhere without editing, you don't need to edit connection strings before deploying to GAE. The default db.py code you get with a new project detects if gae is running with the line if request.env.web2py_runtime_gae: ... using

[web2py] LOAD and response.view

2010-02-22 Thread vihang
Hi, I tried the following code def index(): return dict(message=Accounting Dashboard) def AP(): response.view = 'blank.html' return dict(message=db(db.Purchase_Invoice.id0).select(db.Purchase_Invoice.Due.sum())) The calling AP using LOAD in index.html works fine, but does not use

Re: [web2py] OAuth, LinkedIn and Web2py

2010-02-22 Thread Tiago Almeida
Can you post the exception you're getting? It might help to determine what's wrong... On Mon, Feb 22, 2010 at 4:18 PM, PanosJee panos...@gmail.com wrote: Hi everyone, i am new to Python and Web2py and i am developing an app that will use the LinkedIn api I use this library

[web2py] weird behavior to see in chrome's speed tracer

2010-02-22 Thread szimszon
Recently I watched the web2py admin site trough chrome's speed tracer and if I hit edit between site and about in menu bar on http://127.0.0.1:8000/admin/default/design/myapp site then I see as many http://127.0.0.1:8000/admin/default/design/myapp urls as many time I hit edit. It seems to me that

[web2py] Re: LOAD and response.view

2010-02-22 Thread DenesL
try response.view = 'your_controller_name/blank.html' On Feb 22, 1:09 pm, vihang vihan...@gmail.com wrote: Hi, I tried the following code def index(): return dict(message=Accounting Dashboard) def AP(): response.view = 'blank.html' return

[web2py] Unit testing in web2py : Some thoughts

2010-02-22 Thread Jon Romero
I've read about web2py and unit testing and I tried many things. These are my thoughts (please correct me If I am wrong) 1. web2py uses doctests. doctests must be inside the controller (increasing the noise) and are not flexible. Also, is not trivial to use them in another automated built/test

Re: [web2py] Question about web2py license

2010-02-22 Thread Miguel Lopes
On Mon, Feb 22, 2010 at 9:46 AM, Kuba Kucharski kuba.kuchar...@gmail.comwrote: I think short answer is this is allowed. http://osdir.com/ml/web2py/2009-09/msg01859.html -- Kuba You are right. But I still have doubts. The way I see it if company X is selling access to some SaaS

Re: [web2py] Question about web2py license

2010-02-22 Thread Thadeus Burgess
This has come up in the past, the topics on this subject are in the google group if the search would actually work I would share the links to the posts. The licensing of web2py does NOT extend to the apps that you create. What you cannot do is take web2py code, make some modifications to the

Re: [web2py] Unit testing in web2py : Some thoughts

2010-02-22 Thread Thadeus Burgess
Are we looking at the same thing? The link you provided gives an example of using the unittest classes (not doctest), in which you can import anything you want since it is just a python file. In the example is an example of executing your controllers in a web2py environment. Also the doctest

[web2py] web2py help resources

2010-02-22 Thread DenesL
Primary source of help: web2py groups - Groups in English: http://groups.google.com/group/web2py/topics http://groups.google.com/group/web2py-developers/topics Grupo de usuários brasileiros do web2py:

[web2py] web2py help resources

2010-02-22 Thread DenesL
Primary source of help: web2py groups - Groups in English: http://groups.google.com/group/web2py/topics http://groups.google.com/group/web2py-developers/topics Grupo de usuários brasileiros do web2py: http://groups.google.com/group/web2py-users-brazil/topics

Re: [web2py] Re: uWSGI + Cherokee + web2py - a howto.

2010-02-22 Thread Thadeus Burgess
How do you tell what user cherokee gets executed as when the server boots up? In my typical installation I have a generic user account (like servant) that everything server related exists in this home directory, and it owns everything. With Apache I have to chown/mod the files so that www-data

[web2py] Re: google app engine, file size limits

2010-02-22 Thread what_ho
I had not heard of the blobstore service before - thank you for pointing that out. I agree - well worth considering, up to 1GB files the service is still free. On Feb 22, 6:22 pm, villas villa...@gmail.com wrote: For anything above 1Mb,  I think Google are trying their best to promote their new

[web2py] Re: Saving Thumbnail Files

2010-02-22 Thread villas
Hi Thadeus You are right, I was just demonstrating a concept rather than writing production code but I should include some extra lines to help avoid such issues. Thanks for your constructive comments. D On Feb 22, 4:41 pm, Thadeus Burgess thade...@thadeusb.com wrote: What if two requests come

Re: [web2py] Re: Saving Thumbnail Files

2010-02-22 Thread Thadeus Burgess
You could use StringIO for storing the PIL, and then when updating the web2py record pass the StringIO, and a filename that is a hash of the original filename, this would prove a unique record. -Thadeus On Mon, Feb 22, 2010 at 1:45 PM, villas villa...@gmail.com wrote: Hi Thadeus You are

[web2py] Re: mail plain text message wrong charset

2010-02-22 Thread szimszon
I wonder if somebody could turn me in the right direction? On febr. 17, 09:16, szimszon szims...@gmail.com wrote: Hello! I like to send email with:         context=dict(...)         message=response.render( 'template.txt', context )         mail.send( to = ['some email'],                  

Re: [web2py] Question about web2py license

2010-02-22 Thread Miguel Lopes
On Mon, Feb 22, 2010 at 7:06 PM, Thadeus Burgess thade...@thadeusb.comwrote: This has come up in the past, the topics on this subject are in the google group if the search would actually work I would share the links to the posts. I've searched too, but what I've found in the group was, in my

[web2py] Re: Toggle on/off editarea on startup

2010-02-22 Thread Alex
Hi, again. I still need the advice ) -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more

[web2py] SQLFORM.factory and boolean values

2010-02-22 Thread Peter Woolf
Hi All, I'm trying to make a simple boolean form that upon submission puts the form data into the URL, and in doing so defines the  states of each button.  Unfortunately this is not working, for reasons I can't see. In the code below, the button first defaults to checked.  If the button is

[web2py] Re: creating Microsot Excel type charts

2010-02-22 Thread Brian M
Yahoo's YUI javascript library includes a charts component that I've had luck with. They're flashed based in the end though. As Thadeus said Google also has a charts api - theirs ends up rendering as images which is nice if your users will want to do something like copy the chart and paste it into

[web2py] Re: Groups.

2010-02-22 Thread Matt
Hi Hamdy, Thanks for your answer. I guess my initial question was a little bit vague I ended up doing something like: if len(db().select(db.auth_group.ALL)) == 0: auth.add_group('Administrator', 'Manage the website') auth Matt On Feb 22, 10:46 pm, hamdy.a.farag hamdy.a.fa...@inbox.com

[web2py] Where is the actual API?

2010-02-22 Thread Matt
Hi there, Is there an _actual_ HTML hosted API available that describes how to programatically use web2py? I.e. That covers things like tools, contrib etc from gluon? Thanks in advance, Matt -- You received this message because you are subscribed to the Google Groups web2py-users group. To

[web2py] Re: creating Microsot Excel type charts

2010-02-22 Thread Richard
I have been using Google's Chart API for simple graphs and flot for interactive ones: http://code.google.com/p/flot/ On Feb 23, 9:04 am, Brian M bmere...@gmail.com wrote: Yahoo's YUI javascript library includes a charts component that I've had luck with. They're flashed based in the end

[web2py] Re: Unit testing in web2py : Some thoughts

2010-02-22 Thread spiffytech
The link you provided gives an example of using the unittest classes (not doctest), in which you can import anything you want since it is just a python file. AlterEgo 213 (which Jon linked to) does not show how to get your controllers to see your database models- the example code doesn't

[web2py] Re: Where is the actual API?

2010-02-22 Thread mr.freeze
http://web2py.com/examples/default/api http://web2py.com/examples/static/epydoc/index.html On Feb 22, 5:20 pm, Matt mjwat...@gmail.com wrote: Hi there, Is there an _actual_ HTML hosted API available that describes how to programatically use web2py? I.e. That covers things like tools,

[web2py] Re: How to plan building an webapp that runs on GAE with web2py?

2010-02-22 Thread Richard
hi Snaky, Some apps are just not suitable for GAE such as when you need a C based library. But any simple web2py app should work on GAE too, with at most minor changes. Last year I tried running the wiki app on GAE and most of it worked out of the box. A few things I needed to consider when

[web2py] Re: Where is the actual API?

2010-02-22 Thread Matt
Great thanks That should be included in the manual. On Feb 23, 1:13 pm, mr.freeze nat...@freezable.com wrote: http://web2py.com/examples/default/apihttp://web2py.com/examples/static/epydoc/index.html On Feb 22, 5:20 pm, Matt mjwat...@gmail.com wrote: Hi there, Is there an _actual_

[web2py] Re: congratulations for documentation

2010-02-22 Thread weheh
Well, of course, that makes sense. Now I see the login area for editors. Very nice. On Feb 21, 4:04 pm, mdipierro mdipie...@cs.depaul.edu wrote: I thought the point was that you'd'd be making the updates. ;-) On Feb 21, 11:40 am, weheh richard_gor...@verizon.net wrote: Massimo, wonderful

[web2py] Re: creating Microsot Excel type charts

2010-02-22 Thread mr.freeze
This looks good too: http://www.jqplot.com/ On Feb 22, 5:27 pm, Richard richar...@gmail.com wrote: I have been using Google's Chart API for simple graphs and flot for interactive ones:http://code.google.com/p/flot/ On Feb 23, 9:04 am, Brian M bmere...@gmail.com wrote: Yahoo's YUI

[web2py] Google Authentication with Auth

2010-02-22 Thread Richard
GAE has its own authentication features: from google.appengine.api import users user = users.get_current_user() if user: if users.is_current_user_admin(): ... else: ... else: users.create_login_url() Has anyone tried integrating this with Auth? Richard -- You

[web2py] Re: OAuth, LinkedIn and Web2py

2010-02-22 Thread PanosJee
I don t get an exception in web2py cos the linkedin library catches it so i just get a false. LinkedIn returns a bad signature error when i try to request the token (when calling the url via browser) If i write the code in console everything is fine On 22 Φεβ, 20:11, Tiago Almeida

[web2py] Re: Google Authentication with Auth

2010-02-22 Thread mr.freeze
I haven't used their api directly but have used RPX to authenticate google accounts: http://www.web2pyslices.com/main/slices/take_slice/28 On Feb 22, 6:44 pm, Richard richar...@gmail.com wrote: GAE has its own authentication features: from google.appengine.api import users user =

Re: [web2py] Re: Unit testing in web2py : Some thoughts

2010-02-22 Thread Thadeus Burgess
python web2py.py --help -S APPNAME, --shell=APPNAME run web2py in interactive shell or IPython (if installed) with specified appname -T TEST_PATH, --test=TEST_PATH run doctests in web2py environment; TEST_PATH like

Re: [web2py] Re: Google Authentication with Auth

2010-02-22 Thread Thadeus Burgess
Isn't this what the gluon/contrib/login_methods/gae_google_account.py is for? It integrates directly into web2py auth mechanisms? -Thadeus On Mon, Feb 22, 2010 at 6:52 PM, mr.freeze nat...@freezable.com wrote: I haven't used their api directly but have used RPX to authenticate google

Re: [web2py] Re: GAE delete() has subtle difference compared to native Web2Py

2010-02-22 Thread Miguel Goncalves
I am running into the same problem. Replacing count by len seems to work. Will this fix be included in the next version of web2py or is there a better/other way of addressing this? -Miguel On Sun, Feb 21, 2010 at 3:03 PM, what_ho a...@viovi.com wrote: I got the same issue, delete operations

Re: [web2py] Re: congratulations for documentation

2010-02-22 Thread Andres Vargas - zodman
its all web2py needed well im pass from django to web2py On Mon, Feb 22, 2010 at 6:38 PM, weheh richard_gor...@verizon.net wrote: Well, of course, that makes sense. Now I see the login area for editors. Very nice. On Feb 21, 4:04 pm, mdipierro mdipie...@cs.depaul.edu wrote: I thought the

Re: [web2py] congratulations for documentation

2010-02-22 Thread Zoom.Quiet
On Sun, Feb 21, 2010 at 20:58, Francisco Antonio Tapias Bravo free...@gmail.com wrote: three weeks ago, I bought the book at lulu and now I've seen it available from http://web2py.com/book/. I think it has been a excellent this content is same web2py manual ? and is base wiki? so should config

[web2py] crud delete weird behavior (on GAE at least)

2010-02-22 Thread Miguel
Hi I implemented the following function to delete an entry in a db: @auth.requires_login() def DeleteSite(): msg = T(Cannot delete specified record.) try: record_id = request.vars['id'] next_page = request.vars['next'] except:

[web2py] Re: Google Authentication with Auth

2010-02-22 Thread mr.freeze
Looks like it. Missed that one. On Feb 22, 7:28 pm, Thadeus Burgess thade...@thadeusb.com wrote: Isn't this what the gluon/contrib/login_methods/gae_google_account.py is for? It integrates directly into web2py auth mechanisms? -Thadeus On Mon, Feb 22, 2010 at 6:52 PM, mr.freeze

[web2py] Re: Groups.

2010-02-22 Thread Richard
I have a Settings class that internally does something like that: if db(db.auth_group.id 0).count() == 0: ... Hopefully there is a better way to avoid making this query for each request. Maybe just comment it out later? On Feb 23, 9:48 am, Matt mjwat...@gmail.com wrote: Hi Hamdy,

[web2py] Re: Where is the actual API?

2010-02-22 Thread Richard
it is in the online book: http://web2py.com/book/default/api On Feb 23, 11:23 am, Matt mjwat...@gmail.com wrote: Great thanks That should be included in the manual. On Feb 23, 1:13 pm, mr.freeze nat...@freezable.com wrote:

Re: [web2py] Question about web2py license

2010-02-22 Thread Jason Brower
The software created with Web2py can be any license that you like. On Mon, 2010-02-22 at 09:29 +, Miguel Lopes wrote: Hello Massimo, I wonder if web2py's license would allow for a SaaS kind of application? By SaaS I mean access to the site (web app) would be paid for. In practice end

[web2py] Re: LOAD and response.view

2010-02-22 Thread vihang
tried that too, doesn't work... On Feb 22, 10:36 pm, DenesL denes1...@yahoo.ca wrote: try response.view = 'your_controller_name/blank.html' On Feb 22, 1:09 pm, vihang vihan...@gmail.com wrote: Hi, I tried the following code def index():     return dict(message=Accounting Dashboard)

[web2py] Re: Multiple Select Widget

2010-02-22 Thread mdipierro
I do not know if this case be useful as well http://web2py.com/plugins/default/multiselect it would be nice to have a version with same interface but many2many backend. Massimo On Feb 22, 4:46 am, Michael Howden michael.how...@gmail.com wrote: Hey, I have a need to allow the user to select

[web2py] Re: Haiti: Proxy required - Django port? CGI port?

2010-02-22 Thread mdipierro
I just rewrote the Django on th web2py. It should be easy to change it. On Feb 22, 6:31 am, Richard richar...@gmail.com wrote: The above snippet seems to proxy internal content rather than fetch external content like the Django example. whoops, the Django snippet also does this. -- You

[web2py] Re: MySQL server has gone away

2010-02-22 Thread mdipierro
Sorry my collection is very slow... It cannot b predicted when a connection fail so if it fails in between a trasaction, i.e. when serving a request, it will generate a ticket but it should do so only once since this connection will be discared (not recycled) and a new one will be placed in the

[web2py] Re: MySQL server has gone away

2010-02-22 Thread Kevin Bowling
Yes, I have an app and did a 5 connection pool. It seems MySQL by default closes connections every 8 hours. Therefore, if nobody accesses the app overnight, it dies. I know other things that use connection pools like Openfire XMPP server poll it quite regularly to keep it open. I don't know

[web2py] Re: mail plain text message wrong charset

2010-02-22 Thread mdipierro
You either encode the message in utf8 (default) or you specify a different encoding= as argument of Mail On Feb 22, 1:30 pm, szimszon szims...@gmail.com wrote: I wonder if somebody could turn me in the right direction? On febr. 17, 09:16, szimszon szims...@gmail.com wrote: Hello! I like

[web2py] Re: Saving Thumbnail Files

2010-02-22 Thread mdipierro
not if file is a open('filename','rb') On Feb 21, 6:26 pm, villas villa...@gmail.com wrote: @MrFreeze Thanks for your suggestion, but unless Web2py allocates the filename then the default download action will not work. I finally got it working after eventually finding this snippet:

[web2py] Re: {{=form.custom.begin}} - How set an ID to form

2010-02-22 Thread mdipierro
Sorry by bad def register(): form=auth.registe() form['_id'] = 'my_form_id' return dict(form=form) On Feb 22, 2:09 pm, arnaud arnaud.masse...@gmail.com wrote: Hi Massimo, when I test your code (platform : windows / web2py 1-754), it's return the following error : Traceback (most

[web2py] Re: {{=form.custom.begin}} - How set an ID to form

2010-02-22 Thread mdipierro
def register(): form=auth.register() form['_id'] = 'my_form_id' return dict(form=form) On Feb 22, 2:09 pm, arnaud arnaud.masse...@gmail.com wrote: Hi Massimo, when I test your code (platform : windows / web2py 1-754), it's return the following error : Traceback (most recent call