Re: searching multiple databases
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14801
interpreted = N
texte = At 02:28 PM 11/17/97, you wrote:>>I'm attempting to search another database using the [search] command in my>>template based on the sku of a product selected on a previous page. If a>>customer clicks on Shirt, I need to show on Detail.tmpl color options, I>>had thought that building a colors.db and haveing fields sku and color,>>hoping to search that db by that perticular sku selected and returning a>>
menu with the perticular colors available to that item.>>>>I tried>>[search db=colors.db&geSKUdata=[sku]]>>[founditems][Color][/founditems] >>Yes, that's the right idea (make sure you close off that inner search with[/search], too). It what way is it not working? What do you see when youView Source?>>[search main database]> [founditems] <-- loops thru all shirts found> [search colors database&eqSKUdata=[sku]] <-- [sku] comes from maindatabase> [founditems] <-- loops thru all matching colors> [/founditems]> [/search]> [/founditems]>[/search]>>Try just doing the inner search and manually setting the sku in the URLwhen you hit that page. This should tell you if you've got the right logic.Grant, I'm using a $search in a hyperlink not a [search] to the master database,so I don't need a [/search] on this part right?I tried replacing the [sku] with an actual sku of the colors database andwhen I view code I get The [color] isn'tbeing replace with the data from the database but it is being removed?I tried re-doing the database incase I made a error but still samething.Not sure.Ray
Associated Messages, from the most recent to the oldest:
At 02:28 PM 11/17/97, you wrote:>>I'm attempting to search another database using the [search] command in my>>template based on the sku of a product selected on a previous page. If a>>customer clicks on Shirt, I need to show on Detail.tmpl color options, I>>had thought that building a colors.db and haveing fields sku and color,>>hoping to search that db by that perticular sku selected and returning a>> menu with the perticular colors available to that item.>>>>I tried>>[search db=colors.db&geSKUdata=[sku]]>>[founditems] [Color][/founditems] >>Yes, that's the right idea (make sure you close off that inner search with[/search], too). It what way is it not working? What do you see when youView Source?>>[search main database]> [founditems] <-- loops thru all shirts found> [search colors database&eqSKUdata=[sku]] <-- [sku] comes from maindatabase> [founditems] <-- loops thru all matching colors> [/founditems]> [/search]> [/founditems]>[/search]>>Try just doing the inner search and manually setting the sku in the URLwhen you hit that page. This should tell you if you've got the right logic.Grant, I'm using a $search in a hyperlink not a [search] to the master database,so I don't need a [/search] on this part right?I tried replacing the [sku] with an actual sku of the colors database andwhen I view code I get The [color] isn'tbeing replace with the data from the database but it is being removed?I tried re-doing the database incase I made a error but still samething.Not sure.Ray
Raymond Hatch
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:
problems with 2 tags shakur (1997)
oops private message leaked into talk list (1997)
Getting total number of items ordered (1997)
Just Testing (1997)
WC Database Format (1997)
[protect] and identification (2008)
[include ...] behavior (1997)
Grant, please help me ... (1997)
Online reference (1997)
Newbie problem blah blah blah (1997)
Personal Web Server (1998)
Webcatalog server support (1997)
Searching for a search solution (2000)
RequiredFields notes ... (1997)
WebCat2 - storing unformatted date data? (1997)
SSL and reg web* (1997)
uploads (2000)
[FoundItems] solved - thanks (1997)
showif and cart (1998)
hmmm (2006)