Re: UnitShipCost, Formulas.db and passwords

This WebDNA talk-list message is from

2003

It keeps the original formatting. numero = 47248
interpreted = N
texte = Donovan, The url thing fixed the lookup part. I just need it to multiplythe resultant UnitShipCost by the line item quantity and I'm home free.Thanks for the help.Alphonse MacDonaldDirector of New Media & Information TechnologyIsland Press1718 Connecticut Ave. NWWashington DC, 20009Phone: (202) 232-7933 Ext. 44Fax: (202) 232-2741amacdonald@islandpress.orghttp://www.islandpress.orgThis e-mail and any files transmitted with it are confidential andintended solely for the addressee and may not be disclosed to orused by anyone other than the addressee. If you have receivedthis e-mail in error, please advise the sender immediately anddelete the email (and all attachments) from your computer system.Thank you.****************************************************************** Donovan To: (WebDNA Talk) Sent by: cc: (WebDNA Talk) 01/28/2003 10:33 AM Please respond to WebDNA-Talk 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 thatdid>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 toWeb Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------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:

Re: UnitShipCost, Formulas.db and passwords (John Peacock 2003)
Re: UnitShipCost, Formulas.db and passwords (Alphonse MacDonald 2003)
Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
UnitShipCost, Formulas.db and passwords (Alphonse MacDonald 2003)

Donovan, The url thing fixed the lookup part. I just need it to multiplythe resultant UnitShipCost by the line item quantity and I'm home free.Thanks for the help.Alphonse MacDonaldDirector of New Media & Information TechnologyIsland Press1718 Connecticut Ave. NWWashington DC, 20009Phone: (202) 232-7933 Ext. 44Fax: (202) 232-2741amacdonald@islandpress.orghttp://www.islandpress.orgThis e-mail and any files transmitted with it are confidential andintended solely for the addressee and may not be disclosed to orused by anyone other than the addressee. If you have receivedthis e-mail in error, please advise the sender immediately anddelete the email (and all attachments) from your computer system.Thank you.****************************************************************** Donovan To: (WebDNA Talk) Sent by: cc: formulas.db and passwords hmicro.com> (WebDNA Talk) 01/28/2003 10:33 AM Please respond to WebDNA-Talk 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 thatdid>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 toWeb Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------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/ Alphonse MacDonald

DOWNLOAD WEBDNA NOW!

Re: UnitShipCost, Formulas.db and passwords

2003

Top Articles:

Related Readings: