Re: Help SM: Duplicate cart #'s - still!
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52184
interpreted = N
texte = Why don't you add an IP Address value to that database. Is it possible that someone has returned to do another order and their sessions cookie is still intact? When you write to the ordes db, do you delete the cookie? Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837 > From: WJ Starck
> Reply-To: (WebDNA Talk) > Date: Tue, 12 Aug 2003 09:46:54 -0500 > To: (WebDNA Talk) > Subject: Help SM: Duplicate cart #'s - still! > > I'm still seeing duplicate carts numbers. > > Here's the latest scenario: > > Our system passes the cart from page to page via a session cookie. > Items are added and subtracted to the cart in standard fashion, > however, we do not use the purchase command, but instead write all of > the information contained in the cart to an orders.db, with the cart # > being written as a unique identifier that separates orders. > > On 8/6, I had a customer place an order at 4:04 pm with cart > #106019560330318. At 11:30 pm, I had another customer place an order > with the identical cart number. This of course overwrote the first > order. > > I wrote the following and placed it in a template: > > > > Duplicate cart tester > > > [append db=../dbs/dupcart.db]ordername=[cart][/append] > > [search db=../dbs/dupcart.db&neordernamedata=[blank]] > [numfound] records[/search] > > [search db=../dbs/dupcart.db&neordernamedata=[blank]&ordernamesumm=T] > [numfound] carts > [/search] > > After roughly 5600 iterations, no duplicate cart numbers appeared. > However, here is a list of the cart numbers between 4:04 pm and 11:30 > pm on that day: > > 16:04:03 106019560330318 > 16:37:09 106020512534622 > 18:03:09 106021040535085 > 19:06:30 106021405435386 > 19:51:13 106021623235862 > 20:37:27 106021971136358 > 20:52:41 106022065336500 > 21:00:54 106019751131041 > 23:30:03 106019560330318 > > The following code is at the top of every page to prevent the > bookmarked cart problem. > > > > This is about the seventh or eight time since upgrading to 5.0 that > this has happened, and I'm out of ideas. This never happened in over > two years with the same code on previous versions of WebCat. > > Anyone? > > Regards, > > > -- > > Will Starck > NovaDerm Skincare Science > http://www.novaderm.com > wjs@novaderm.com > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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:
Why don't you add an IP Address value to that database. Is it possible that someone has returned to do another order and their sessions cookie is still intact? When you write to the ordes db, do you delete the cookie? Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837 > From: WJ Starck > Reply-To: (WebDNA Talk) > Date: Tue, 12 Aug 2003 09:46:54 -0500 > To: (WebDNA Talk) > Subject: Help SM: Duplicate cart #'s - still! > > I'm still seeing duplicate carts numbers. > > Here's the latest scenario: > > Our system passes the cart from page to page via a session cookie. > Items are added and subtracted to the cart in standard fashion, > however, we do not use the purchase command, but instead write all of > the information contained in the cart to an orders.db, with the cart # > being written as a unique identifier that separates orders. > > On 8/6, I had a customer place an order at 4:04 pm with cart > #106019560330318. At 11:30 pm, I had another customer place an order > with the identical cart number. This of course overwrote the first > order. > > I wrote the following and placed it in a template: > > > > Duplicate cart tester > > > [append db=../dbs/dupcart.db]ordername=[cart][/append] > > [search db=../dbs/dupcart.db&neordernamedata=[blank]] > [numfound] records[/search] > > [search db=../dbs/dupcart.db&neordernamedata=[blank]&ordernamesumm=T] > [numfound] carts > [/search] > > After roughly 5600 iterations, no duplicate cart numbers appeared. > However, here is a list of the cart numbers between 4:04 pm and 11:30 > pm on that day: > > 16:04:03 106019560330318 > 16:37:09 106020512534622 > 18:03:09 106021040535085 > 19:06:30 106021405435386 > 19:51:13 106021623235862 > 20:37:27 106021971136358 > 20:52:41 106022065336500 > 21:00:54 106019751131041 > 23:30:03 106019560330318 > > The following code is at the top of every page to prevent the > bookmarked cart problem. > > > > This is about the seventh or eight time since upgrading to 5.0 that > this has happened, and I'm out of ideas. This never happened in over > two years with the same code on previous versions of WebCat. > > Anyone? > > Regards, > > > -- > > Will Starck > NovaDerm Skincare Science > http://www.novaderm.com > wjs@novaderm.com > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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/
Tim Robinson
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:
serial number dishing (1997)
RE: WebDNA-Talk searchable? (1997)
Pref settings? (1998)
Summing fields (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
[WebDNA] webdna site down? (2011)
how to check for no value while using [URL] to prevent cr (1999)
hard carriage returns and sendmail (1998)
time and welcome (1999)
Answer: WebDelivery downloads alias, not original ? (1997)
Buying sans cart (1997)
RE: Web*SSL and WebCatalog (1997)
OT: SMSI stock (2003)
Help formatting search results w/ table (1997)
Banners (1997)
Tab Charactor (1997)
Pithy questions on webcommerce & siteedit (1997)
PIXO support (1997)
Changes to the List (1997)
What am I missing (1997)