Re: Help SM: Duplicate cart #'s - still!
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52218
interpreted = N
texte = On Tuesday, August 12, 2003, at 06:16 PM, Tim Robinson wrote: > 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? I don't think so, because I'm having two entirely different customers at different times of the day with the same cart number. And the cart number only appears once in the orders database, so I know it's not a bookmarked cart problem. > When you write to the ordes db, do you delete the cookie? Yes. The session cookie is set to "expired" when the customer reaches the order completion page. -Will > > 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/ > > -- 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/
Associated Messages, from the most recent to the oldest:
On Tuesday, August 12, 2003, at 06:16 PM, Tim Robinson wrote: > 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? I don't think so, because I'm having two entirely different customers at different times of the day with the same cart number. And the cart number only appears once in the orders database, so I know it's not a bookmarked cart problem. > When you write to the ordes db, do you delete the cookie? Yes. The session cookie is set to "expired" when the customer reaches the order completion page. -Will > > 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/ > > -- 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/
WJ Starck
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:
Our Webcat site launched (1997)
All choices on IE different than Netscape (1997)
Product display (2000)
WebCat2 beta 11 - new prefs ... (1997)
OT: Prevent Caching js Files (2003)
ReadDateFormat bug in 3.x (1998)
WC2b12: Yes, Formulas.db is for real (1997)
Sku numbers (1997)
ShowNext (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
[WebDNA] New request for websites that currently run WebDNA (2009)
[TaxableTotal] - not working with AOL and IE (1997)
Re2: frames & carts (1997)
TaxTotal Problem (1997)
For those of you not on the WebCatalog Beta... (1997)
WC1.6 to WC2 date formatting (1997)
Country & Ship-to address & other fields ? (1997)
Sendmail and attachments? (1998)
Need help!! on searching in two databases. (1998)
RE: High ASCII inside [LOOKUP] inside [LISTWORDS] (1998)