I'm struggling with getting the syntax right for criteria. I'm attempting to search by the first letter of all last names in my db. If anybody knows the correct syntax for my criteria combination, could you please write a response? Thanks a lot.
Joined: Apr 11, 2006
I found something promising, but it still not working. Right now I have:
def criteria = "from Persons as p where p.LastName like ?"
def persons = Persons.findAll(criteria, [params.selected])