[sqlalchemy] Re: Empty ResultProxy, but SQL statement yields results

2008-12-29 Thread Philip
I apologize, that was a typo. In my script I am actually printing the same variable that I am incrementing. My example should read: print Count: + str(count) The problem is that the printed count is not the actual number of records returned if printed query is run using another MySQL client. I

[sqlalchemy] Re: Empty ResultProxy, but SQL statement yields results

2008-12-29 Thread Michael Bayer
turn on DEBUG logging for sqlalchemy.engine (also works with create_engine(..., echo='debug') ) and take a look at the rendered SQL as well as the result rows returned. On Dec 29, 2008, at 9:08 AM, Philip wrote: I apologize, that was a typo. In my script I am actually printing the same

[sqlalchemy] Re: Empty ResultProxy, but SQL statement yields results

2008-12-24 Thread Michael Trier
Record_count is never set. Michael On Dec 23, 2008, at 3:27 PM, Philip philwr...@gmail.com wrote: I am having a problem that I am not able to figure out. Maybe someone else can see what I am doing wrong. I am building a query using the SQL expression language. Then printing the SQL