Hi, and sorry if this question is too silly, or answered more fully elsewhere.
I'm fairly new to Elixir (and SQLAlchemy) and really like what I've read and seen of it so far. I even have a working set of classes interoperating with a MySQL database. (One can achieve a lot by doing plenty of reading and trial and error experimentation.) I saw a similar question asked somewhere in my reading travels, and the answer, more or less, referred the person to the assignmapper plug- in. I'm really battling tying together the Elixir/SQLAlchemy "bonding point". When should one drop down to SQLAlchemy, and follow its documentation? For example, I cannot seem to get a handle on creating something equivalent to the likes of select max(ref_num) from document where ref_num < '9000' in Elixir, or dropped down into SQLAlchemy from Elixir. The from_statement won't work, and nothing I've tried so far after reading Query Objects, assignmapper, Creating SQL Queries, etc is giving me joy. It feels like I'm on the verge of discovery but as if some subtle, obvious vital link is just eluding me. It seems that Elixir's Document.query() will give me a query object similar to SQLALchemy's session.query(Document), as mentioned in the SQLAlchemy documentation, but the document.c.ref_num type query/select won't work. I'm losing faith... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "SQLElixir" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlelixir?hl=en -~----------~----~----~----~------~----~------~--~---
