Re: unique ascending numbers

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 50195
interpreted = N
texte = I would guess that multiple cart numbers generated in the same epoc second are not necessarily ascending due to the random (not ascending) characters appended. Also, if one-per-second granularity is sufficient then why not use seconds since the epoc instead of the cart number? Another suggestion is to have a database with a single item (or create a new entry in prefs.db): the next available item number. (Be sure to lock the database file between retieval and update!)-Chris-----Original Message----- From: Joe D'Andrea [mailto:JoeDan@West21.com] Sent: Friday, May 09, 2003 2:12 PM To: WebDNA-Talk@talk.smithmicro.com Subject: Re: unique ascending numbers At 11:04 AM 5/9/03, Marc Kaiwi wrote: >...Yeah [cart] would be the perfect tool but I still need the >ascending set of numbers. Just out of curiosity I swear I thought >that [cart] used to produce an ever increasing number ...???Stop thinking of [cart] as a number. It sure do look like a number to you and me... but it ain't no number. It is unique and it is ascending, but it's not a number.~joe-- ____________________________________________________________ Joseph D'Andrea ~ http://www.west21.com/ ~ JoeDan@West21.com WEST21.com Internet services for the 21st Century webhosting ~ co-location ~ wireless access WebCat and MGI database programming ____________________________________________________________------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. ExclusiveLock (was: Re: unique ascending numbers) (Nitai @ ComputerOil 2003)
  2. Re: unique ascending numbers (Gary Krockover 2003)
  3. Re: unique ascending numbers (Nitai @ ComputerOil 2003)
  4. Re: unique ascending numbers (Scott Anderson 2003)
  5. Re: unique ascending numbers (Kenneth Grome 2003)
  6. Re: unique ascending numbers (Scott Anderson 2003)
  7. Re: unique ascending numbers (Kenneth Grome 2003)
  8. Re: unique ascending numbers (Kenneth Grome 2003)
  9. Re: unique ascending numbers (Kenneth Grome 2003)
  10. Re: unique ascending numbers (Laurent Bache 2003)
  11. Re: unique ascending numbers (John Peacock 2003)
  12. Re: unique ascending numbers (Laurent Bache 2003)
  13. Re: unique ascending numbers (John Peacock 2003)
  14. Re: unique ascending numbers (Chris List Recipient 2003)
  15. Re: unique ascending numbers (Joe D'Andrea 2003)
  16. Re: unique ascending numbers (Joe D'Andrea 2003)
  17. Re: unique ascending numbers (John Peacock 2003)
  18. Re: unique ascending numbers (Christer Olsson 2003)
  19. Re: unique ascending numbers (marc@kaiwi.com (Marc Kaiwi) 2003)
  20. Re: unique ascending numbers (Christer Olsson 2003)
  21. Re: unique ascending numbers (marc@kaiwi.com (Marc Kaiwi) 2003)
  22. Re: unique ascending numbers (marc@kaiwi.com (Marc Kaiwi) 2003)
  23. Re: unique ascending numbers (John Peacock 2003)
  24. Re: unique ascending numbers (Nitai @ ComputerOil 2003)
  25. Re: unique ascending numbers (marc@kaiwi.com (Marc Kaiwi) 2003)
  26. Re: unique ascending numbers (marc@kaiwi.com (Marc Kaiwi) 2003)
  27. Re: unique ascending numbers (Kenneth Grome 2003)
  28. Re: unique ascending numbers (Nitai @ ComputerOil 2003)
  29. Re: unique ascending numbers (marc@kaiwi.com (Marc Kaiwi) 2003)
  30. Re: unique ascending numbers (Nitai @ ComputerOil 2003)
  31. unique ascending numbers (marc@kaiwi.com (Marc Kaiwi) 2003)
I would guess that multiple cart numbers generated in the same epoc second are not necessarily ascending due to the random (not ascending) characters appended. Also, if one-per-second granularity is sufficient then why not use seconds since the epoc instead of the cart number? Another suggestion is to have a database with a single item (or create a new entry in prefs.db): the next available item number. (Be sure to lock the database file between retieval and update!)-Chris-----Original Message----- From: Joe D'Andrea [mailto:JoeDan@West21.com] Sent: Friday, May 09, 2003 2:12 PM To: WebDNA-Talk@talk.smithmicro.com Subject: Re: unique ascending numbers At 11:04 AM 5/9/03, Marc Kaiwi wrote: >...Yeah [cart] would be the perfect tool but I still need the >ascending set of numbers. Just out of curiosity I swear I thought >that [cart] used to produce an ever increasing number ...???Stop thinking of [cart] as a number. It sure do look like a number to you and me... but it ain't no number. It is unique and it is ascending, but it's not a number.~joe-- ____________________________________________________________ Joseph D'Andrea ~ http://www.west21.com/ ~ JoeDan@West21.com WEST21.com Internet services for the 21st Century webhosting ~ co-location ~ wireless access WebCat and MGI database programming ____________________________________________________________------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Chris List Recipient

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:

RAM variables (1997) Can this be done? (1997) remotely add + sign (1997) FM PRO Compatibility Issue - Single Database w/o Conversions (1997) MATH PROBLEM (1997) shipCost (1998) Loosing Quantity (2000) Database cloning, or possible hack? (2003) [Fwd: F3 database munching] (1997) syntax question, not in online refernce (1997) Store Example to Use (1998) test (2005) [WebDNA] Pages dying (2008) taxTotal, grandTotal (1997) [shownext max=?] armed (1997) emailer w/F2 (1997) StoreBuilder help/question... (2000) [sendmail] and [formvariables] (1997) RAM variables (1997) E-mail loop ! (1997)