Re: UnitShipCost, Formulas.db and passwords

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 47246
interpreted = N
texte = Oh, one more thing, since your ShipMethod values have spaces, I am assuming your [ShipVia] field does to. You will need to URL that value in the lookup! [url][ShipVia][/url]DonovanAlphonse MacDonald wrote:>I am trying to set up a shipping scheme that includes the following >shipping options in ShipCosts.db > >ShipMethod ShipCost UnitShipCost >UPS Ground 6.75 3.00 >UPS 2 Day Air 20.00 10.00 >UPS 3 Day Select 12.00 3.00 >International Air 25.00 10.00 >International Surface 15.00 15.00 > >I have set the following parameters in Formulas.db > >Name Formula >price [lookup db=IslandPress.db&lookInField=sku&value=[sku] >&returnField=price] >taxRate [lookup db=TaxRates.db&lookInField=State&value >=[ShipTostate]&returnField=taxRate¬Found=0.00] >shipCost [lookup db=ShipCosts.db&lookInField=ShipMethod&value >=[shipVia]&returnField=ShipCost] >UnitShipCost [lookup >db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia] >&returnField=UnitShipCost] > > >It works if I have a number and not an equation in the formulas.db >UnitShipCost line > >>From searching the Talk archive I have found that I must use the price >change password to change the unitshipcost in >a setlineitem context of the invoice file. I tried appending >&password=mypassword to the end of my equation in formulas.db but that did >not work so I turned my attention to the invoice file. > >I had the following in there to start. > >[lineitems] >[SetLineItem cart=[cart]&index=[lineindex]]quantity >=[interpret][quantity[lineindex]][/interpret]&textA=[url][lookup >db=IslandPress.db&lookinfield=sku&value=[url][sku][/url] >&returnfield=title][/url] > >[/SetLineItem] >[/lineitems] > >I changed it the following but it still does not work. HELP please has >nyone overcome a similar problem? > >[lineitems] >[SetLineItem cart=[cart]&index=[lineindex]]quantity >=[interpret][quantity[lineindex]][/interpret]&textA=[url][lookup >db=IslandPress.db&lookinfield=sku&value=[url][sku][/url] >&returnfield=title][/url]UnitShipCost=[lookup >db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia] >&returnField=UnitShipCost]&password=mypassword >[/SetLineItem] >[/lineitems] > >Alphonse MacDonald >Director of New Media & Information Technology >Island Press >1718 Connecticut Ave. NW >Washington DC, 20009 >Phone: (202) 232-7933 Ext. 44 >Fax: (202) 232-2741 >amacdonald@islandpress.org >http://www.islandpress.org > > >This e-mail and any files transmitted with it are confidential and >intended solely for the addressee and may not be disclosed to or >used by anyone other than the addressee. If you have received >this e-mail in error, please advise the sender immediately and >delete the email (and all attachments) from your computer system. >Thank you. >****************************************************************** > > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://webdna.smithmicro.com/ > > >-- -Donovan Brooke -Administrator of IT / -Assc. Art Director -Creative Services -Epsen Hillmer Graphics-402.342.1169 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: UnitShipCost, Formulas.db and passwords (John Peacock 2003)
  2. Re: UnitShipCost, Formulas.db and passwords (Alphonse MacDonald 2003)
  3. Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
  4. Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
  5. Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
  6. UnitShipCost, Formulas.db and passwords (Alphonse MacDonald 2003)
Oh, one more thing, since your ShipMethod values have spaces, I am assuming your [ShipVia] field does to. You will need to URL that value in the lookup! [url][ShipVia][/url]DonovanAlphonse MacDonald wrote:>I am trying to set up a shipping scheme that includes the following >shipping options in ShipCosts.db > >ShipMethod ShipCost UnitShipCost >UPS Ground 6.75 3.00 >UPS 2 Day Air 20.00 10.00 >UPS 3 Day Select 12.00 3.00 >International Air 25.00 10.00 >International Surface 15.00 15.00 > >I have set the following parameters in formulas.db > >Name Formula >price [lookup db=IslandPress.db&lookInField=sku&value=[sku] >&returnField=price] >taxRate [lookup db=TaxRates.db&lookInField=State&value >=[ShipTostate]&returnField=taxRate¬Found=0.00] >shipCost [lookup db=ShipCosts.db&lookInField=ShipMethod&value >=[shipVia]&returnField=ShipCost] >UnitShipCost [lookup >db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia] >&returnField=UnitShipCost] > > >It works if I have a number and not an equation in the formulas.db >UnitShipCost line > >>From searching the Talk archive I have found that I must use the price >change password to change the unitshipcost in >a setlineitem context of the invoice file. I tried appending >&password=mypassword to the end of my equation in formulas.db but that did >not work so I turned my attention to the invoice file. > >I had the following in there to start. > >[lineitems] >[SetLineItem cart=[cart]&index=[lineindex]]quantity >=[interpret][quantity[lineindex]][/interpret]&textA=[url][lookup >db=IslandPress.db&lookinfield=sku&value=[url][sku][/url] >&returnfield=title][/url] > >[/SetLineItem] >[/lineitems] > >I changed it the following but it still does not work. HELP please has >nyone overcome a similar problem? > >[lineitems] >[SetLineItem cart=[cart]&index=[lineindex]]quantity >=[interpret][quantity[lineindex]][/interpret]&textA=[url][lookup >db=IslandPress.db&lookinfield=sku&value=[url][sku][/url] >&returnfield=title][/url]UnitShipCost=[lookup >db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia] >&returnField=UnitShipCost]&password=mypassword >[/SetLineItem] >[/lineitems] > >Alphonse MacDonald >Director of New Media & Information Technology >Island Press >1718 Connecticut Ave. NW >Washington DC, 20009 >Phone: (202) 232-7933 Ext. 44 >Fax: (202) 232-2741 >amacdonald@islandpress.org >http://www.islandpress.org > > >This e-mail and any files transmitted with it are confidential and >intended solely for the addressee and may not be disclosed to or >used by anyone other than the addressee. If you have received >this e-mail in error, please advise the sender immediately and >delete the email (and all attachments) from your computer system. >Thank you. >****************************************************************** > > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://webdna.smithmicro.com/ > > >-- -Donovan Brooke -Administrator of IT / -Assc. Art Director -Creative Services -Epsen Hillmer Graphics-402.342.1169 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Donovan

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:

REPLACE problem (2000) Writing a Protect Tag (1999) attachment (2000) More! on [ShowCart] and GET vs. POST (1997) shipcost (1997) WebCat Error Log problem (2.0.1, acgi, Mac) (1997) New Command prefs ... (1997) help needed: Non-english characters in WebCatalog (1997) RE: Sorting error (1997) email code (1998) Banners and sort of random display (1997) Need relative path explanation (1997) Surprise x and y post args (1998) variables in [addlineitem] (1998) [OT] will work for... (2003) Further on formula.db failure to calculate shipCost (1997) WebCatalog can't find database (1997) [append] (1997) A dynamic database. (1997) Help formatting search results w/ table (1997)