Re: Comments in db?

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12840
interpreted = N
texte = >Is it possible to have the unique field have a name other than SKU? SKU is a >certain item in product inventory. That might make sense in a flatfile, but now >since there's multiple tables, a field named SKU can be confusing, esp. in >non-inventory tables. I realize for backwards compatibility, this might be a >difficult change.SKU is only necessary for databases that are going to be used to put items into a shopping cart. That's how the cart knows what price to lookup.For any other kind of database, you can use any fieldname you want. You aren't even required to have a unique field at all. You'll notice the taxRate database doesn't contain a SKU field.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: Comments in db? (Sandra L. Pitner <76501.3521@CompuServe.COM> 1997)
  2. Re: Comments in db? (Grant Hulbert 1997)
  3. Re: Comments in db? (Sandra L. Pitner <76501.3521@CompuServe.COM> 1997)
  4. Re: Comments in db? (Grant Hulbert 1997)
  5. Re: Comments in db? (Grant Hulbert 1997)
  6. Re: Comments in db? (Kevin Furuta 1997)
  7. Re: Comments in db? (Kenneth Grome 1997)
  8. Re: Comments in db? (Grant Hulbert 1997)
  9. Re: Comments in db? (Grant Hulbert 1997)
  10. Re: Comments in db? (Kevin Furuta 1997)
  11. Re: Comments in db? (Kenneth Grome 1997)
  12. Comments in db? (Kevin Furuta 1997)
>Is it possible to have the unique field have a name other than SKU? SKU is a >certain item in product inventory. That might make sense in a flatfile, but now >since there's multiple tables, a field named SKU can be confusing, esp. in >non-inventory tables. I realize for backwards compatibility, this might be a >difficult change.SKU is only necessary for databases that are going to be used to put items into a shopping cart. That's how the cart knows what price to lookup.For any other kind of database, you can use any fieldname you want. You aren't even required to have a unique field at all. You'll notice the taxRate database doesn't contain a SKU field.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Grant Hulbert

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:

[returnraw] and form variables (1998) frames & carts (1997) Server crash (1997) FEATURE REQUEST: Auto Resizing of images (2002) UPPERCASE (1997) RE: Promise of future help (1998) WC2b15 File Corruption (1997) Quit revisited (1997) [SearchString] problem with [search] context (1997) Multiple cart additions (1997) Closing Databases (1998) [search] & [encrypt]/[decrypt] (2001) syntax question, not in online refernce (1997) Searching multiple fields (1997) Calendar using WebCatalog? (1997) WebCat2b15MacPlugin - showing [math] (1997) [WebDNA] GREP question (2010) Problems with cybercash (2000) (no subject) (1997) WebCommerce: Folder organization ? (1997)