Re: searching multiple databases
This WebDNA talk-list message is from 1997
numero = 14802
interpreted = N
texte = It has been my experience in building shopping sites with relational product databases that webcatalog is not good at dealing with a detail page with multple SKUs on it. (no flames please.) Anyway, I always set up a parent database with a field PID (parentID - It can be any unique range of values) with a child database that contains SKU, size (or color), price, taxable, and Unitshipcost. The parent record holds the picture tags, the descriptions, all the other stuff, with the child record only haveing the bare minimum on unique info. to see two examples: http://www.kickpunch.com/ http://www.bigappleherp.com/Brian B. Burton BOFH --------------------------------------------------------------- MMT Solutions - Specializing in Online Shopping Solutions 973-808-8644 http://www.safecommerce.com---------- From: Grant Hulbert
To: WebDNA-Talk@smithmicro.com Subject: Re: searching multiple databases Date: Mon, 17 Nov 1997 14:28:02 >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 you View Source?[search main database] [founditems] <-- loops thru all shirts found [search colors database&eqSKUdata=[sku]] <-- [sku] comes from main database [founditems] <-- loops thru all matching colors [/founditems] [/search] [/founditems] [/search]Try just doing the inner search and manually setting the sku in the URL when you hit that page. This should tell you if you've got the right logic.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest: To: WebDNA-Talk@smithmicro.com Subject: Re: searching multiple databases Date: Mon, 17 Nov 1997 14:28:02 >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 you View Source?[search main database] [founditems] <-- loops thru all shirts found [search colors database&eqSKUdata=[sku]] <-- [sku] comes from main database [founditems] <-- loops thru all matching colors [/founditems] [/search] [/founditems] [/search]Try just doing the inner search and manually setting the sku in the URL when you hit that page. This should tell you if you've got the right logic.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Brian B. Burton
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:
Secure Server basic question... (1997) Cookies (1999) japanese characters (1997) WebCAT has the devil in it! (2003) one item in several different categories? (2000) WebCat2 beta FTP site (1997) [BULK] [WebDNA] [BULK] WebDNA 7 - Ready or Not ?? I'm not sure... (2011) sorting... (2003) [WebDNA] Ubuntu 10.4 & WebDNA 6.2 (2011) Max Record length restated as maybe bug (1997) Help formatting search results w/ table (1997) pacific-coast or starnine? (1998) Setting up shop (1997) [random] only for 1-100??? (1997) Free pack for the New UPS ratings and services tool (2000) sort problems....bug or brain fart? (1997) [searchString] (1997) RE: IIS4b2 and WebCatalog b19 (1997) [LOOKUP] (1997) WebDNA Programming question - Help Please (2001)