UnitShipCost, Formulas.db and passwords
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 47244
interpreted = N
texte = I am trying to set up a shipping scheme that includes the followingshipping options in ShipCosts.dbShipMethod ShipCost UnitShipCostUPS Ground 6.75 3.00UPS 2 Day Air 20.00 10.00UPS 3 Day Select 12.00 3.00International Air 25.00 10.00International Surface 15.00 15.00I have set the following parameters in Formulas.dbName Formulaprice [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 [lookupdb=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=UnitShipCost]It works if I have a number and not an equation in the formulas.dbUnitShipCost line>From searching the Talk archive I have found that I must use the pricechange password to change the unitshipcost ina setlineitem context of the invoice file. I tried appending &password=mypassword to the end of my equation in formulas.db but that didnot 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][lookupdb=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 hasnyone overcome a similar problem?[lineitems][SetLineItem cart=[cart]&index=[lineindex]]quantity=[interpret][quantity[lineindex]][/interpret]&textA=[url][lookupdb=IslandPress.db&lookinfield=sku&value=[url][sku][/url]&returnfield=title][/url]UnitShipCost=[lookupdb=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=UnitShipCost]&password=mypassword[/SetLineItem][/lineitems]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.******************************************************************-------------------------------------------------------------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:
I am trying to set up a shipping scheme that includes the followingshipping options in ShipCosts.dbShipMethod ShipCost UnitShipCostUPS Ground 6.75 3.00UPS 2 Day Air 20.00 10.00UPS 3 Day Select 12.00 3.00International Air 25.00 10.00International Surface 15.00 15.00I have set the following parameters in formulas.dbName Formulaprice [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 [lookupdb=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=UnitShipCost]It works if I have a number and not an equation in the formulas.dbUnitShipCost line>From searching the Talk archive I have found that I must use the pricechange password to change the unitshipcost ina setlineitem context of the invoice file. I tried appending &password=mypassword to the end of my equation in formulas.db but that didnot 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][lookupdb=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 hasnyone overcome a similar problem?[lineitems][SetLineItem cart=[cart]&index=[lineindex]]quantity=[interpret][quantity[lineindex]][/interpret]&textA=[url][lookupdb=IslandPress.db&lookinfield=sku&value=[url][sku][/url]&returnfield=title][/url]UnitShipCost=[lookupdb=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=UnitShipCost]&password=mypassword[/SetLineItem][/lineitems]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.******************************************************************-------------------------------------------------------------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!
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:
Another bug to squash (WebCat2b13 Mac .acgi) (1997)
Parse question (2005)
about this server and links to who (1997)
Menu Madness (2001)
WebCat2b12--[searchstring] bug (1997)
search form problem.. (1997)
WebCat2 Append problem (B14Macacgi) (1997)
pc (1997)
OK, here goes... (1997)
canEmail? (1998)
Field Totals (2004)
RE: Timer Values on [redirect] (1998)
email database file (2005)
Problems with Price field (1997)
Hello??? (1997)
Fwd: State-of-the-Art Digital Aquarium for Your Computer (2006)
WebTen and WebCat (1997)
Associative lookup style? (1997)
Virtual hosting and webcatNT (1997)
[date format] w/in sendmail (1997)