Is there any way to do this, but have it match on OR instead of AND? User.findAll(Like(User.firstName, "%" + q + "%"), Like(User.lastName, "%" + q + "%"))
I couldn't see a way to do it, so I tried out BySQL instead. However, when I put in the % wildcards I get a sql exception.. User.findAll( BySql("users.email like '%?%'", IHaveValidatedThisSQL("george", "2009-10-26"), q) ) So how do you specify the wildcards? thanks george --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---