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:
[ShowCart] and GET vs. POST (1997)
2.1 pricing? (1998)
Interesting speed comparison .. (2003)
select multiple (1997)
Possible Shownext from Listfiles???? (2000)
Bug when including a db file ... ? (2000)
Summing fields (1997)
Pithy questions on webcommerce & siteedit (1997)
Associative lookup style? + bit more (1997)
Weird problems with [SHOWIF]s (1997)
[WebDNA] Non-numbers entered into a field that asks for a number (2008)
OT: Portland Oregon (2002)
Re2: frames & carts (1997)
Searching multiple fields from one form field (1997)
Sorting by date (1997)
Trouble with formula.db + more explanation (1997)
problems with 2 tags (1997)
searching by date (1998)
Problems passing [SKU] with $Replace in 2.0 (1997)
Proper file locations (1997)