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 Solution11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMasterSan Diego, CA 92128 | SiteGuard619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Associated Messages, from the most recent to the oldest:
>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 Solution11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMasterSan Diego, CA 92128 | SiteGuard619/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)