Re: WebDNA creates DUPLICATE SHOPPING CART NUMBERS
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 56107
interpreted = N
texte = Bob,Thanks for responding. I checked the orders.db file, and there isnothing. It is empty. Apparently, nothing is being written to theorders.db file eventhough hard copies of the orders ARE being created.Sounds strange. There is definitely more going on.Per Donovan's accusation that I did not pay for the code....I wouldgladly pay if the code fixed the problem. It has not. It may or maynot be why WebDNA is overwriting orders....I cannot prove or diprove it. ==20However, order overwriting all seems to start just after adding thecode. Perhaps order overwriting has been going on before that but I donot have the evidence.Now I do not plan on using the code...infact I am removing it right nowfrom the site to see if the order overwriting continues. =20thanks again for all those responding,citizen> I posted code a year or 2 back that fixes the problem on check out but ==20> it also has to have the orders in the orders.db file, all you need do =20> is lookup the order# in the order.db if its there do a "newcart" copy =20> old to new and redirect. Literally the buyer never has to see that you ==20> did this, they would simply advance to the billing page.>=20> here it is again, you would still need to adjust it for your own use.>=20> [!]Included on the check out page[/!]> [showif [lookup =20> db=3Ddatabases/=20>orders.db&lookinfield=3Dorder&value=3D[cart]&returnfield=3D[odate]¬found==3Dnf=20> ]!nf]> [redirect newshoppingcart.tpl?file=3D[cart][formvariables][hideif =20> [name]=3Dcart][hideif [name]=3Dcommand][hideif =20>[name]=3Dtemplate]&[name]=3D[URL][value][/URL][/hideif][/hideif][/hideif][/==20> formvariables]]> [/showif]>=20> then On the newshoppingcart.tpl page the following that redirects back ==20> to the original page you got redirected from:>=20> > [MOVEFILE from=3DShoppingCarts/[file]&to=3DShoppingCarts/[cart]]> [replace =20> db=3Ddatabases/activecart.db&eqAcartdata=3D[file]]Acart=3D[cart][/replace=]> [redirect checkout.tpl?cart=3D[cart]&[formvariables][hideif =20> [name]=3Dcart][hideif [name]=3Dfile][hideif =20>[name]=3Dtemplate]&[name]=3D[URL][value][/URL][/hideif][/hideif][/hideif][/==20> formvariables]&command=3Dshowcart]>=20> I don't care if the user uses the same shoppingcart for shopping just =20> if they use it to check out. I also don't keep the shoppingcarts =20> around, I remove them immediately after checkout. Citizen just needsto =20> check the archives before he goes running around like a chicken with =20> his head cut off. This is an old problem with easy and well stated =20> solutions.>=20>=20> On Feb 15, 2004, at 10:12 AM, Donovan Brooke wrote:>=20> > I spent some good quality time (months ago) with Citizen analyzing =20> > 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 anew =20> > 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.>=20>=20> -------------------------------------------------------------> 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:
Bob,Thanks for responding. I checked the orders.db file, and there isnothing. It is empty. Apparently, nothing is being written to theorders.db file eventhough hard copies of the orders ARE being created.Sounds strange. There is definitely more going on.Per Donovan's accusation that I did not pay for the code....I wouldgladly pay if the code fixed the problem. It has not. It may or maynot be why WebDNA is overwriting orders....I cannot prove or diprove it. ==20However, order overwriting all seems to start just after adding thecode. Perhaps order overwriting has been going on before that but I donot have the evidence.Now I do not plan on using the code...infact I am removing it right nowfrom the site to see if the order overwriting continues. =20thanks again for all those responding,citizen> I posted code a year or 2 back that fixes the problem on check out but ==20> it also has to have the orders in the orders.db file, all you need do =20> is lookup the order# in the order.db if its there do a "newcart" copy =20> old to new and redirect. Literally the buyer never has to see that you ==20> did this, they would simply advance to the billing page.>=20> here it is again, you would still need to adjust it for your own use.>=20> [!]Included on the check out page[/!]> [showif [lookup =20> db=3Ddatabases/=20>orders.db&lookinfield=3Dorder&value=3D[cart]&returnfield=3D[odate]¬found==3Dnf=20> ]!nf]> [redirect newshoppingcart.tpl?file=3D[cart][formvariables][hideif =20> [name]=3Dcart][hideif [name]=3Dcommand][hideif =20>[name]=3Dtemplate]&[name]=3D[url][value][/URL][/hideif][/hideif][/hideif][/==20> formvariables]]> [/showif]>=20> then On the newshoppingcart.tpl page the following that redirects back ==20> to the original page you got redirected from:>=20> > [MOVEFILE from=3DShoppingCarts/[file]&to=3DShoppingCarts/[cart]]> [replace =20> db=3Ddatabases/activecart.db&eqAcartdata=3D[file]]Acart=3D[cart][/replace=]> [redirect checkout.tpl?cart=3D[cart]&[formvariables][hideif =20> [name]=3Dcart][hideif [name]=3Dfile][hideif =20>[name]=3Dtemplate]&[name]=3D[url][value][/URL][/hideif][/hideif][/hideif][/==20> formvariables]&command=3Dshowcart]>=20> I don't care if the user uses the same shoppingcart for shopping just =20> if they use it to check out. I also don't keep the shoppingcarts =20> around, I remove them immediately after checkout. Citizen just needsto =20> check the archives before he goes running around like a chicken with =20> his head cut off. This is an old problem with easy and well stated =20> solutions.>=20>=20> On Feb 15, 2004, at 10:12 AM, Donovan Brooke wrote:>=20> > I spent some good quality time (months ago) with Citizen analyzing =20> > 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 anew =20> > 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.>=20>=20> -------------------------------------------------------------> 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/
citizen
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:
Exclude by date - multiple (1997)
WebCat cannot handle compatible search parameters? (1997)
WCS Newbie question (1997)
2.1b3 --> way slow (1997)
WebCatalog f2 Installation (1997)
RE: [BULK] RE: [WebDNA] RE: Error. WebDNA (version 5.1g or later) is not running. (2012)
Another question about credit cards (1997)
customizing the color of user's pages (1997)
A multi-processor savvy WebCatalog? (1997)
no global [username] or [password] displayed ... (1997)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
This list needs a digest: rant, rave... (1997)
Purchase command error problem (1997)
using showpage and showcart commands (1996)
Problem Transferring Variable Values (1998)
[WebDNA] How to use [function] (2012)
Add a field to the error log? (1997)
Out of the woodwork (2007)
target=_blank and form variables (1997)
how to check for no value while using [URL] to prevent cr (1999)