thank you for your answer and sorry for the delay, i had been some days away.
at this time the code that fails is: tabella = request.args[0] response.headers['Content-Type']='text/x-csv' response.headers['Content-Disposition']='attachment;filename="report.csv" ' dati = legacy_db().select(legacy_db[tabella].ALL) s = cStringIO.StringIO() dati.export_to_csv_file(s) so i should use iterselect when defining dati, but when i try something like: """ for row in legacy_db(legacy_db.COD2.id > 0).iterselect(): ....: rtn = row ....: "" i get : "" --------------------------------------------------------------------------- AttributeError Traceback (most recent call last) /home/www-data/web2py/applications/PROVE/models/menu.py in <module>() ----> 1 for row in legacy_db(legacy_db.COD2.id > 0).iterselect(): 2 rtn = row 3 AttributeError: 'Set' object has no attribute 'iterselect' "" moreover, i should 'append' the row to a pydal.objects.Rows as to say dati += row but how can i do this? Thank you a lot again 2016-08-04 9:52 GMT+02:00, c...@cemeren.com <c...@cemeren.com>: > You may try using iterselect() instead of select() if the issue is memory > related. > > The link to the book is below. > > http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=Using-an-iterator-based-select-for-lower-memory-use#Using-an-iterator-based-select-for-lower-memory-use > > On Thursday, August 4, 2016 at 10:35:13 AM UTC+3, goome wrote: >> >> 2016-08-04 1:08 GMT+02:00, Dave S <snide...@gmail.com <javascript:>>: >> > >> > >> > On Wednesday, August 3, 2016 at 2:33:35 PM UTC-7, goome wrote: >> >> >> >> when trying in the shell, the shell itself got killed : >> >> >> In [4]: legacy_db(query).select() >> >> >> >> >> >> Killed >> >> >> root@rb:/home/www-data/web2py# >> >> >> >> >> > Is that using web2py in a bash/python shell (i.,e., -M -S myapp) ? >> yes, this one >> > > -- > 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/web2py/nqUnVx62GE0/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > web2py+unsubscr...@googlegroups.com. > 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.