Re: the dreaded unitShipCost
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 53789
interpreted = N
texte = 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 calculates the > 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 a database > so that, if they ever return to the site and log in again, i can ressurect > the contents of any un-purchased carts. The reason i store it in the > database is because the carts directories get cleared out every 1440 minutes > or something... so they are not always available. the above code works fine > and adds price, shipcost and tax perfectly each time. > > the problem i have is that when somebody returns to the site and the code > 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 have any > 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/
Associated Messages, from the most recent to the oldest:
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 calculates the > 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 a database > so that, if they ever return to the site and log in again, i can ressurect > the contents of any un-purchased carts. The reason i store it in the > database is because the carts directories get cleared out every 1440 minutes > or something... so they are not always available. the above code works fine > and adds price, shipcost and tax perfectly each time. > > the problem i have is that when somebody returns to the site and the code > 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 have any > 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/
Tim Robinson
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:
Multiple cart additions (1997)
Problems adding stuff to the shopping cart. (1997)
[WebDNA] WebDNA Roll Call (2013)
Sorting via date (2002)
WebDNA Promo Sound Bite (2003)
[searchString] (1997)
Re: (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
RE: [WebDNA] Minor error correction (2008)
b18 problem on NT 4.0 (1997)
when will the list move? (nm) (2000)
refreshing IE with posted .tmpl (1997)
SiteGuard Use Question (1997)
turning every 5th line red (1999)
Close Databases Crash? (1998)
Plugin or CGI or both (1997)
re:WebCatalog and Filemaker (1996)
DDEConnect not working (2006)
form data submission gets truncated (1997)
Frames and WebCat (1997)