Re: unique ascending numbers
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 50199
interpreted = N
texte = With our method, it is impossible to have 2 times the same CART number. We use a base of visit (visits.db). We record the number of visit (ID) in the cookie of the visitor (it can be use in a link). When the visitor enters the shop, we generate a single number of order compared to the base orders (orders.db). And we attach this number of basket to the number of the visit. When it finished its purchases, it is enough to seek a new number in the base of the orders and to change it in the base of the visits. By locking the base of the orders during the calculation of the serial number (a new CART), we have the guarantee that it will be single and in the order. Moreover, the base visits has many of other advantages. One can record preferences, settings, which it would have chosen during its visit. Here what that gives.ORDERS.DB ID DATE_ORDER PRICE TYPE ... ORD000001 01/01/2003 $12.2 AMEX ORD000002 01/02/2003 $15.7 VISA ORD000003 01/04/2003 $14.1 VISA VISITS.DB ID DATE_VISIT ID_ORDER LAST_TIME_VISIT ID_USER ACCEPT_CHAT LEVEL_ACCES ... VIS000010 01/01/2003 ORD000001 10:03:20 USR0000101 Yes 1 VIS000011 01/02/2003 ORD000002 11:22:25 USR0000053 Yes 1 VIS000012 01/04/2003 ORD000003 15:43:55 USR0000012 No 3 Le samedi, 10 mai 2003, à 01:55 Europe/Paris, John Peacock a écrit :> That is much more likely bad coding, rather than some problem with the > unique [cart] function. For example, sending a link with an already > existing cart number will reuse that number, even though when the > attempt is made to purchase the system will recognize that the cart is > not unique. There were also some Internet caches which would > occasionally keep the cart number. > > ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
With our method, it is impossible to have 2 times the same CART number. We use a base of visit (visits.db). We record the number of visit (ID) in the cookie of the visitor (it can be use in a link). When the visitor enters the shop, we generate a single number of order compared to the base orders (orders.db). And we attach this number of basket to the number of the visit. When it finished its purchases, it is enough to seek a new number in the base of the orders and to change it in the base of the visits. By locking the base of the orders during the calculation of the serial number (a new CART), we have the guarantee that it will be single and in the order. Moreover, the base visits has many of other advantages. One can record preferences, settings, which it would have chosen during its visit. Here what that gives.ORDERS.DB ID DATE_ORDER PRICE TYPE ... ORD000001 01/01/2003 $12.2 AMEX ORD000002 01/02/2003 $15.7 VISA ORD000003 01/04/2003 $14.1 VISA VISITS.DB ID DATE_VISIT ID_ORDER LAST_TIME_VISIT ID_USER ACCEPT_CHAT LEVEL_ACCES ... VIS000010 01/01/2003 ORD000001 10:03:20 USR0000101 Yes 1 VIS000011 01/02/2003 ORD000002 11:22:25 USR0000053 Yes 1 VIS000012 01/04/2003 ORD000003 15:43:55 USR0000012 No 3 Le samedi, 10 mai 2003, à 01:55 Europe/Paris, John Peacock a écrit :> That is much more likely bad coding, rather than some problem with the > unique [cart] function. For example, sending a link with an already > existing cart number will reuse that number, even though when the > attempt is made to purchase the system will recognize that the cart is > not unique. There were also some Internet caches which would > occasionally keep the cart number. > > ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Laurent Bache
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:
Re:quit command on NT (1997)
japanese characters (1997)
Multiple catalog databases and showcart (1997)
Encrypted links ... (2000)
Keep away (1997)
Multiple prices (1997)
WC2b15 - [HTMLx]...[/HTMLx] problems SOLVED! (1997)
WebCat2b15MacPlugin - showing [math] (1997)
sku, title, price not showing up (1998)
Separate SSL Server (1997)
WebCat cannot handle compatible search parameters? (1997)
Trigger options (2000)
[WebDNA] how can i grab the contents of a post? (2011)
WebCatalog for guestbook ? (1997)
Question about replacing words (1998)
2.0Beta Command Ref (can't find this instruction) (1997)
SQL - Output into file (2004)
WebCat Beta NT 18 (1997)
form image (2000)
WebDNA Solutions ... sorry! (1997)