Re: Cart Number sequence
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14054
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. 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=1>>Cart numbers are guaranteed to be unique, but unfortunately they are not>sortable the way you describe. If you're just looking for an>ever-increasing number or some other way to 'serialize' records, you>should look into using a counter of some kind instead. Or perhaps some>[date][time] type of stuff.OK one I know works is typedate in a sort, how about typetime??? or sincetime is 24 hr it doesn't need a special sort tag. I will assume the laterunless I hear otherwise from anybody===============================================Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com===============================================
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. 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=1>>Cart numbers are guaranteed to be unique, but unfortunately they are not>sortable the way you describe. If you're just looking for an>ever-increasing number or some other way to 'serialize' records, you>should look into using a counter of some kind instead. Or perhaps some>
[date][time] type of stuff.OK one I know works is typedate in a sort, how about typetime??? or sincetime is 24 hr it doesn't need a special sort tag. I will assume the laterunless I hear otherwise from anybody===============================================Gary Richter PanaVise Products, Inc. 7540 Colbert Dr. Reno, Nevada 89511 Ph: 702.850.2900 Fx: 702.850.2929 Email: grichter@panavise.com http://www.panavise.com===============================================
grichter@panavise.com (Gary Richter)
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:
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
[WebDNA] TCPDoh (2009)
Write Permissions with OSX and WebDNA 4.5 (2002)
Re:[off] Promotions Co? (1997)
[WebDNA] StoreBuilder 3.0 (2014)
Updating a database once per day - An example (1998)
[defined]ish (1997)
problems with 2 tags (1997)
Bug in capitalize ... ? (2003)
[WebDNA] Putting '&search' into URL killing all search contexts on my sites (2010)
New Feature (now!) (2002)
I found a bug ... (1997)
Emailer help....! (1997)
WC TableGrinder (1997)
Editing the search string (1997)
multi-paragraph fields (1997)
HELP! Search finding too much! (1998)
Country & Ship-to address & other fields ? (1997)
Fun with Dates - revisited (1997)
formula's (1998)