Hi,
When I run a simple query like this:
qry = session.query(CheckHistory)
qry = qry.filter(and_(CheckHistory.CHECK_DATE >= '1/1/2007',
CheckHistory.CHECK_DATE <=
'1/1/2008'))
res = qry.all()
I get one CheckHistory row and a None. If I run the echoed SQL code in
my database's query analyzer, I get almost 5000 results. Last Friday,
this worked just fine. However, over the weekend, we upgraded from MS
SQL Server 2000 to 2005. I don't see how this could have messed up
SqlAlchemy, but something weird is going on here.
Does anyone have any hints for troubleshooting this?
I am using SqlAlchemy 0.5.6 on Windows XP with Python 2.5.
Thanks,
Mike
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
