Sorry, Lift's mapper doesn't let you do this. :-( On Fri, Sep 4, 2009 at 9:01 AM, José María <josemariar...@gmail.com> wrote:
> > Hi, > > Is it possible to do subqueries with Mapper? > > If I have something like: > > Product.findAll(...) > > How can I use it as subquery for another query? What I'm trying to do > is: > > "Select * from Table order by random() limit 6" > > But this doesn't works in modern SQL implementations (Oracle, PG 8.4) > so what I need to do is: > > "Select * from (select * from Table) order by random limit 6" > > Cheers. > > > -- 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 -~----------~----~----~----~------~----~------~--~---