Re: Sku numbers

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11622
interpreted = N
texte = >>>>Is there a way for new records appended by WebCat 2.0 >>>>to generate sku numbers? > >>The code I use is as follows: >> > >Ken wrote: ---------- >A more reliable method for creating a unique record number is this: > > > >... because [cart] will create a unique number even when two or more people >attempt to create a new record in the very same second.The trouble I found with using a cart value for a SKU is that if a user is adding multiple records they might use the browsers back button to return to the add_record.tmpl. If that happens then they will entering records with identical cart values.I'm not sure what the ideal technique would be as both cart and date have their inherent drawbacks. I decided that the chances of having records entered at the exact same second is less than the chance of someone using their back button. Perhaps Grant can advise us or perhaps give us a true random command or math context that we could compute with... Unless Ken, you being the WebDNA guru that you are, have found a way around the back button problem. -marty ____________________________________ | Marty Schmid | | -Artwerks- | | Design/Advertising/Web Publishing | | | | T. 619.274.5029 | | F. 619.274.5656 | | e-mail: marty@artwerks.com | |____________________________________| Associated Messages, from the most recent to the oldest:

    
  1. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  2. Re: Unique SKU Numbers (Kenneth Grome 2000)
  3. Re: Unique SKU Numbers (Glenn Busbin 2000)
  4. Re: Unique SKU Numbers (Glenn Busbin 2000)
  5. Re: Unique SKU Numbers (Aaron Chute 2000)
  6. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  7. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  8. Re: Unique SKU Numbers (Glenn Busbin 2000)
  9. Re: Unique SKU Numbers (Peter Ostry 2000)
  10. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  11. Re: Unique SKU Numbers (Clint Davis 2000)
  12. Re: Unique SKU Numbers (Derrick Puckett 2000)
  13. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  14. Re: Unique SKU Numbers (Glenn Busbin 2000)
  15. Re: Unique SKU Numbers (Nicolay Ramm 2000)
  16. Re: Unique SKU Numbers (Peter Ostry 2000)
  17. Re: Unique SKU Numbers (Joseph D'Andrea 2000)
  18. Unique SKU Numbers (Aaron Chute 2000)
  19. Re: Sku numbers (Kenneth Grome 1997)
  20. Re: Sku numbers (Marty Schmid 1997)
  21. Re: Sku numbers (Kenneth Grome 1997)
  22. Re: Sku numbers (Grant Hulbert 1997)
  23. Re: Sku numbers (Kenneth Grome 1997)
  24. Re: Sku numbers (Kenneth Grome 1997)
  25. Re: Sku numbers (Marty Schmid 1997)
  26. Re: Sku numbers (Kenneth Grome 1997)
  27. Re: Sku numbers (Marty Schmid 1997)
  28. Sku numbers (Grant Hulbert 1997)
>>>>Is there a way for new records appended by WebCat 2.0 >>>>to generate sku numbers? > >>The code I use is as follows: >> > >Ken wrote: ---------- >A more reliable method for creating a unique record number is this: > >[cart]> > >... because [cart] will create a unique number even when two or more people >attempt to create a new record in the very same second.The trouble I found with using a cart value for a SKU is that if a user is adding multiple records they might use the browsers back button to return to the add_record.tmpl. If that happens then they will entering records with identical cart values.I'm not sure what the ideal technique would be as both cart and date have their inherent drawbacks. I decided that the chances of having records entered at the exact same second is less than the chance of someone using their back button. Perhaps Grant can advise us or perhaps give us a true random command or math context that we could compute with... Unless Ken, you being the WebDNA guru that you are, have found a way around the back button problem. -marty ____________________________________ | Marty Schmid | | -Artwerks- | | Design/Advertising/Web Publishing | | | | T. 619.274.5029 | | F. 619.274.5656 | | e-mail: marty@artwerks.com | |____________________________________| Marty Schmid

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:

WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) AOL refuses some e-mails (2000) relational db question (2002) [WebDNA] WebDNA on W2k3 (2009) ShipCosts database (1997) Not really WebCat- (1997) Forms Search Questions (1997) Frames and WebCat (1997) Access and WebDNA (2002) PCS Frames (1997) setting line item numbers (1998) Banners (1997) Simple way to create unique SKU (1997) Running 2 two WebCatalog.acgi's (1996) Question re: FlushDatabases (1997) email address with spaces (2001) Counting Inventory (2003) Db design question (relational vs. flat?) (1998) Prevent multiple appends with Reload Button (1997) Putting a page between checkout and invoice (1999)