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:
SSL, WebSTAR, WebCatalog (1998)
form data submission gets truncated (1997)
UPDATEDONE question ... (1998)
Bad dates/times on a Windows server? (2002)
Conversion Database Blues (2001)
Re:No Data (1997)
Bug or syntax error on my part? (1997)
[sendmail] questions... (1997)
ShowNext (1997)
Error: SQL not supported (2001)
SQL Error 22003 : Found the workaround (2001)
Authenticate (1997)
Bug Report, maybe (1997)
Forcing a NEWCART (1997)
Separate SSL Server (1997)
Hiding HTML and breaking the page (1997)
Quitting WebMerchant ? (1997)
Frames and WebCat (1997)
ShipCost Data Base (1998)
[WebDNA] New problem with [ShowNext] (2010)