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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://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)