For this assignment you can assume they are all "And". Meaning if you are search on two different fields, then for the record to be a match it must have both those fields matching the search criteria. Mark
The assignment says: It must allow the user to serach the data for all records, or for records where the name and/or location fields exactly match values specified by the user. If findByCriteria serach by "and", when a user provide bothe name and location, I have to call bindByCriteria 2 times and provide name and location seperately? Peter
Peter Yunguang Qiu
Joined: Nov 22, 2003
if serach 2 times, it might find some duplicated records if findByCriteria serch using "or", it will be easier when search by name and/or location. Am I right? Peter
Peter - You don't have to call the search 2 different times. The findByCriteria method (at least in my specs) takes a String array of criteria. So, you would be sending both your name and location criteria into the method in one call, and the search method can then do its thing. Hope that helps. TJ
Hi Peter, About the "and/or" issue in searching, I cannot tell you much more than what I wrote in this thread. I think it should help you to find a way to avoid performing the search twice. Best, Phil.