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:
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:
$purchase WITHOUT creditcar (1997)
Opinion Poll Please (2002)
Next X hits (1996)
MATH PROBLEM (1997)
Signal Raised Error (1997)
Line items in table cells (1997)
still having shipCost.db Problem (1997)
taxTotal, grandTotal (1997)
financial calculation (2000)
Re1000001: Setting up shop (1997)
Re2: frames & carts (1997)
Forcing a NEWCART (1997)
Carts? (1998)
Fwd: checkboxes (2000)
generating a space delimited file (2001)
Date Formats (1997)
[OT] Half completed orders (2005)
[WebDNA] WebDNA-folder-Mac-FastCGI-8.5.1.zip (404 error) (2018)
RE: Re:Signal Raised (1997)
[isfile] ? (1997)