Re: the dreaded unitShipCost
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 53788
interpreted = N
texte = something about security and credit cards numbers. i told alain it was a stupid idea too but i think i got out voted... seriously though... i love webcat and all its uses EXCEPT CARTING. Jebus it pisses me off! the formulas database has got to be one of the most... count to ten andrew... deep breaths... ----- Original Message ----- From: "Stuart Tremain"
To: "WebDNA Talk" Sent: Tuesday, November 04, 2003 2:19 PM Subject: Re: the dreaded unitShipCost > Why don't you stop the cart sweep then you wouldn't have to go through > this. > > > On Tuesday, November 4, 2003, at 12:15 PM, Andrew Simpson wrote: > > > 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/ > > > > > Regards > > Stuart Tremain > idfk web developments > 114a/40 yeo street neutral bay 2089 australia > t +612 9908 2134 > f +612 9908 4837 > > > ------------------------------------------------------------- > 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:
something about security and credit cards numbers. i told alain it was a stupid idea too but i think i got out voted... seriously though... i love webcat and all its uses EXCEPT CARTING. Jebus it pisses me off! the formulas database has got to be one of the most... count to ten andrew... deep breaths... ----- Original Message ----- From: "Stuart Tremain" To: "WebDNA Talk" Sent: Tuesday, November 04, 2003 2:19 PM Subject: Re: the dreaded unitShipCost > Why don't you stop the cart sweep then you wouldn't have to go through > this. > > > On Tuesday, November 4, 2003, at 12:15 PM, Andrew Simpson wrote: > > > 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/ > > > > > Regards > > Stuart Tremain > idfk web developments > 114a/40 yeo street neutral bay 2089 australia > t +612 9908 2134 > f +612 9908 4837 > > > ------------------------------------------------------------- > 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:
WebCatalog for Dummies part 2 (2000)
Server replication (1998)
2 questions (2000)
Latin Characters (1998)
Cookie set browser session. (1998)
Formulas.db + Users.db (1997)
Fun with Dates - any progress? (1997)
[WebDNA] [OT] economical reliable SSL certs? (2009)
searching a range (2000)
[WebDNA] [OT] Merchant Provider Suggestions (2008)
WebCatalog: Server Will not Stay up & running (2001)
cookies and [returnraw] (1997)
checking for [ and ] in form fields ... (1997)
[WebDNA] HTTP crashes (2010)
[WebDNA] "Safe Write for Database" setting.... (2016)
Cart Database (1999)
turning every 5th line red (1998)
generate sequential numbers (1999)
test (1998)
Sitebuilder (2004)