Re: formula.db problems
This WebDNA talk-list message is from 1999
numero = 23467
interpreted = N
texte = Right! On the previous page (shoppingcart.tpl) I have:
This way I can show the shopper how much the shipping will be before they actually enter in their CC information. Then on the invoice.tpl page where the formula.db is invoked I have:[SetHeader cart=[cart]]&shipVia=[url][__shipVia][/url]&ShipToZip=[__ShipToZip]&CartIPAddress=[ipAddress][/SetHeader]On this same page my taxRate formula works so I know the ShipToZip is getting passed. taxRate [lookup db=PacBusTaxRates.db&lookInField=zipcode&value=[ShipToZip]&returnField=taxRate¬Found=0.00]btw I would also like to do [showif]'s too to determine what shipping formula will be used but guess what? I can't get shipVia to pass to the unitShipCost formula either. The shipVia is determined on the shoppingcart.tpl page too in the form using a drop down menu.
PCS Technical Support wrote:> Are you positive that the ShipToZip has been already set at this stage? > Usually when people are first adding items to the cart, the ShipToZip is > unknown. Since this formula only evaluates *once* at the moment an item is > added to the cart, it needs to know the ShipToZip beforehand. > > >Okay that helped. The first formula was for fed ex but I also have one > >for UPS that I'm having problems with. It looks like this: > > > >unitShipCost [lookup db=fed-x.db&lookInField=Lbs&value=[format > >.0f][search > >db=main2.txt&eqSKUdata=[sku]][founditems][Weight][/founditems][/search][/format > >]&returnField=[search > >db=zones.txt&leFROMdatarq=[ShipToZip]&geTOdatarq=[ShipToZip]&max=1][foundItems] > >[zone][/foundItems][/search]¬Found=0] > > > >The problem I am having with this one is the [ShipToZip] isn't getting > >passed. When I hard code the zip code in it works fine. The strange > >thing is that in my taxRate formula I use this same exact variable and > >it works. How can I get the ship to zip to get passed into my > >unitShipCost formula? > > Technical Support | ==== eCommerce and Beyond ==== > Pacific Coast Software | WebCatalog, WebMerchant, > 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, > San Diego, CA 92128 | Typhoon > 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:[cart] ]&shipVia=[url] [__shipVia][/url]&ShipToZip=[__ShipToZip]&CartIPAddress=[ipaddress] [/SetHeader]On this same page my taxRate formula works so I know the ShipToZip is getting passed. taxRate [lookup db=PacBusTaxRates.db&lookInField=zipcode&value=[ShipToZip]&returnField=taxRate¬Found=0.00]btw I would also like to do [showif] 's too to determine what shipping formula will be used but guess what? I can't get shipVia to pass to the unitShipCost formula either. The shipVia is determined on the shoppingcart.tpl page too in the form using a drop down menu. PCS Technical Support wrote:> Are you positive that the ShipToZip has been already set at this stage? > Usually when people are first adding items to the cart, the ShipToZip is > unknown. Since this formula only evaluates *once* at the moment an item is > added to the cart, it needs to know the ShipToZip beforehand. > > >Okay that helped. The first formula was for fed ex but I also have one > >for UPS that I'm having problems with. It looks like this: > > > >unitShipCost [lookup db=fed-x.db&lookInField=Lbs&value=[format > >.0f][search > >db=main2.txt&eqSKUdata=[sku]][founditems] [Weight][/founditems][/search][/format > >]&returnField=[search > >db=zones.txt&leFROMdatarq=[ShipToZip]&geTOdatarq=[ShipToZip]&max=1][founditems] > >[zone][/foundItems][/search]¬Found=0] > > > >The problem I am having with this one is the [ShipToZip] isn't getting > >passed. When I hard code the zip code in it works fine. The strange > >thing is that in my taxRate formula I use this same exact variable and > >it works. How can I get the ship to zip to get passed into my > >unitShipCost formula? > > Technical Support | ==== eCommerce and Beyond ==== > Pacific Coast Software | WebCatalog, WebMerchant, > 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, > San Diego, CA 92128 | Typhoon > 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
es-sleestak
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:
Thanks ! (1997) Search returns all, not 20 (1997) Nice package (1998) Associative lookup style? + bit more (1997) WebCat.acgi from /cgi-bin/? (1997) WebMerchant Process Orders errors (2000) Fwd: Problems with Webcatalog Plug-in (1997) Re:multiple digests, please stop (1997) Download URL & access on the fly ? (1997) empty shopping cart message (1997) sort problems....bug or brain fart? (1997) [WriteFile] problems (1997) problem with NT beta (1997) Show shoppingcart after remove last item (1997) Searching Multiple DBs (1997) Looking up two prices in database? (1997) Setting up the server (1997) multi-paragraph fields (1997) Suffix or Line? (1999) searching for last file in a directory (1999)