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 since time is 24 hr it doesn't need a special sort tag. I will assume the later unless 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:

    
  1. Re: Cart Number sequence (Kenneth Grome 1997)
  2. Re: Cart Number sequence (grichter@panavise.com (Gary Richter) 1997)
  3. Re: Cart Number sequence (Grant Hulbert 1997)
  4. Cart Number sequence (grichter@panavise.com (Gary Richter) 1997)
>>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 since time is 24 hr it doesn't need a special sort tag. I will assume the later unless 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)