Multiple Items

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 18425
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 YellowWhen 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?Thanks, Mike Davis Network 13 Content-Type: text/x-vcard; charset=us-ascii; name=vcard.vcf Content-Transfer-Encoding: 7bit Content-Description: Card for Michael Scott Davis Content-Disposition: attachment; filename=vcard.vcfAttachment converted: Hard Disk:vcard.vcf 4 (TEXT/ttxt) (00010398) 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 YellowWhen 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?Thanks, Mike Davis Network 13 Content-Type: text/x-vcard; charset=us-ascii; name=vcard.vcf Content-Transfer-Encoding: 7bit Content-Description: Card for Michael Scott Davis Content-Disposition: attachment; filename=vcard.vcfAttachment converted: Hard Disk:vcard.vcf 4 (TEXT/ttxt) (00010398) Michael Scott Davis

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 date math (1997) WebTV (1998) setting taxable to true (1997) WebCatalog usage (1997) MasterCounter Help (1998) [WebDNA] Failed to aquire lock on database - Possible deadlock averted (2011) RE: Upload and WebCat (1998) Replace Statement (1997) Updating fields from different platforms (1998) ODBC Help (2004) [ShowIf] and empty fields (1997) Secure Server (1997) Three new problems, maybe a fourth (1997) RE: HTTP Header info (1997) Getting Emailer to send mail (1997) Extended [ConvertChars] (1997) Re:2nd WebCatalog2 Feature Request (1996) apparently to problem isolated (1997) PCS Frames (1997) [WriteFile] problems (1997)