Re: WebDNA creates DUPLICATE SHOPPING CART NUMBERS
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56106
interpreted = N
texte = I posted code a year or 2 back that fixes the problem on check out but it also has to have the orders in the orders.db file, all you need do is lookup the order# in the order.db if its there do a "newcart" copy old to new and redirect. Literally the buyer never has to see that you did this, they would simply advance to the billing page. here it is again, you would still need to adjust it for your own use. [!]Included on the check out page[/!] [showif [lookup db=databases/ orders.db&lookinfield=order&value=[cart]&returnfield=[odate]¬found=nf ]!nf] [redirect newshoppingcart.tpl?file=[cart][formvariables][hideif [name]=cart][hideif [name]=command][hideif [name]=template]&[name]=[URL][value][/URL][/hideif][/hideif][/hideif][/ formvariables]] [/showif] then On the newshoppingcart.tpl page the following that redirects back to the original page you got redirected from: [MOVEFILE from=ShoppingCarts/[file]&to=ShoppingCarts/[cart]] [replace db=databases/activecart.db&eqAcartdata=[file]]Acart=[cart][/replace] [redirect checkout.tpl?cart=[cart]&[formvariables][hideif [name]=cart][hideif [name]=file][hideif [name]=template]&[name]=[URL][value][/URL][/hideif][/hideif][/hideif][/ formvariables]&command=showcart] I don't care if the user uses the same shoppingcart for shopping just if they use it to check out. I also don't keep the shoppingcarts around, I remove them immediately after checkout. Citizen just needs to check the archives before he goes running around like a chicken with his head cut off. This is an old problem with easy and well stated solutions. On Feb 15, 2004, at 10:12 AM, Donovan Brooke wrote: > I spent some good quality time (months ago) with Citizen analyzing > what the > situation was and gave him pointers on how to fix it. My code > is a simple lookup to the orders.db. If the cart is there, it > redirects the user to the default page without the cart (so that a new > one > is issued). Very simple. I can't post it because other people > have paid for this code and it works just fine for them. Citizen > has not paid for the code. It is not the cause of any issues. ------------------------------------------------------------- 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:
I posted code a year or 2 back that fixes the problem on check out but it also has to have the orders in the orders.db file, all you need do is lookup the order# in the order.db if its there do a "newcart" copy old to new and redirect. Literally the buyer never has to see that you did this, they would simply advance to the billing page. here it is again, you would still need to adjust it for your own use. [!]Included on the check out page[/!] [showif [lookup db=databases/ orders.db&lookinfield=order&value=[cart]&returnfield=[odate]¬found=nf ]!nf] [redirect newshoppingcart.tpl?file=[cart][formvariables][hideif [name]=cart][hideif [name]=command][hideif [name]=template]&[name]=[url][value][/URL][/hideif][/hideif][/hideif][/ formvariables]] [/showif] then On the newshoppingcart.tpl page the following that redirects back to the original page you got redirected from: [MOVEFILE from=ShoppingCarts/[file]&to=ShoppingCarts/[cart]] [replace db=databases/activecart.db&eqAcartdata=[file]]Acart=[cart][/replace] [redirect checkout.tpl?cart=[cart]&[formvariables][hideif [name]=cart][hideif [name]=file][hideif [name]=template]&[name]=[url][value][/URL][/hideif][/hideif][/hideif][/ formvariables]&command=showcart] I don't care if the user uses the same shoppingcart for shopping just if they use it to check out. I also don't keep the shoppingcarts around, I remove them immediately after checkout. Citizen just needs to check the archives before he goes running around like a chicken with his head cut off. This is an old problem with easy and well stated solutions. On Feb 15, 2004, at 10:12 AM, Donovan Brooke wrote: > I spent some good quality time (months ago) with Citizen analyzing > what the > situation was and gave him pointers on how to fix it. My code > is a simple lookup to the orders.db. If the cart is there, it > redirects the user to the default page without the cart (so that a new > one > is issued). Very simple. I can't post it because other people > have paid for this code and it works just fine for them. Citizen > has not paid for the code. It is not the cause of any issues. ------------------------------------------------------------- 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/
Bob Minor
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:
Unexpected comparison behavior change in 4.5.1 (2003)
Mac/network guy needed in Seattle (2004)
docs for WebCatalog2 (1997)
Exclude by date - multiple (1997)
list cookies and list http headers (1997)
Progress !! WAS: Trouble with formula.db (1997)
PIXO support (1997)
Error Messges (1997)
Macos8.6 to X migration problems (2000)
[append] and SSL (1997)
Color (2000)
Looping control (1997)
Price Not Appearing (2000)
To Do list (2003)
Encryption method used for [encrypt]? (2000)
Some shell fun (2004)
Shared Webstar Directory (1998)
Introduction/Tutorial/QuickStart (1997)
Draft Manual, Tutorial, and more (1997)
HELP WITH DATES (1997)