Re: the dreaded unitShipCost
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 53790
interpreted = N
texte = it retrieves the price for the product and the taxrate for the tax out ofthe formulas db but not the unitshipcost.the unitshipcost is just a fixed value anyway so its not dependant on theproduct which is being added... its just a lookup to a "freight rules"database....----- Original Message ----- From: "Tim Robinson"
To: "WebDNA Talk" Sent: Tuesday, November 04, 2003 2:50 PMSubject: Re: the dreaded unitShipCost> Are both pages on the same 'level'. I can't remember how it accesses> formulas db. I can only assume on the second one, that it's not seeing it,> or are there other things in the formulas which ARE getting calculated the> second time? Is there a variable in the formula which is incorrect for the> second one?>> Regards,> Tim>> > From: "Andrew Simpson" > > Reply-To: (WebDNA Talk)> > Date: Tue, 4 Nov 2003 14:15:41 +1300> > To: (WebDNA Talk)> > Subject: the dreaded unitShipCost> >> > okay. this has me going completely nuts.> >> > In one of our stores, you can add stuff to the cart and it calculatesthe> > price, unitshipcost and tax based on the formulas database.> >> > the code that runs when you add something to your cart is as follows:> >> > [AddLineItem> > cart=[newcart]&sku=[sku]&db=/db/products.db]quantity=1[/AddLineItem]> >> > now, each time a user adds something to his cart i record this in adatabase> > so that, if they ever return to the site and log in again, i canressurect> > the contents of any un-purchased carts. The reason i store it in the> > database is because the carts directories get cleared out every 1440minutes> > or something... so they are not always available. the above code worksfine> > and adds price, shipcost and tax perfectly each time.> >> > the problem i have is that when somebody returns to the site and thecode> > runs to re-add the contents of their old cart to their new one, it> > completely misses the unitshipcost.> >> > here is the code that re-adds the products:> >> > [search> >db=/db/existing_detail.db&eqEXISTING_IDdatarq=[EXISTING_ID]&asLINE_IDsort=1&> > LINE_IDtype=number]> > [founditems]> > [AddLineItem> >cart=[newcart]&sku=[PROD_SKU]&db=/db/products.db]quantity=1[/AddLineItem]> > [/founditems]> > [/search]> >> >> > now i don't understand why the unitshipcost is calculated correctly and> > available in the first instance and not in the second. does anybody haveany> > ideas????> >> >> >> > -------------------------------------------------------------> > 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:
it retrieves the price for the product and the taxrate for the tax out ofthe formulas db but not the unitshipcost.the unitshipcost is just a fixed value anyway so its not dependant on theproduct which is being added... its just a lookup to a "freight rules"database....----- Original Message ----- From: "Tim Robinson" To: "WebDNA Talk" Sent: Tuesday, November 04, 2003 2:50 PMSubject: Re: the dreaded unitShipCost> Are both pages on the same 'level'. I can't remember how it accesses> formulas db. I can only assume on the second one, that it's not seeing it,> or are there other things in the formulas which ARE getting calculated the> second time? Is there a variable in the formula which is incorrect for the> second one?>> Regards,> Tim>> > From: "Andrew Simpson" > > Reply-To: (WebDNA Talk)> > Date: Tue, 4 Nov 2003 14:15:41 +1300> > To: (WebDNA Talk)> > Subject: the dreaded unitShipCost> >> > okay. this has me going completely nuts.> >> > In one of our stores, you can add stuff to the cart and it calculatesthe> > price, unitshipcost and tax based on the formulas database.> >> > the code that runs when you add something to your cart is as follows:> >> > [AddLineItem> > cart=[newcart]&sku=[sku]&db=/db/products.db]quantity=1[/AddLineItem]> >> > now, each time a user adds something to his cart i record this in adatabase> > so that, if they ever return to the site and log in again, i canressurect> > the contents of any un-purchased carts. The reason i store it in the> > database is because the carts directories get cleared out every 1440minutes> > or something... so they are not always available. the above code worksfine> > and adds price, shipcost and tax perfectly each time.> >> > the problem i have is that when somebody returns to the site and thecode> > runs to re-add the contents of their old cart to their new one, it> > completely misses the unitshipcost.> >> > here is the code that re-adds the products:> >> > [search> >db=/db/existing_detail.db&eqEXISTING_IDdatarq=[EXISTING_ID]&asLINE_IDsort=1&> > LINE_IDtype=number]> > [founditems]> > [AddLineItem> >cart=[newcart]&sku=[PROD_SKU]&db=/db/products.db]quantity=1[/AddLineItem]> > [/founditems]> > [/search]> >> >> > now i don't understand why the unitshipcost is calculated correctly and> > available in the first instance and not in the second. does anybody haveany> > ideas????> >> >> >> > -------------------------------------------------------------> > 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/
"Andrew Simpson"
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:
2.1 Stuff (1998)
WebDNA 5 - Privacy Issue (Built in sniffer) (2003)
purchase plugin (1996)
WebCat2 - Getting to the browser's username/password data (1997)
Running 2 two WebCatalog.acgi's (1996)
autosensing lanague selection (1997)
Forms Search Questions (1997)
Problems with date math (1997)
[include ...] behavior (1997)
Share Snippet? (1999)
SSL and WebCatalog (1997)
Make sure I understand this??? (1997)
Banners (1997)
sendmail tag when with in comment tags. (2000)
Putting together a econimic server (2004)
still having shipCost.db Problem (1997)
Some Questions (1997)
WebCat2b13MacPlugIn - More limits on [include] (1997)
Checking two required fields (1998)
dont want to use credit card authorisation yet (2000)