Re: Searching multiple databases

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 21958
interpreted = N
texte = >Database A >sku color size >1 blue m >2 green m >3 white m > >Database B >sku material texture price >1 cotton smooth 18 >2 silk ribbed 15 >3 silk smooth 15>Is it possible to somehow nest this search?Yes, but I would NOT nest them, instead I would do them in sequence, it's probably faster than nesting.>How would I structure the searches?Perform a search on db=A first, then create a variable called [skuList] to use in your search on db=B. Here's an example:[search db=B&eqmaterialdatarq=silk&eqtexturedatarq=smooth&woskudatarq=[skuList]] [founditems] Results matching *both* searches will appear here ... [/founditems] [/search]Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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)
>Database A >sku color size >1 blue m >2 green m >3 white m > >Database B >sku material texture price >1 cotton smooth 18 >2 silk ribbed 15 >3 silk smooth 15>Is it possible to somehow nest this search?Yes, but I would NOT nest them, instead I would do them in sequence, it's probably faster than nesting.>How would I structure the searches?Perform a search on db=A first, then create a variable called [skuList] to use in your search on db=B. Here's an example:[search db=B&eqmaterialdatarq=silk&eqtexturedatarq=smooth&woskudatarq=[skuList]] [founditems] Results matching *both* searches will appear here ... [/founditems] [/search]Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Kenneth Grome

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:

[WebDNA] WebDNA7 and mod_fcgi (2013) WebCatalog for guestbook ? (1997) WebCatalog can't find database (1997) Help SM: Duplicate cart #'s - still! (2003) Sendmail Enigma (2004) WebCatalog for Postcards ? (1997) The beginning (1997) problems with WebCat-Plugin () RE: Nt's Latest? (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Re:listfiles-looking for slick solution (1997) form data submission gets truncated (1997) shownext (1997) Prices coming up 0.00 (2001) Payment Processors (2005) Variable prices and Formulas.db (1997) no template caching (1997) Interfacing WebMerchant to www.fedex.com (1997) Summary search -- speed (1997) [WebDNA] Upper ASCII and charset [OT] (2016)