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.