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:

WCS Newbie question (1997) Separate SSL Server (1997) flushing databases (2003) Frames and WebCat (1997) Internet Explorer 6 Form problems (2005) Opinion Poll Please (2002) Cookies and WebCat?? (1999) insert graphic in email (2000) WCS Newbie question (1997) WebCat2 beta FTP site (1997) code to phantom spacing (2001) Using Plug-In while running 1.6.1 (1997) Multiple email troubles (solved) (2001) Error Lob.db records error message not name (1997) How is it done? (1998) WebCat2b12 - nesting [tags] (1997) Grep Help (2007) Using Cookie for client specific info? (1997) Payment Processors (2005) Displaying Location (1997)