Re: Multiple Items

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18428
interpreted = N
texte = >Hello, > > I'm trying to put together a WebCatatlog with a database similar >in structure to this: > >SKU Manufacturer Name Color >2345234 Jerseys Tiger In Field Red >2345235 Jerseys Tiger In Field White >2345236 Jerseys Tiger In Field Navy >6523243 Cafters Lily Pads Red >6523244 Cafters Lily Pads White >6523245 Cafters Lily Pads Yellow > >When a search is performed, I want to return only one listing of each >Manufacturer/Name item instead of all three versions of that item. I want >to then >put a listing of each color available on the details page and a checkbox >for each color on the shopping cart page. Can anyone share a solution to >this kind of Multiple Variety of Same Item type of data? Here, this should get you started. The outer search puts one item from each Manufacturer/Name on the page. The inner search creates a popup with the available colors for that item:[search db=products.db&eqManufacturerdatarq=Jerseys&eqNamedatarq=Tiger In Field&ManufacturerSumm=T] [founditems][search db=products.db&eqManufacturerdatarq=[manufacturer]&eqNamedatarq=[name]&neColordatarq=[blank]&ColorSumm=T] [/search][/founditems] [/search]Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: Multiple Items ( Donovan Brooke 2004)
  2. Re: Multiple Items ( Alan White 2004)
  3. Multiple Items ( Alan White 2004)
  4. Re: Adding multiple items to cart with one click? (Nitai @ ComputerOil 2003)
  5. Re: Adding multiple items to cart with one click? (Rene van der Velde 2003)
  6. Re: more multiple items to shopping cart (John Peacock 2000)
  7. more multiple items to shopping cart (Arturo Vargas 2000)
  8. Re: Adding multiple items to cart with one click? (Robert McPeak 2000)
  9. Re: Adding multiple items to cart with one click? (WebDNA Support 2000)
  10. Re: Adding multiple items to cart with one click? (Dale 2000)
  11. Re: Adding multiple items to cart with one click? (Robert McPeak 2000)
  12. Re: Adding multiple items to cart with one click? (Will Starck 2000)
  13. Adding multiple items to cart with one click? (Robert McPeak 2000)
  14. Adding multiple items to Cart (John Butler 1999)
  15. MISTAKE in last post: Re: Adding multiple items to Cart (Charles Kline 1999)
  16. Re: Adding multiple items to Cart (Charles Kline 1999)
  17. Adding multiple items to Cart (James Godwin 1999)
  18. Re: Trouble with adding multiple items to cart (PCS Technical Support 1999)
  19. Trouble with adding multiple items to cart (Dennis J. Bonsall, Jr. 1999)
  20. Re: Adding Multiple Items (PCS Technical Support 1999)
  21. Re: Adding Multiple Items (PCS Technical Support 1999)
  22. Adding Multiple Items (John Benn/PetsForum Group 1999)
  23. Adding multiple items to a DB from a search. (Joshuwa Jenkins 1998)
  24. Re: Multiple Items (Martin Gertz Bech 1998)
  25. Re: Multiple Items (Kenneth Grome 1998)
  26. Multiple Items (Michael Scott Davis 1998)
  27. Re: Adding multiple items to Cart at one time, & append contextproblem (Grant Hulbert 1998)
  28. Re: Adding multiple items to Cart at one time, & append contextproblem (John Hill 1998)
  29. Adding multiple items to Cart at one time, & append context problem (Tom Leitner 1998)
  30. Re: Adding Multiple Items to Shopping Cart from a Resultspage (Kenneth Grome 1997)
  31. Re: Adding Multiple Items to Shopping Cart from a Results page (Michael Winston 1997)
  32. Adding Multiple Items to Shopping Cart from a Results page (Jim McDonald 1997)
  33. Re: Calculating Shipping charges for multiple items andqtys > 1 (Kenneth Grome 1997)
  34. Calculating Shipping charges for multiple items and qtys > 1 (updates@virtualrep.com (Updates) 1997)
>Hello, > > I'm trying to put together a WebCatatlog with a database similar >in structure to this: > >SKU Manufacturer Name Color >2345234 Jerseys Tiger In Field Red >2345235 Jerseys Tiger In Field White >2345236 Jerseys Tiger In Field Navy >6523243 Cafters Lily Pads Red >6523244 Cafters Lily Pads White >6523245 Cafters Lily Pads Yellow > >When a search is performed, I want to return only one listing of each >Manufacturer/Name item instead of all three versions of that item. I want >to then >put a listing of each color available on the details page and a checkbox >for each color on the shopping cart page. Can anyone share a solution to >this kind of Multiple Variety of Same Item type of data? Here, this should get you started. The outer search puts one item from each Manufacturer/Name on the page. The inner search creates a popup with the available colors for that item:[search db=products.db&eqManufacturerdatarq=Jerseys&eqNamedatarq=Tiger In Field&ManufacturerSumm=T] [founditems][search db=products.db&eqManufacturerdatarq=[manufacturer]&eqNamedatarq=[name]&neColordatarq=[blank]&ColorSumm=T] [/search][/founditems] [/search]Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://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:

Re:2nd WebCatalog2 Feature Request (1996) problems with 2 tags shakur (1997) PIXO (1997) [OT] Ratings comparison? (2003) Multiple cart additions (1997) range searching (1998) Separate SSL Server (1997) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) contextual shownext (1998) Emailer (1997) problems with 2 tags shakur (1997) WebDNA performance comparisons? (2004) [OT] Tiny bit of java help please (2005) Multiple Purchase (2002) SKU Question (1999) [ot] Setting up OS X To Serve To Windows (2004) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) Forcing price recalculation in shopping cart (1998) can't find the pdf (1999) Quitting WebMerchant ? (1997)