Searching multiple databases

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21955
interpreted = N
texte = I need to construct a search through multiple databases and come up with a list of items that returntrue if the conditions of both searches are met. My actual searches are pretty complex (both inner and outer) involving dates and group searches etc. so I've created a simple example for illustration: Database A sku color size 1 blue m 2 green m 3 white mDatabase B sku material texture price 1 cotton smooth 18 2 silk ribbed 15 3 silk smooth 15Now, what I need is to search for all records that are the size m but not the color green in database A and also have a smooth texture and made of silk and a price of less than 16 which are values stored in database B and then return that list of skus. So in this case my result would be sku #3.Is it possible to somehow nest this search? If so, how would I structure the searches? If not what technique would I emply to make this work? Thanks in advance Marty Schmid Associated Messages, from the most recent to the oldest:

    
  1. Re: Searching Multiple Databases (Eric palhof 2000)
  2. Re: Searching Multiple Databases (Kenneth Grome 2000)
  3. Re: Searching Multiple Databases (Eric palhof 2000)
  4. Re: Searching Multiple Databases (WebDNA Support 2000)
  5. Re: Searching Multiple Databases (Eric palhof 2000)
  6. Re: Searching Multiple Databases (WebDNA Support 2000)
  7. Searching Multiple Databases (Eric palhof 2000)
  8. Re: Searching multiple databases (Kenneth Grome 1998)
  9. Re: Searching multiple databases (Kenneth Grome 1998)
  10. Searching multiple databases (Marty Schmid 1998)
  11. Re: searching multiple databases (Kenneth Grome 1997)
  12. Re: searching multiple databases (Brian B. Burton 1997)
  13. Re: searching multiple databases (Raymond Hatch 1997)
  14. Re: searching multiple databases (Kenneth Grome 1997)
  15. Re: searching multiple databases (Grant Hulbert 1997)
  16. searching multiple databases (Raymond Hatch 1997)
  17. Re: searching multiple databases in single search (Sandra L. Pitner <76501.3521@CompuServe.COM> 1997)
  18. Re: searching multiple databases in single search (Kenneth Grome 1997)
  19. searching multiple databases in single search (Sandra L. Pitner <76501.3521@CompuServe.COM> 1997)
  20. Re: Searching multiple Databases (John Hill 1997)
  21. Re: Searching multiple Databases (Grant Hulbert 1997)
  22. Searching multiple Databases (Michael Winston 1997)
I need to construct a search through multiple databases and come up with a list of items that returntrue if the conditions of both searches are met. My actual searches are pretty complex (both inner and outer) involving dates and group searches etc. so I've created a simple example for illustration: Database A sku color size 1 blue m 2 green m 3 white mDatabase B sku material texture price 1 cotton smooth 18 2 silk ribbed 15 3 silk smooth 15Now, what I need is to search for all records that are the size m but not the color green in database A and also have a smooth texture and made of silk and a price of less than 16 which are values stored in database B and then return that list of skus. So in this case my result would be sku #3.Is it possible to somehow nest this search? If so, how would I structure the searches? If not what technique would I emply to make this work? Thanks in advance Marty Schmid Marty Schmid

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

verify online (1997) Secure server question (1997) serial number not working (1998) Thanks Grant (1997) GD Scumbucket Spammer (2004) [WriteFile] problems (1997) [WebDNA] How much does it cost now? (2008) Help! WebCat2 bug (1997) using showpage and showcart commands (1996) [random] only for 1-100??? (1997) Problems with ErrorLog on Linux (2000) New user...how do I create URLs from form fields? (2000) Frames (1997) WebCatalog2 Feature Feedback (1996) totals (1997) GuestBook example (1997) searching multiple databases (1997) Google does it... can WebDNA? Showing only the section (2003) Please.. copies of Digest for 7/29 and 7/30? (1997) please unsubscribe me! (2000)