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 of the formulas db but not the unitshipcost. the unitshipcost is just a fixed value anyway so its not dependant on the product 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 PM Subject: 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 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/ > ------------------------------------------------------------- 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 of the formulas db but not the unitshipcost. the unitshipcost is just a fixed value anyway so its not dependant on the product 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 PM Subject: 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 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/ > ------------------------------------------------------------- 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:
Quit revisited (1997)
Keep away (1997)
Strange intermittent WebDNA problems (2008)
Major Security Hole IIS NT (1998)
It just Does't add up!!! (1997)
[WebDNA] Conversion of 500.000 records; advise needed (2008)
color and size options / ARCHIVES (1997)
same bill to and ship to? (1998)
autosensing lanague selection (1997)
NetForms for mail, sorry (1998)
[BULK] [WebDNA] [BULK] which of these tags exist in 7.0 (2011)
WebDNA on RedHat ES 4 (2007)
Sorting by date (1997)
Other then credit cards-how? (1997)
Signal Raised Error (1997)
WebCat2: Items xx to xx shown, etc. (1997)
What is WebDNA (1997)
WebDNA 4.5 under IIS6, Win2003 (2003)
webcat2b12 CGI -- Date comparisons (1997)
Not really WebCat (1997)