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:
WC2b15 - [HTMLx]...[/HTMLx] problems SOLVED! (1997)
Page-Execution-Timer...PHP vs WebDNA (2004)
PIXO support (1997)
Lost Field (1998)
OR-searching (2000)
upgrading (1997)
Running _every_ page through WebCat-error.html (1997)
WebCatalog for Postcards ? (1997)
Problems appending to database (1997)
WebCat2 beta 11 - new prefs ... (1997)
Unknown error: OrderNotCreated (1997)
Keyword search (2004)
Grouping search fields, etc. (1997)
Before I Can Begin . . . (1998)
Proper file locations (1997)
Pithy questions on webcommerce & siteedit (1997)
[WebDNA] Pinterest kinda site? (2013)
BUG in [showif] using ^ (contains) (1997)
price on detail, but not shoppingcart (1997)
Another OS 10.3 Upgrade issue (2004)