Re: Q: old cart serial problem
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29663
interpreted = N
texte = >>>Hi, >>> >>>If a customer bookmarked the url, http://www.foo.bar/?cart=939857434114567, >>>the customer always uses the cart serial 939857434114567. >>>This results in the same order number. It's not good for our shop. >>>Is there any way to clear old cart serial automatically? >>>No other people have the problem? >> >> Try comparing it against the existing cart file and orderfile numbers, and if it matches then redirect to the home page without cart=[cart] in the redirect. > >Thanks, Ken. > >But I don't save the existing cart file on the server, >(order data are stored in other server behind firewall) >so there is no existing cart file.Then you have to store the cart num,ber in a database and compare against that db instead. >Maybe I could write the all cart serial to a WebDNS db file, >but the cart serial database is growing everyday. How >many days must I keep the data?As long as it takes to insure that a visitor doesn't come back with an old cart number ... >I guess the cart serial is based on time, so can I >judge the creation time only from the cart serial?Maybe, but you'd have to ask SM about this, and they have never been very clear or forthcoming about the formula they use to create their card numbers before, so unless they actually provide the information you need to determine which part of the cart number is the date and time representation, you'll just have to maintain a database of used cart values yourself ...================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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
Associated Messages, from the most recent to the oldest:
>>>Hi, >>> >>>If a customer bookmarked the url, http://www.foo.bar/?cart=939857434114567, >>>the customer always uses the cart serial 939857434114567. >>>This results in the same order number. It's not good for our shop. >>>Is there any way to clear old cart serial automatically? >>>No other people have the problem? >> >> Try comparing it against the existing cart file and orderfile numbers, and if it matches then redirect to the home page without cart=[cart] in the redirect. > >Thanks, Ken. > >But I don't save the existing cart file on the server, >(order data are stored in other server behind firewall) >so there is no existing cart file.Then you have to store the cart num,ber in a database and compare against that db instead. >Maybe I could write the all cart serial to a WebDNS db file, >but the cart serial database is growing everyday. How >many days must I keep the data?As long as it takes to insure that a visitor doesn't come back with an old cart number ... >I guess the cart serial is based on time, so can I >judge the creation time only from the cart serial?Maybe, but you'd have to ask SM about this, and they have never been very clear or forthcoming about the formula they use to create their card numbers before, so unless they actually provide the information you need to determine which part of the cart number is the date and time representation, you'll just have to maintain a database of used cart values yourself ...================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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
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:
RequiredFields template (1997)
Newbie from and old bee (1997)
WILDWEBCAT encrypt.tpl submission (1998)
Multiple security dbs (1997)
Sorting Results (1999)
Browsername (1998)
WebCat2final1 crashes (1997)
DataBaseHelper Flawed (1997)
Client-side Image Maps and WebCat? (1998)
iis 4.0 (1997)
RE: [WebDNA] read database from other domain (2015)
New Plug-in and Type 11 errors (1997)
[exclusivelock] (was:several people...) (2001)
Location of Browser Info.txt file (1997)
http upload (2001)
Sorting by date (1997)
WebCat2b13MacPlugin - nested [xxx] contexts (1997)
[format 40s]text[/format] doesn't work (1997)
Test again - Am I seeing double? (2003)
How to Sort Summ data ? (1997)