GAE does not support selecting parts of a record. We could filter out the data at the web2py level but why? You already downloaded more than you need and filtering would just consume cycles. The solution it not to use fields you do not need.
If the problem is SQLTABLE, you can filter fields with SQLTABLE(...fields=[...]). On Sep 30, 8:53 am, István Gazsi <[email protected]> wrote: > Hi everybody! > > I've working on a web2py application and I deployed it on Google App > Engine. In my application I do database query like this: > > db(db.gallery.category_id==main_category.id).select(db.gallery.id, > db.gallery.title, db.gallery.thumbnail, db.gallery.posted_on, > orderby=~db.gallery.posted_on, limitby=(start, end)) > > My problem is that when it's running on GAE it doesn't work. Web2py > (or maybe the GAE) ignores the fields I've selected, and fetches the > whole row. How can I solve this problem? > > Thanks in advance!
