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:
Searching multiple Databases (1997)
Stop the madness. (1997)
Date search and sendmail (1997)
Need relative path explanation (1997)
Databases.tpl (2000)
Cant open pages generated by Webcat (2004)
HTTP header line is too long? (1997)
SetLineItem (1997)
The word TYPE in search contexts and fields (1998)
Running 2 two WebCatalog.acgi's (1996)
[WebDNA] [listfiles] error, but why? How to turn off (2010)
WC2f3 (1997)
sendmail for email (was Netforms) (1998)
Providing hard copy of database to client (1997)
WebCatalog + WebMerchant 2.1 for Windows released (1998)
Rhapsody? (1997)
WebMerchant bomb (1998)
Extra Text Fields (was Another question) (1997)
Error handling for accountNum (1997)
Multiple prices (1997)