Re: pyDO 2 alpha

I just realized what I needed to be a little more clear in
my question.

What I am looking for is a way to do server side ordering *across*
a join.  For instance "get some items from table A sorted by field
B.foo of the items in table B that relate to the items in table A".

Currently with PyDO1 when running a query with n results you end up
having to do n+1 queries.  With direct access to ORDER BY you can do
it in a single query.  In order to make this work with PyDO1 I have
had to implement my own getSome method that takes a raw "I hope you
know what you are doing" query which I carefully formulate so that
PyDO will be able to parse the query result.  If implementing ORDER
BY is beyond the scope of PyDO2 for now, would it be possible to put
in a standardized getSomeSpecial() method that allows those who
understand what they are doing to pass in your own complex queries
without having to hack every release of PyDO that comes out?

Thanks.

Greg


-------------------------------------------------------
SF email is sponsored by - The IT Product Guide
Read honest & candid reviews on hundreds of IT Products from real users.
Discover which products truly live up to the hype. Start reading now.
http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click