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:

WebDNA Solutions ... sorry! (1997) Negative number search (2000) Dubble Sku's in a Database (1999) OFF-TOPIC: Lending investors ... (2002) using WebCat for Associate Programs? (1998) Creating main- and sub-category search (1997) WebSTAR 2.1 freezes my Mac (1997) category index, drop down list (2005) [Sum] function? (1997) Getting total number of items ordered (1997) I have observed and I am gone. (1998) Setting up WebCatalog with Retail Pro data (1996) Not really WebCat (1997) Move WebDNA DB to MySQL (2005) Date Sorting (1997) Show shoppingcart after remove last item (1997) how to do multiple prices/item? (1998) Checking for blank form fields (sort of...) (1998) Windows and Webcat! (2000) login via cookies (2006)