changing prices in cart

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 12938
interpreted = N
texte = Hi all,I'm in the process of 'upgrading' from WC2b13 to 2.0. Some things that worked in the beta don't seem to work in the shipping version...specifically, changing the unitShipCost of products in the cart after they've been added. I'm probably missing something in the formula processing, so any advice appreciated.Problem: Each item in the database has several unitShipCosts associated with it based on destination (ship_ground, ship_overnight, ship_Japan, ...). On the shopping cart page, the customer clicks on a button denoting the ship destination (method).Current Method: Behind each destination button is a [lookup ] that sets the unitShipCost[index] to the value in the db for the appropriate field/destination. When the customer clicks the button, the lineItems in the cart are updated with the new unitShipCost value. This process no longer works in 2.0 (shipping). The [lookup ] still works fine, but the value in the cart isn't updated (it's set to 0). I suspect this has something to do with the souped up security preventing hacking the cart. Problem is I can't get the formulas.db to update the cart either.Formula code: [lookup db=/w3soft.db&lookInField=sku&value=[sku]&returnField=[shipLocale]][shipLocale] is defined by the button the customer clicks to go from basket.tmpl to invoice.tmpl. Is there a problem with passing a variable to the formula in this fashion? Per a discussion thread from July, I tried wrapping an [interpret] context around various parts of the code, nothing changed.----A different odd problem...When I check the open database list from the admin page, I get a lot of error:database xx could not be opened or found. But the databases are open and searching etc. work fine. Even the number of fields and records shows up correct in the admin table.This happen to anyone else? Thanks & regards,Jason Wallace W3soft Associated Messages, from the most recent to the oldest:

    
  1. changing prices in cart (jason@w3soft.com (Jason Wallace) 1997)
Hi all,I'm in the process of 'upgrading' from WC2b13 to 2.0. Some things that worked in the beta don't seem to work in the shipping version...specifically, changing the unitShipCost of products in the cart after they've been added. I'm probably missing something in the formula processing, so any advice appreciated.Problem: Each item in the database has several unitShipCosts associated with it based on destination (ship_ground, ship_overnight, ship_Japan, ...). On the shopping cart page, the customer clicks on a button denoting the ship destination (method).Current Method: Behind each destination button is a [lookup ] that sets the unitShipCost[index] to the value in the db for the appropriate field/destination. When the customer clicks the button, the lineItems in the cart are updated with the new unitShipCost value. This process no longer works in 2.0 (shipping). The [lookup ] still works fine, but the value in the cart isn't updated (it's set to 0). I suspect this has something to do with the souped up security preventing hacking the cart. Problem is I can't get the formulas.db to update the cart either.Formula code: [lookup db=/w3soft.db&lookInField=sku&value=[sku]&returnField=[shipLocale]][shipLocale] is defined by the button the customer clicks to go from basket.tmpl to invoice.tmpl. Is there a problem with passing a variable to the formula in this fashion? Per a discussion thread from July, I tried wrapping an [interpret] context around various parts of the code, nothing changed.----A different odd problem...When I check the open database list from the admin page, I get a lot of error:database xx could not be opened or found. But the databases are open and searching etc. work fine. Even the number of fields and records shows up correct in the admin table.This happen to anyone else? Thanks & regards,Jason Wallace W3soft jason@w3soft.com (Jason Wallace)

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:

WebCat2b15MacPlugin - showing [math] (1997) Commas in search (1998) shownext and searches (2002) WebCat2 as a chat server? (1997) Changing user submitted data (2000) Q: writefile and uploads. (1998) Problems getting parameters passed into email. (1997) Cool XML/XSLT tool .. (2002) ImageMagick and [shell] (2003) Refreshing document (2000) Just Started (1998) carriage returns in data (1997) RE: Help name our technology! (1997) Mac Vs WindowsNT (1997) no global [username] or [password] displayed ... (1997) RandSeed broken on 4.0.2 / Mac OS X (2002) WebDNA maxing out processor (2008) customers getting same cart (2004) WebDNA 4.5.1 Now Available (2003) converted seed value? (1998)