Re: forming a SKU
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23550
interpreted = N
texte = A technique we use in a lot of our databses (we do a lot on non-commerce stuff and do not necessarily use cart tokens) is to use a NEXT SKU database to assign sku's - and we can use any name for the SKU that we want, like Cust_ID for example.The code is modular and easy to drop into any application.Simply put, we get the sku value from the next.db, increment by one and save the record, for each transaction. The db always has just a single value, and any number of hits against the system always generates a unique numeric number in sequence.Larry======================================================================== Hewitt Consulting... Business Internet Solutions ======================================================================== www.hewittco.com Larry Hewitt larryh@hewittco.com Hewitt Consulting voice: 360/740-1090 Managing Partner cell: 360/508-6014 fax: 360/740-0998
Associated Messages, from the most recent to the oldest:
A technique we use in a lot of our databses (we do a lot on non-commerce stuff and do not necessarily use cart tokens) is to use a NEXT SKU database to assign sku's - and we can use any name for the SKU that we want, like Cust_ID for example.The code is modular and easy to drop into any application.Simply put, we get the sku value from the next.db, increment by one and save the record, for each transaction. The db always has just a single value, and any number of hits against the system always generates a unique numeric number in sequence.Larry======================================================================== Hewitt Consulting... Business Internet Solutions ======================================================================== www.hewittco.com Larry Hewitt larryh@hewittco.com Hewitt Consulting voice: 360/740-1090 Managing Partner cell: 360/508-6014 fax: 360/740-0998
Larry Hewitt
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:
WCS Newbie question (1997)
Upgrading old WebCat Database Files (1997)
WebCat name recognition (1998)
Admin Edit prob. (1997)
[index] (1997)
Mac OS and 3.0.5b12 bug report (1999)
[WebDNA] can webdna's [grep] find and replace ONLY the literal "+" char? (2012)
Uh...can someone help me out with the b10? (1997)
OT: Verbose messages - Web*4.2 (2000)
[carts] and databases (1997)
WebCatalog NT beta 18 problem (1997)
Searchable list archive (1997)
Further on formula.db failure to calculate shipCost (1997)
attn: smitmicro - cart limitation (2002)
Email encryption (1998)
2.0 Info (1997)
WC2.0 Memory Requirements (1997)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)
Re:What file? (1997)
RE: Netscape v. IE (1997)