Re: [web2py] Re: how can I ensures list-order

2015-01-01 Thread Stef Mientki
thanks Anthony, your answer looks really great, exactly what I was looking for and more ;-) I'll probably try it to morrow. cheers, Stef On 01-Jan-15 22:39, Anthony wrote: In that case, I wouldn't bother having the DAL create a Rows object. Instead, the database cursor will return a list of tu

Re: [web2py] Re: how can I ensures list-order

2015-01-01 Thread Anthony
In that case, I wouldn't bother having the DAL create a Rows object. Instead, the database cursor will return a list of tuples, which you can feed directly to numpy to create an array. There are two approaches to do this: import numpy as np my_array = np.asarray(db.executesql(db(query)._select(

Re: [web2py] Re: how can I ensures list-order

2015-01-01 Thread Stef Mientki
thanks Anthony, No, I don't need a list of dictionairies. From your question, I assume there's also a way to get a plain table ? I need a list of lists or even better a 2D-numpy array (so I can easily perform some conversions). The final list of lists (or numpy array) must be converted to a csv