RE:formula.db problems

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23464
interpreted = N
texte = 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:

    
  1. RE:formula.db problems (PCS Technical Support 1999)
  2. RE:formula.db problems (es-sleestak 1999)
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/ PCS Technical Support

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:

[lookup] vs. [search] (1998) WebCat2b13MacPlugIn - more [date] problems (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) A little help on e-mail (HELP!!! :-) ) (1998) Tax Collection for Different Items (2003) [WebDNA] [listwords] and [index] (2009) Append..... doesn't (2000) Re:Signal Raised (1997) Subtotal Not Calculated on Invoice.html (1998) passwords (2000) need e-commerce recommendation (2004) WebCatalog Technical Reference (1997) PCS Frames (1997) Resume Catalog ? (1997) Loosing Quantity (2000) Location of Browser Info.txt file (1997) Help with sorting search results sorting (1998) Navigator 4.01 (1997) Emailer errors & disappearing messages (1998) European Convention (2004)