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