Re: formula.db problems

This WebDNA talk-list message is from

1999

It keeps the original formatting. 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 actuallyenter in their CC information.Then on the invoice.tpl page where the formula.db is invoked I have:[SetHeadercart=[cart]]&shipVia=[url][__shipVia][/url]&ShipToZip=[__ShipToZip]&CartIPAddress=[ipAddress][/SetHeader]On this same page my taxRate formula works so I know the ShipToZip is gettingpassed.taxRate [lookupdb=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 willbe used but guess what? I can't get shipVia to pass to the unitShipCost formulaeither. The shipVia is determined on the shoppingcart.tpl page too in the formusing 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:      Re: formula.db problems (PCS Technical Support 1999) Re: formula.db problems (es-sleestak 1999) RE:formula.db problems (PCS Technical Support 1999) RE:formula.db problems (es-sleestak 1999) Right!On the previous page (shoppingcart.tpl) I have:This way I can show the shopper how much the shipping will be before they actuallyenter in their CC information.Then on the invoice.tpl page where the formula.db is invoked I have:[SetHeadercart=[cart]]&shipVia=[url][__shipVia][/url]&ShipToZip=[__ShipToZip]&CartIPAddress=[ipaddress][/SetHeader]On this same page my taxRate formula works so I know the ShipToZip is gettingpassed.taxRate [lookupdb=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 willbe used but guess what? I can't get shipVia to pass to the unitShipCost formulaeither. The shipVia is determined on the shoppingcart.tpl page too in the formusing 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: Credit card types (1997) autosensing lanague selection (1997) listcookies works only sometimes (1997) Layers,Dreamweaver and WebCat Code (2000) Spawn doesn't work as advertised ... (2000) db access problem after switching to SSL (2001) Can [writefile] files be served thru webcat? (2000) [WebDNA] A new popuated field to a DB with 700.000 records (2009) Fun with Dates - finally resolved but.... (1997) Bug Report, maybe (1997) [WebDNA] Credit card processing (2012) Keep away (1997) Two prices in shoppingcart? (1997) Automatically resizing mac jpg's wi applescript (2000) PCS Customer submissions ? (1997) apostrophe in search item (1997) [WebDNA] Processor Maxing out (2010) Expiration of Carts (1997) WebCat on Alpha? (1997) Shipping cost brain lock (1999)