Re: Help SM: Duplicate cart #'s - still!
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 52221
interpreted = N
texte = Even if your server was automatically setting its clock back in order to correct for a difference between the server's clock time and the real time, it should still be virtually impossible (theoretically) to end up with the same cart number as a previous one, since the cart number is supposed to be incremented upon every new hit to the server. can you get the software to do this by constantly reloading a template that has no other code in it but some code that appends the cart value to a database or to a text file? It seems like this is the only sure-fire way to guarantee that some of your code in other pages is not creating the duplicate cart value ... If you run a test like this and it creates a duplicate cart value, then you can be certain that it's a bug in the engine code. Otherwise, unless other people are seeing duplicate cart values in the same webdna version you're using, it would seem that maybe your existing code is at fault here. Personally I've never seen a duplicate cart value, but that doesn't prove anything, except that maybe I've been lucky. I only hope I haven't jinxed myself by saying this ... :) >On Wednesday, August 13, 2003, at 11:40 PM, Tim Robinson wrote: > >>How entirely different are the customers? Is it even vaguely possible that >>they're using the same computer and your cookie hasn't 'expired'. > >No. Two different customers from different parts of the country and >different IPs...and it's happened on at least three occasions that I >know of so far. > >> >>What do you actually mean by "The session cookie is set to 'expired' when >>the customer reaches the order completion page." Do you mean the cookie is >>deleted? > >The value of the cookie is set to the word "expired". I then test >for this on every page, with something like > >[showif [GetCookie SessionID]=expired] > [SetCookie name=SessionID&value=[cart]&path=/&domain=.novaderm.com] >[/showif] > >Regards, > >-- > >Will Starck >NovaDerm Skincare Science >http://www.novaderm.com >wjs@novaderm.com > > >> >>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: Wed, 13 Aug 2003 23:33:30 -0500 >>>To: (WebDNA Talk) >>>Subject: Re: Help SM: Duplicate cart #'s - still! >>> >>> >>>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/ >> >> >>------------------------------------------------------------- >>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/ -- Sincerely, Kenneth Grome ------------------------------------------------------------- Outsource your WebDNA programming for $18 an hour or less! ------------------------------------------------------------- ------------------------------------------------------------- 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:
Even if your server was automatically setting its clock back in order to correct for a difference between the server's clock time and the real time, it should still be virtually impossible (theoretically) to end up with the same cart number as a previous one, since the cart number is supposed to be incremented upon every new hit to the server. can you get the software to do this by constantly reloading a template that has no other code in it but some code that appends the cart value to a database or to a text file? It seems like this is the only sure-fire way to guarantee that some of your code in other pages is not creating the duplicate cart value ... If you run a test like this and it creates a duplicate cart value, then you can be certain that it's a bug in the engine code. Otherwise, unless other people are seeing duplicate cart values in the same webdna version you're using, it would seem that maybe your existing code is at fault here. Personally I've never seen a duplicate cart value, but that doesn't prove anything, except that maybe I've been lucky. I only hope I haven't jinxed myself by saying this ... :) >On Wednesday, August 13, 2003, at 11:40 PM, Tim Robinson wrote: > >>How entirely different are the customers? Is it even vaguely possible that >>they're using the same computer and your cookie hasn't 'expired'. > >No. Two different customers from different parts of the country and >different IPs...and it's happened on at least three occasions that I >know of so far. > >> >>What do you actually mean by "The session cookie is set to 'expired' when >>the customer reaches the order completion page." Do you mean the cookie is >>deleted? > >The value of the cookie is set to the word "expired". I then test >for this on every page, with something like > >[showif [GetCookie SessionID]=expired] > [SetCookie name=SessionID&value=[cart]&path=/&domain=.novaderm.com] >[/showif] > >Regards, > >-- > >Will Starck >NovaDerm Skincare Science >http://www.novaderm.com >wjs@novaderm.com > > >> >>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: Wed, 13 Aug 2003 23:33:30 -0500 >>>To: (WebDNA Talk) >>>Subject: Re: Help SM: Duplicate cart #'s - still! >>> >>> >>>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/ >> >> >>------------------------------------------------------------- >>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/ -- Sincerely, Kenneth Grome ------------------------------------------------------------- Outsource your WebDNA programming for $18 an hour or less! ------------------------------------------------------------- ------------------------------------------------------------- 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/
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:
Sendmail vs OS X Mail Services (2006)
Stop the madness. (1997)
Formvariables name matching (2005)
unsubscribe (1997)
WebCatalog for guestbook ? (1997)
Attn: Bug in GeneralStore example b15 (1997)
I'm new be kind (1997)
[Shell] not relative (2000)
NT Setup (1998)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
WCS Newbie question (1997)
Error 11 (1996)
[WebDNA] Help with ReplaceFoundItems (2009)
OT: RAID Options (2004)
Stat analyzer (1997)
More news on 5.0 (2003)
Grepping to remove text & code (2004)
WebCat editing, SiteGuard & SiteEdit (1997)
Convert words (2002)
LOOP and IF statements (1997)