Re: the dreaded unitShipCost
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 53791
interpreted = N
texte = ah nevermind, i'll just do the old tell the client its fixed trick and whenthey complain thats its still broken i'll say its a caching problem and askthem to check their flux capacitor.one of those buffer underrun overflow problems...----- Original Message ----- From: "Andrew Simpson"
To: "WebDNA Talk" Sent: Tuesday, November 04, 2003 2:52 PMSubject: Re: the dreaded unitShipCost> 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 seeingit,> > or are there other things in the formulas which ARE getting calculatedthe> > second time? Is there a variable in the formula which is incorrect forthe> > 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 correctlyand> > > available in the first instance and not in the second. does anybodyhave> 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/>-------------------------------------------------------------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:
ah nevermind, i'll just do the old tell the client its fixed trick and whenthey complain thats its still broken i'll say its a caching problem and askthem to check their flux capacitor.one of those buffer underrun overflow problems...----- Original Message ----- From: "Andrew Simpson" To: "WebDNA Talk" Sent: Tuesday, November 04, 2003 2:52 PMSubject: Re: the dreaded unitShipCost> 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 seeingit,> > or are there other things in the formulas which ARE getting calculatedthe> > second time? Is there a variable in the formula which is incorrect forthe> > 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 correctlyand> > > available in the first instance and not in the second. does anybodyhave> 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/>-------------------------------------------------------------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:
Surprise x and y post args (1998)
How to add product size choices to form? (1997)
Cold Fusion Buster (1997)
Redirect (2003)
SKU (1997)
Multiple prices per product (2004)
bug ? causes NT event log to fill (1997)
Accessing SQL server from OSX (2001)
Frames and WebCat (1997)
Jimmy Houssen (1998)
Mac Os X and WebCat (1999)
Bug Report, maybe (1997)
Cancel Subscription (1996)
Re:2nd WebCatalog2 Feature Request (1996)
Error with [applescript] (1999)
WebMerchant Integration with Verifone's vPOS (1998)
WebCat2b15MacPlugin - showing [math] (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
date and time stamp (2003)
WebCat2b13MacPlugIn - [include] (1997)