Two different places in my task description give me completely different instructions(differences in bold): 1)User Interface: It must allow the user to search the data for all records, or for records where the name and/or location fields exactly match values specified by the user. 2)DBMain interface instructions to find method:
What to do in the case: doing "LIKE"(SQL terminology) search in DB and send ALL "LIKE" data to client, end then make second search into the client side by "exactly match(=)"? Please, help. [ November 18, 2003: Message edited by: Peter Kovgan ]
User Interface: It must allow the user to search the data for all records, or for records where the name and/or location fields exactly match values specified by the user.
So pull all data with "OR" criteria on DB side and send all data to client, where client will make another search with "AND" criteria? The signature of find method has not any argument for AND or ALL.
Hi Peter, Sorry, but it looks like the answer to your second question was already given in the thread I mentioned above ... If you have further questions on the same subject, maybe it could be easier to post them in Nicholas's thread. Best, Phil.