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
-~----------~----~----~----~------~----~------~--~---

Reply via email to