• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

NX(contractors)Search in DB, misunderstanding.

 
Peter Kovgan
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
Philippe Maquet
Bartender
Posts: 1872
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Peter,
This thread, posted yesterday by Nicholas may help you.
Best,
Phil.
 
Peter Kovgan
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Second question:

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.
 
Philippe Maquet
Bartender
Posts: 1872
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Peter Kovgan
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ok, OK, Philippe, I see .
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic