[sqlalchemy] Re: Newbie question about select statement

2007-02-14 Thread Cristiano Paris
Cristiano Paris wrote: I everyone. I'm pretty new to SQLAlchemy and never done much sql-related work in the past as well so this could possibly be a silly question. ... I ended up discovering SearchResult which does mostly of the things I need. Cristiano

[sqlalchemy] Re: Newbie question about select statement

2007-02-14 Thread Cristiano Paris
Michael Bayer wrote: also look into the SelectResults extension which will do the somelist[90] == SELECT ... OFFSET 90 LIMIT 1 thing. its in the plugins section of the docs. Thanks to all. I don't why but I haven't received these two emails until now. Cristiano

[sqlalchemy] Newbie question about select statement

2007-02-13 Thread Cristiano Paris
I everyone. I'm pretty new to SQLAlchemy and never done much sql-related work in the past as well so this could possibly be a silly question. Suppose I've a table with a huge number of records. Now, I'd like to access this table randomly through a list-like interface of a Python class instance,