Re: Uniqueness of [cart] - revisited

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58921
interpreted = N
texte = Tana, This code works for me and is at the top of my header.inc file: [!]========== Duplicate Cart Stopper. Checks to see if Cart already exists. =====[/!][!] [/!][!]====== Useful mostly if someone returns to the store via a bookmark =====[/!][!] [/!][showif [url][lookup db=WebMerchant/Orders.db&lookInField=cart&value=[cart]&returnField=cart][/url]=[cart]][!] [/!][redirect url=default.tpl][!] [/!][/showif][!] [/!][!]====== End Duplicate Cart Stopper =====[/!] -Dan On Wed, 28 Jul 2004 09:35:50 -0700 "Tana Adams" wrote: >Thanks to all of you for your comments -- most helpful. > >I didn't use the storebuilder templates for this site (I built this a few >years ago and probably didn't know any better). I think you guys may be >right about the bookmarked URL -- I should have thought of that one. >Ordinarily, WebMerchant *would* catch something like this, but I archive our >orders every year so the 2003 orders were removed from the orders.db. >Sounds like I need write something to check the archived databases for >duplicates to prevent this from happening again. > >Thanks again! > >Tana > >-----Original Message----- >From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of >Donovan Brooke >Sent: Wednesday, July 28, 2004 6:05 AM >To: WebDNA Talk >Subject: Re: Uniqueness of [cart] - revisited > > >Tana Adams wrote: >> I found this old thread while searching the talklist just now. I was >> wondering if someone could help me understand what might have happened to >us >> today. An old order number was generated for a new order that came >through. >> (So we had an order with the same order number back in 2003.) We happened >> to catch it since it had listed the same lineitem twice (something else >> funky that I'll have to look into). >> >> Anyway, I read the paragraph from John below. I'm fairly certain he's >> referring to two different servers running WebDNA at the same time but >> thought I'd better make sure. We upgraded to a new server last year but >> that shouldn't create a problem with duplicate cart numbers, should it? >> >> Thanks, >> >> Tana > >I would suspect a bookmarked URL though I don't think webmerchant will >let it pass... are you using storebuilder temps or are you "rolling your >own"? > >Donovan > > >-- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE Eucalyptus Design > <-Web Development (specializing in eCommerce), -> > <-Graphic Design, and Pre-Press Consultation -> > > ADDRESS:> Donovan Brooke > DBA Eucalyptus Design > N2862 Summerville Park Rd. > Lodi, WI 53555 > PH:> 1.608.592.3567 > Web:> http://www.euca.us > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > >------------------------------------------------------------- >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/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Uniqueness of [cart] - revisited ( "Dan Strong" 2004)
  2. Re: Uniqueness of [cart] - revisited ( "Tana Adams" 2004)
  3. Re: Uniqueness of [cart] - revisited ( John Peacock 2004)
  4. Re: Uniqueness of [cart] - revisited ( Alex McCombie 2004)
  5. Re: Uniqueness of [cart] - revisited ( Donovan Brooke 2004)
  6. Re: Uniqueness of [cart] - revisited ( "Tana Adams" 2004)
Tana, This code works for me and is at the top of my header.inc file: [!]========== Duplicate Cart Stopper. Checks to see if Cart already exists. =====[/!][!] [/!][!]====== Useful mostly if someone returns to the store via a bookmark =====[/!][!] [/!][showif [url][lookup db=WebMerchant/Orders.db&lookInField=cart&value=[cart]&returnField=cart][/url]=[cart]][!] [/!][redirect url=default.tpl][!] [/!][/showif][!] [/!][!]====== End Duplicate Cart Stopper =====[/!] -Dan On Wed, 28 Jul 2004 09:35:50 -0700 "Tana Adams" wrote: >Thanks to all of you for your comments -- most helpful. > >I didn't use the storebuilder templates for this site (I built this a few >years ago and probably didn't know any better). I think you guys may be >right about the bookmarked URL -- I should have thought of that one. >Ordinarily, WebMerchant *would* catch something like this, but I archive our >orders every year so the 2003 orders were removed from the orders.db. >Sounds like I need write something to check the archived databases for >duplicates to prevent this from happening again. > >Thanks again! > >Tana > >-----Original Message----- >From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of >Donovan Brooke >Sent: Wednesday, July 28, 2004 6:05 AM >To: WebDNA Talk >Subject: Re: Uniqueness of [cart] - revisited > > >Tana Adams wrote: >> I found this old thread while searching the talklist just now. I was >> wondering if someone could help me understand what might have happened to >us >> today. An old order number was generated for a new order that came >through. >> (So we had an order with the same order number back in 2003.) We happened >> to catch it since it had listed the same lineitem twice (something else >> funky that I'll have to look into). >> >> Anyway, I read the paragraph from John below. I'm fairly certain he's >> referring to two different servers running WebDNA at the same time but >> thought I'd better make sure. We upgraded to a new server last year but >> that shouldn't create a problem with duplicate cart numbers, should it? >> >> Thanks, >> >> Tana > >I would suspect a bookmarked URL though I don't think webmerchant will >let it pass... are you using storebuilder temps or are you "rolling your >own"? > >Donovan > > >-- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE Eucalyptus Design > <-Web Development (specializing in eCommerce), -> > <-Graphic Design, and Pre-Press Consultation -> > > ADDRESS:> Donovan Brooke > DBA Eucalyptus Design > N2862 Summerville Park Rd. > Lodi, WI 53555 > PH:> 1.608.592.3567 > Web:> http://www.euca.us > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > >------------------------------------------------------------- >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/ "Dan Strong"

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:

(2003) Linux Beta4 problems with multirecord returns (2000) more cookie crumbling (1999) Running 2 two WebCatalog.acgi's (1996) RE: [redirect] w/o showing args? (1999) XML Syntax, Cookies and Variables.... (2004) More on EudoraPro Email (1998) Accepting credit cards (1997) listwords and delimiters.. showing blank word? (2004) WebCat 3.04-3.07 plug-in dying on server.... (2000) Location of Webcat site in folder hierarchy (1997) SSL Certificates (2004) b12 cannot limit records returned and more. (1997) Associative lookup style? + bit more (1997) frames & carts (1997) email preferences on NT (1997) Help name our technology! (1997) pop up building with summarize (1998) Am on the list? (1997) WebCat2 beta 11 - new prefs ... (1997)