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:
Webcat 3.0.7 & Webmerchant (2002)
Only charge card when product shipped ? (1997)
MacWEEK article help needed (1996)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
MacAuthorize order data fields WAS:How To question... (1997)
WebCatalog in the search engines (2001)
question: back button prevention (1997)
ListFiles (2000)
Line items in table cells (1997)
emailer on Windows Beta 18 (1997)
Concealing WebCatalog in the URL (2000)
Listserver problem (1997)
OT Big Brother (please ignore this sociological trivia) (2000)
SSL and WebCatalog (1997)
New WebCatalog Version !!! (1997)
PSC recommends what date format yr 2000??? (1997)
Variables in a Prefernce File (2005)
Replace Statement (1997)
Setting up shop (1997)
WebCat2b12 - nesting [tags] (1997)