Re: CART question
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 59994
interpreted = N
texte = Thanks to everyone for their advice. John, I won't go down that road, then. And Sal, it IS for a member ID, so sequential won't work. A [random] string or nums.db are excellent alternatives. With appreciation, ----- Patrick Junkroski http://www.vsm.net On Nov 11, 2004, at 5:00 AM, WebDNA Talk wrote: > The cart is a unique _character string_ that is typically 15 > characters long (it used to be shorter before we entered the last > power of two seconds) but can be longer. It is based on the number of > seconds since the Unix Epoch, plus a uniquifier sequence, so that no > matter how many carts are assigned in a given second, all carts are > supposed to be unique (up to the granularity of the unique portion). > > Consequently, you should never: > > a) treat a cart as a number (it's not and only sorts properly as a > variable length string and it will in fact overflow most number > fields); > > b) truncate the cart value for some other purpose. > > HTH > > John > > -- > John Peacock > Director of Information Research and Technology > Rowman & Littlefield Publishing Group > 4720 Boston Way > Lanham, MD 20706 > 301-459-3366 x.5010 > fax 301-429-5747 ------------------------------------------------------------- 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:
Thanks to everyone for their advice. John, I won't go down that road, then. And Sal, it IS for a member ID, so sequential won't work. A [random] string or nums.db are excellent alternatives. With appreciation, ----- Patrick Junkroski http://www.vsm.net On Nov 11, 2004, at 5:00 AM, WebDNA Talk wrote: > The cart is a unique _character string_ that is typically 15 > characters long (it used to be shorter before we entered the last > power of two seconds) but can be longer. It is based on the number of > seconds since the Unix Epoch, plus a uniquifier sequence, so that no > matter how many carts are assigned in a given second, all carts are > supposed to be unique (up to the granularity of the unique portion). > > Consequently, you should never: > > a) treat a cart as a number (it's not and only sorts properly as a > variable length string and it will in fact overflow most number > fields); > > b) truncate the cart value for some other purpose. > > HTH > > John > > -- > John Peacock > Director of Information Research and Technology > Rowman & Littlefield Publishing Group > 4720 Boston Way > Lanham, MD 20706 > 301-459-3366 x.5010 > fax 301-429-5747 ------------------------------------------------------------- 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/
Patrick J.
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:
Search Question (2000)
[REFERRER] AND Truncation (1998)
Plugin or CGI or both (1997)
more [sendmail] woes.. (2000)
contextual shownext (1998)
WebCat2b12 CGI Mac - [shownext] problem (1997)
webcat 2.1 (1997)
Nested [SEARCH] and [REPLACE] problem. (1997)
New Plug-in and Type 11 errors (1997)
Credit card processing - UK (1997)
OLD ORDERS (1998)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Error, 101 a DNS problem ? (1997)
emailer settings and control questions (1997)
taxRate is fine but taxTotal isn't (1997)
[WebDNA] Encode cookies ONLY via "method=Base64" (2008)
MacAuthorize and WebMerchant (1997)
OFF-TOPIC: Check www.godaddy.com for me ... (2003)
RED QUESTION MARKS AGAIN (1999)
GoLive CyberStudio 1.0.1 (1997)