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
-~----------~----~----~----~------~----~------~--~---

Reply via email to