Hi, David. What do you think about JPA approach to joins, which can be adapted to Mapper like this:
Documents.findAll(By(Document.name, "somename"), Join(Document.category)) The objects in the returned list will have document.category.obj already preloaded. Can this become a viable approach? On Mon, Dec 1, 2008 at 11:42 PM, David Pollak <[EMAIL PROTECTED] > wrote: > > > On Thu, Oct 9, 2008 at 9:46 AM, Charles F. Munat <[EMAIL PROTECTED]> wrote: > >> >> Is it possible to do joins in Lift Mapper? >> >> For example, I have a Category class that has a name and position (an >> int). I have a Document class that has a name, a URI, and a Category. >> >> I want to query the database and get back all the Documents *and their >> associated Categories* and I'd like to sort the results by the >> Category.position. >> >> Ideas? > > > This is one of the places that having a strongly typed language is less > than optimal. Because we can't return a Document or a (Document, Category) > depending on the query, this kind of query is difficult. > > So, the best I can suggest is running two queries (as I suggested on > another thread today.) > > Sorry. > > David > > >> >> >> Chas. >> >> >> > > > -- > Lift, the simply functional web framework http://liftweb.net > Collaborative Task Management http://much4.us > Follow me: http://twitter.com/dpp > Git some: http://github.com/dpp > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Lift" 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/liftweb?hl=en -~----------~----~----~----~------~----~------~--~---
