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 =====[/!]-DanOn 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:
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 =====[/!]-DanOn 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)