[sqlalchemy] Re: SqlAlchemy limiting returned rows prematurely

2009-06-30 Thread Maciej Szumocki
I think the problem might be not the query itself, but the date ranges that get converted using wrong date format. Do you get the same results if you use real datetime objects instead of strings there? --~--~-~--~~~---~--~~ You received this message because you are

[sqlalchemy] Re: SqlAlchemy limiting returned rows prematurely

2009-06-30 Thread Mike Driscoll
Hi, On Jun 30, 8:10 am, Maciej Szumocki mszumo...@contman.pl wrote: I think the problem might be not the query itself, but the date ranges that get converted using wrong date format. Do you get the same results if you use real datetime objects instead of strings there? I was beginning to

[sqlalchemy] Re: SqlAlchemy limiting returned rows prematurely

2009-06-30 Thread Michael Bayer
Mike Driscoll wrote: Hi, On Jun 30, 8:10 am, Maciej Szumocki mszumo...@contman.pl wrote: I think the problem might be not the query itself, but the date ranges that get converted using wrong date format. Do you get the same results if you use real datetime objects instead of strings there?

[sqlalchemy] Re: SqlAlchemy limiting returned rows prematurely

2009-06-30 Thread Mike Driscoll
Hi, On Jun 30, 10:42 am, Michael Bayer mike...@zzzcomputing.com wrote: Mike Driscoll wrote: Hi, On Jun 30, 8:10 am, Maciej Szumocki mszumo...@contman.pl wrote: I think the problem might be not the query itself, but the date ranges that get converted using wrong date format. Do you get

[sqlalchemy] Re: SqlAlchemy limiting returned rows prematurely

2009-06-30 Thread Mike Driscoll
Hi all, Mike Driscoll wrote: Hi, On Jun 30, 8:10 am, Maciej Szumocki mszumo...@contman.pl wrote: I think the problem might be not the query itself, but the date ranges that get converted using wrong date format. Do you get the same results if you use real datetime objects

[sqlalchemy] Re: SqlAlchemy limiting returned rows prematurely

2009-06-29 Thread Mike Driscoll
Hi, On Jun 26, 5:40 pm, Michael Bayer mike...@zzzcomputing.com wrote: Mike Driscoll wrote: Hi, I am having an issue with what is getting returned from my SA query. Here's my code: code beginDate = 1/1/2007 endDate = 12/31/2007 qry = session.query(CheckHistory.CHK_DOC_NO,    

[sqlalchemy] Re: SqlAlchemy limiting returned rows prematurely

2009-06-29 Thread Michael Bayer
Mike Driscoll wrote: Hi, On Jun 26, 5:40 pm, Michael Bayer mike...@zzzcomputing.com wrote: Mike Driscoll wrote: Hi, I am having an issue with what is getting returned from my SA query. Here's my code: code beginDate = 1/1/2007 endDate = 12/31/2007 qry =

[sqlalchemy] Re: SqlAlchemy limiting returned rows prematurely

2009-06-29 Thread Mike Driscoll
Hi, On Jun 29, 9:51 am, Michael Bayer mike...@zzzcomputing.com wrote: Mike Driscoll wrote: Hi, On Jun 26, 5:40 pm, Michael Bayer mike...@zzzcomputing.com wrote: Mike Driscoll wrote: Hi, I am having an issue with what is getting returned from my SA query. Here's my code:

[sqlalchemy] Re: SqlAlchemy limiting returned rows prematurely

2009-06-29 Thread Michael Bayer
Mike Driscoll wrote: Hi, On Jun 29, 9:51 am, Michael Bayer mike...@zzzcomputing.com wrote: Mike Driscoll wrote: Hi, On Jun 26, 5:40 pm, Michael Bayer mike...@zzzcomputing.com wrote: Mike Driscoll wrote: Hi, I am having an issue with what is getting returned from my SA query.

[sqlalchemy] Re: SqlAlchemy limiting returned rows prematurely

2009-06-26 Thread Michael Bayer
Mike Driscoll wrote: Hi, I am having an issue with what is getting returned from my SA query. Here's my code: code beginDate = 1/1/2007 endDate = 12/31/2007 qry = session.query(CheckHistory.CHK_DOC_NO, CheckHistory.EMP_ID,