On Thu, Aug 13, 2009 at 12:41 PM, harryh <har...@gmail.com> wrote: > > I have 3 classes like so > > class Foo extends LongKeyedMapper[Foo] with IdPK > def getBazes = { > Baz.findAll(...) > } > }
Baz.findAll(In.fk(Baz.barid, By(Bar.fooid, this.id))) > > > class Bar extends LongKeyedMapper[Bar] with IdPK > object fooid extends MappedLongForeignKey(this, Foo) > } > > class Baz extends LongKeyedMapper[Baz] with IdPK > object barid extends MappedLongForeignKey(this, Bar) > } > > How do I write Baz.findAll(...) so it will give me all the Bazes that > point to any Bars that point to the Foo. In SQL I would write > something like this: > > SELECT * FROM bazzes WHERE bazzes.barid = bars.id AND bars.fooid = > 111; (where 111 is foo.id) > > I feel like I should be using ByRef here? But it's not clear to me > how to do it. > > -harryh > > > > -- Lift, the simply functional web framework http://liftweb.net Beginning Scala http://www.apress.com/book/view/1430219890 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 liftweb@googlegroups.com To unsubscribe from this group, send email to liftweb+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/liftweb?hl=en -~----------~----~----~----~------~----~------~--~---