Never mind, it just needed a type hint:

val users:List[User] = User.findAll(In(User.id, Tag.user, By
(Tag.tagType, this), OrderBy(Tag.created_at, Descending), MaxRows[Tag]
(100)))

On Nov 30, 9:17 pm, Trevor Austin <traus...@gmail.com> wrote:
> I have some slow code:
>
> val users:List[User] = Tag.findAll(By(Tag.tagType,this), OrderBy
> (Tag.created_at, Descending), MaxRows(100), PreCache(Tag.user)).map
> (_.user.obj.open_!)
>
> That I turned into faster ugly code:
>
> val users:List[User] = User.findAll(BySql("WHERE id IN (SELECT TOP 100
> user from Tag where tagType = ? ORDER BY created_at DESC )",
> IHaveValidatedThisSQL("trevoraustin","2009-11-30"), this.id))
>
> That I want to turn into faster nicer code:
>
> val users:List[User] = User.findAll(In(User.id, Tag.user, By
> (Tag.tagType, this), OrderBy(Tag.created_at, Descending), MaxRows
> (100)))
>
> But I get the error:
>
> "no implicit argument matching parameter type (Product with
> net.liftweb.mapper.QueryParam[_ <: com.udorse.lift.model.Tag]) =>
> net.liftweb.mapper.QueryParam[com.udorse.lift.model.Tag] was found."
>
> If I try just:
>
>  val users:List[User] = User.findAll(In(User.id, Tag.user, By
> (Tag.tagType, this), OrderBy(Tag.created_at, Descending)))
>
> Without the MaxRows it compiles fine.  Is there a limit on the
> QueryParams I can use with In?  Am I doing something else wrong?

--

You received this message because you are subscribed to the Google Groups 
"Lift" group.
To post to this group, send email to lift...@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