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 instead of strings there?
>
> > > I was beginning to think along the same lines, but I tried both
> > > datetime.datetime and datetime.date and got the same results.
> > > SqlAlchemy never does show what rows it's fetching either, as Bayer
> > > said it should. I even tried using SA 0.5.0rc4 just to see if it was
> > > some kind of weird regression, but that didn't help either.
>
> > build a standalone test script that is entirely outside of the domain of
> > your application:
>
> > engine = create_engine('<url>', echo='debug')
> > engine.execute(<your query>).fetchall()
>
> > what do you get ?
>
> That seems to give me all the information including the rows from
> November and December that were missing before. That's interesting. I
> was trying to remember how to do it using just straight SQL, but I
> couldn't find it on the website for some reason. I wonder why my
> session doesn't work then...
>
>
>
> - Mike
Well, I finally found out why it works in SQL Server and not in SA. I
was supposed to be querying against a test db that was a replica of
our online system. Alas, it was not. Lots of data is missing from the
database I was using. If I change the connection string to run the
query against our live database, it works fine.
I apologize for all the noise. Sheesh!
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
-~----------~----~----~----~------~----~------~--~---
