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 accessesformulas 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 thesecond time? Is there a variable in the formula which is incorrect for thesecond 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 accessesformulas 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 thesecond time? Is there a variable in the formula which is incorrect for thesecond 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:
[SHOWIF AND/OR] (1997)
Newbie problem blah blah blah (1997)
list cookies and list http headers (1997)
Multiple fields on 1 input (1997)
typhoon ? (2003)
Queertrons? (1997)
Duplicate Messages (1998)
[WebDNA] a major shift in strategy? (2008)
WebDNA on Cobalt Raq550 (2005)
WebCommerce: Folder organization ? (1997)
Transfer of data from Invoice to thank you templates (1998)
changing banners on a page without refresh? (2000)
I'm new be kind (1997)
Forumulas.db & Variables (2002)
admin/admin on NT4 (2000)
Whats going on? (2000)
FedEx Rate Calculator Completed (2002)
OT?: Size issues (2001)
So many lookers, hey smith micro (2003)
Submit buttons not working.... (1999)