Re: Cart Number sequence
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14055
interpreted = N
texte = >I assume that a cart number assigned at 10:00am today is lower in number >then one assigned at 10:05am today. So one can sort on the cart number and >get the newest one at the top.You can sort the cart numbers if you want to, but do *NOT* tell WebCat that the cart number is a NUMBER. In other words, don't put &fieldtype=num into your search string when the field has values that were generated by the [cart] function, because in reality the cart numbers don't have the same number of digits all the time - sometimes they have 12 digits, sometimes 13, sometimes 14.That's not important unless you're sorting cart numbers, and then you have to sort them as if they are text values instead of numbers, that's all.>Would there ever be a time that the cart >number would roll over and be a lower number. IE if cartnumber is greater >then 999 then cartnumber=1Yes, but there is no 'roll-over'. The only time you may *possibly* get repetitive cart numbers is when you reset your server's clock to an earlier time. That's because the cart number is created by using the time and date, and if you reset the clock to an *earlier* time, then it's possible (but still not very likely) that a new cart number will be created that has the same value as a previous cart number.Sincerely, Ken Grome WebDNA Solutions 808-737-6499
Associated Messages, from the most recent to the oldest:
>I assume that a cart number assigned at 10:00am today is lower in number >then one assigned at 10:05am today. So one can sort on the cart number and >get the newest one at the top.You can sort the cart numbers if you want to, but do *NOT* tell WebCat that the cart number is a NUMBER. In other words, don't put &fieldtype=num into your search string when the field has values that were generated by the
[cart] function, because in reality the cart numbers don't have the same number of digits all the time - sometimes they have 12 digits, sometimes 13, sometimes 14.That's not important unless you're sorting cart numbers, and then you have to sort them as if they are text values instead of numbers, that's all.>Would there ever be a time that the cart >number would roll over and be a lower number. IE if cartnumber is greater >then 999 then cartnumber=1Yes, but there is no 'roll-over'. The only time you may *possibly* get repetitive cart numbers is when you reset your server's clock to an earlier time. That's because the cart number is created by using the time and date, and if you reset the clock to an *earlier* time, then it's possible (but still not very likely) that a new cart number will be created that has the same value as a previous cart number.Sincerely, Ken Grome WebDNA Solutions 808-737-6499
Kenneth Grome
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:
Where is f2? (1997)
Bug or syntax error on my part? (1997)
Error Lob.db records error message not name (1997)
Append User DB? (2000)
Forms Search Questions (1997)
WebCat2b13MacPlugIn - More limits on [include] (1997)
MacAuthorize hub, no modal password dialog? (1997)
Emailer (1997)
Grep Search and Replace (2002)
Join us at MacWorld! - Part 2 (1998)
Introduction/Tutorial/QuickStart (1997)
[WebDNA] Searching Possible Bug (2009)
Seeking WebCat Bulletin Board (1999)
Freeze (2003)
Re:listfiles-looking for slick solution (1997)
PR: WebCatalog Affiliates Program Announced -- Share the revenue for promoting WebCatalog (2000)
Multiple Items (2004)
[WebDNA] Build Name for 6.1 (2008)
Separate SSL Server (1997)
OT (sort of) WAP/WML and 'form' posts (2003)