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 amassuming your [ShipVia] field does to. You will need to URL that valuein 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:
Oh, one more thing, since your ShipMethod values have spaces, I amassuming your [ShipVia] field does to. You will need to URL that valuein 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)