William - I know you're trying to be helpful, and I do appreciate your time. But lines like this drive me crazy: """ You can get more details here: http://www.sqlobject.org/SQLObject.html """
I reference that page in my original post twice. The point that I am trying to make is threefold: 1. I don't understand how to perform joins using SQLObject, even after reading the docs many many many times 2. The docs are incorrect, see "NameError: name 'LEFTJOINon' is not defined " above 3. The docs are either misleading, not fleshed out, or the API is not very robust...see each point above, but specifically "AttributeError: Select instance has no attribute 'max' " I have been round and round on this discussion board about what an unholy PITA SQLObect is. I have yet to see any complex use of this that satisfies even a moderate real world requirement: joining two tables in a meaningful way. I'm presenting my simple case mostly as test case for the community. Regarding your proposed solution, and again, thanks for your input :o), but the problem is in the retrieval of the records, not with entering them. Also, I know that I could denorm the data, add an extra field to Page, and an store any of (mod_date_time, revision, or Entry.q.id) in the Page as I add entries. I am searching for a solution to the big problem...eg how does/should the OO mapper work...not how do I get around the wrapper limitations to solve my particular problem. -Todd
