• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

NX(contractors)Search in DB, misunderstanding.

 
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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 ]
 
Bartender
Posts: 1872
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Ok, OK, Philippe, I see .
 
If you want to look young and thin, hang around old, fat people. Or this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic