Re: Searching multiple databases
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21957
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:
forming a SKU (1999)
Exclamation point (1997)
Setting up shop (1997)
[OT] Any perl gurus out there? (2006)
WebSite and *NO* Authentication Dialog Box!!? (1998)
Trouble with formula.db (1997)
Displaying photo attached to first record (1997)
form data submission gets truncated (1997)
Email check problems (1999)
Writing to disk (1999)
Images in WebCat (2000)
summ=T (2003)
Banners and sort of random display (1997)
Re(2): Problem about [CART] number (1998)
Interfacing WebMerchant to www.fedex.com (1997)
NT Woes (1997)
Simple Store (2000)
Two submit buttons ? (1997)
[ModDate] & [ModTime] ? (1997)
Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997)