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:
WebCat/Typhoon Status under Windows (1998)
Mixing and/or in searches (1998)
JS Question - Print (2007)
remotely add + sign (1997)
PCS Frames (1997)
Ok here is a question? (1997)
Who needs Yoda! (2002)
Talk List Suggestions (1997)
Examples of cross-selling with WebCatalog? (1998)
RE: [WebDNA] OS and version (2019)
WebCat2b13MacPlugIn - syntax to convert date (1997)
OT: test (1998)
Auto entering Friday's date in a field (2002)
Browser Check for WebDNA compatability (1999)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
authenticate (1999)
WebCat2 several catalogs? (1997)
Almost a there but..bye bye NetCloak (1997)
[HIDEIF] inside [FOUNDITEM] (1997)
WebCatalog for guestbook ? (1997)