Thanks Michael, On Friday, October 7, 2011 12:44:16 AM UTC+11, Michael Bayer wrote: > > There are two things that come to mind that could specifically cause this > behavior. > > One is, the identifier of "1" as an integer does not actually match the > datatype received back from the MSSQL database - such as if the database > returned a string "1", that would cause the get() above to not locate > integer "1" in the cache. >
This was exactly the issue. Many thanks for your help with this--apologies for not getting back to you sooner. Simon. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To view this discussion on the web visit https://groups.google.com/d/msg/sqlalchemy/-/wHBak5H-MVAJ. 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.