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:

Monitoring Script (2008) really wierd browser truncating (1997) Not really WebCat (1997) Question about [encrypt] (1998) New command suggestion (1997) Sorting Numbers (1997) OT - How to pay commissions to non US affiliates? (2000) tricky embedded[showifs/hideifs] (w/ code.. long) (2000) sendmail error (2001) WebCat2 - many [carts] on one template page? (1997) Emailer again (1997) Running _every_ page through WebCat ? (1997) [WebDNA] JSONStore Levels (2020) Use of & in text areas.... (1998) OT-JS question (2001) problems with 2 tags (1997) Great product and great job ! (1997) [WebDNA] Detect HTTPS (2009) User / Pass in TCP connect (2007) [WebDNA] Some JS help please (2010)