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:
WC2.0 Memory Requirements (1997)
Clearing orders and database help! (1997)
encrypt (2000)
WebCatalog stalls (1998)
Trouble with carts (2000)
Support ?? (1997)
[url] link (1998)
PCS Emailer's role ? (1997)
SMSI, please fix the StandardConversions.db (2005)
server 2003 weirdness (2004)
Frames and WebCat (1997)
[OT] Theiving B*****ds (2004)
[ListFiles] context & alias (1997)
Calculating multiple shipping... (1997)
Nested search (1997)
Pulling Javascript from a DB (2004)
Design Help Needed (1998)
New Mac Emailer... (1997)
Opinion: [input] should be called [output] ... (1997)
[fullPath] bug? (1998)