Re: Cart Number sequence
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14053
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=1Cart 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.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ====Pacific Coast Software | WebCatalog, WebMerchant11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMasterSan Diego, CA 92128 | SiteGuard619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.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=1Cart 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.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ====Pacific Coast Software | WebCatalog, WebMerchant11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMasterSan Diego, CA 92128 | SiteGuard619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com
Grant Hulbert
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:
[append] problems (2003)
[WebDNA] An actual attempt to get WebDNA and MAMP Pro to work - (2018)
LOOP and IF statements (1997)
[WebDNA] RE: OT Oversees merchant account and processor to use in UK with Webdna (2008)
Occasional crashes with $remove (1997)
[WebDNA] Sendmail problem (2009)
bug urgent, [protect admin ] and .max work wrong (2003)
Part 2 - [showif] if variable exists (1998)
default image if image in code not available (2003)
[WebDNA] Seriously what is wrong here? (2011)
WebCatalog can't find database (1997)
TCP Connect (2000)
PCS Frames (1997)
WebCatalog for Postcards ? (1997)
Is there a way to just get to the last record in the database? (1997)
re: How can I record purchases to a database? (1998)
Kaaaaahhhhhhhnnnnnnn! (1997)
Error 11 (1996)
Webcat serving error page? (2000)
[WebDNA] [BULK] strange triggers.db occurrence??? (2012)