Re: Dubble Sku's in a Database

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23539
interpreted = N
texte = >Is there a way to elimite the problem with dubble skus in a database any >suggestions on how this can be doneOK, here's the general idea:1) Do a lookup into the database for the incoming sku, 2) if the sku is not found, then append the record[ShowIf NotFound=[lookup db=xx.db&lookInField=sku&value=[sku]&returnfield=sku¬Found=NotFound]] [Append db=xx.db]sku=[sku][/Append] [/ShowIf]Technical Support | ==== eCommerce and Beyond ==== 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:

    
  1. Re: Dubble Sku's in a Database (Joseph Pugh 1999)
  2. Re: Dubble Sku's in a Database (Joseph Pugh 1999)
  3. Re: Dubble Sku's in a Database (Joseph Pugh 1999)
  4. Re: Dubble Sku's in a Database (Kenneth Grome 1999)
  5. Re: Dubble Sku's in a Database (Grant Hulbert 1999)
  6. Re: Dubble Sku's in a Database (Donovan Rittenbach 1999)
  7. Re: Dubble Sku's in a Database (Kenneth Grome 1999)
  8. Re: Dubble Sku's in a Database (Kenneth Grome 1999)
  9. Re: Dubble Sku's in a Database (Kenneth Grome 1999)
  10. Re: Dubble Sku's in a Database (Peter Ostry 1999)
  11. Re: Dubble Sku's in a Database (PCS Technical Support 1999)
  12. Re: Dubble Sku's in a Database (The Mooseman 1999)
  13. Re: Dubble Sku's in a Database (Joseph Pugh 1999)
  14. Re: Dubble Sku's in a Database (Joseph Pugh 1999)
  15. Re: Dubble Sku's in a Database (Kenneth Grome 1999)
  16. Re: Dubble Sku's in a Database (PCS Technical Support 1999)
  17. Re: Dubble Sku's in a Database (Joseph Pugh 1999)
  18. Re: Dubble Sku's in a Database (PCS Technical Support 1999)
  19. Re: Dubble Sku's in a Database (Kenneth Grome 1999)
  20. Re: Dubble Sku's in a Database (Joseph Pugh 1999)
  21. Re: Dubble Sku's in a Database (Kenneth Grome 1999)
  22. Dubble Sku's in a Database (Joseph Pugh 1999)
>Is there a way to elimite the problem with dubble skus in a database any >suggestions on how this can be doneOK, here's the general idea:1) Do a lookup into the database for the incoming sku, 2) if the sku is not found, then append the record[ShowIf NotFound=[lookup db=xx.db&lookInField=sku&value=[sku]&returnfield=sku¬Found=NotFound]] [Append db=xx.db]sku=[sku][/Append] [/ShowIf]Technical Support | ==== eCommerce and Beyond ==== 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/ PCS Technical Support

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:

[OT] HTML EMAIL program wanted (1999) ListFiles (1998) [WebDNA] Calculate Cube root (2012) Help formatting search results w/ table (1997) [cart] (1998) [ShowNext] (1997) OT Hosting Q again. (2002) WCS Newbie question (1997) TRAINING videos - Prove IT. (1998) Too Much Rootbeer Free Offer (1997) ShipCosts database (1997) Talk Archives down? (2002) More than one db with the same namn (was: WC2f3) (1997) syntax question, not in online refernce (1997) searchable list archive (1997) WebCat2.0 [format thousands .0f] no go (1997) Cart Already Submitted (2003) Webstar 1.3.1 PPC (1997) Webmerchant email misinterpreted tags (1998) No messages for a week? (2000)