Shipcost lookup?
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 12199
interpreted = N
texte = hi all,Just working on a couple of scenerios with the GeneralStore demo.In formulas.db ther is a lineshipCost [lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost]Wich refernces the shipcosts.dbcurently it has entries such asShipMethod ShipCostFEDEX 5.00UPS 6.00etc.I want to create a ship cost based on what the subtotal is. So something like below, which doesn't work.ShipMethod ShipCostAustralia [showif[subtotal]<100] 5 [/showif][showif[subtotal]>100] 10 [/showif]International [showif[subtotal]<100] 10 [/showif][showif[subtotal]>100] 20 [/showif]If I put [lookup[showif[subtotal]<100] 5 [/showif]] directly into formulas.db, then that works.Any ideas from WC-land.cheers,Rick---------------------------------------------------------------------------Key Options Pty. Ltd.P.O. Box 1150Castle Hill, NSW, 2154AustraliaTel:+61-2-9899-9564Fax:+61-2-9899-9318Mob: 0412-205-113-----BEGIN PGP PUBLIC KEY BLOCK-----mQBPAzNMLcoAAAECAL5yuN2krMXeMwfcZPvWFJ0d6oMd++Pafsx0MkIGoTmHLz9iLYHOiyZfeWNcLRd4c6xHlPN36lyPe9Uw9jwbaQEAEQEAAbQiUmljaGFyZCBXeWxpZSA8cmlja3dAbWFnbmEuY29tLmF1PokAVQMFEDNLoSp71TD2PBtpAQEB3kMCAKQ5zd+aPODE2zw2Rht1duf4kVV6yXdC+ZSGYT0uGmkidgHS/Jw+uJvzHnKvR2ziAFrVpYMY6WMaf06yWFvekvc==prwK-----END PGP PUBLIC KEY BLOCK-----
Associated Messages, from the most recent to the oldest:
hi all,Just working on a couple of scenerios with the GeneralStore demo.In
formulas.db ther is a lineshipCost [lookup db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost]Wich refernces the shipcosts.dbcurently it has entries such asShipMethod ShipCostFEDEX 5.00UPS 6.00etc.I want to create a ship cost based on what the subtotal is. So something like below, which doesn't work.ShipMethod ShipCostAustralia [showif[subtotal]<100] 5 [/showif][showif[subtotal]>100] 10 [/showif]International [showif[subtotal]<100] 10 [/showif][showif[subtotal]>100] 20 [/showif]If I put [lookup[showif[subtotal]<100] 5 [/showif]] directly into
formulas.db, then that works.Any ideas from WC-land.cheers,Rick---------------------------------------------------------------------------Key Options Pty. Ltd.P.O. Box 1150Castle Hill, NSW, 2154AustraliaTel:+61-2-9899-9564Fax:+61-2-9899-9318Mob: 0412-205-113-----BEGIN PGP PUBLIC KEY BLOCK-----mQBPAzNMLcoAAAECAL5yuN2krMXeMwfcZPvWFJ0d6oMd++Pafsx0MkIGoTmHLz9iLYHOiyZfeWNcLRd4c6xHlPN36lyPe9Uw9jwbaQEAEQEAAbQiUmljaGFyZCBXeWxpZSA8cmlja3dAbWFnbmEuY29tLmF1PokAVQMFEDNLoSp71TD2PBtpAQEB3kMCAKQ5zd+aPODE2zw2Rht1duf4kVV6yXdC+ZSGYT0uGmkidgHS/Jw+uJvzHnKvR2ziAFrVpYMY6WMaf06yWFvekvc==prwK-----END PGP PUBLIC KEY BLOCK-----
Richard Wylie
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:
Searching an Email database (1997)
Help! WebCat2 bug (1997)
WebCat2final1 crashes (1997)
normal users.db calls ... (1998)
WebDNA Solutions ... sorry! (1997)
Oops, my mistake - (was Bad suffix error) (1997)
Deleting Multiple Database Records based on Checkbox (1998)
Emailer help....! (1997)
[url] (1997)
Security Hole - NetCloak Update (1998)
Template Security error (1997)
HomePage Caution (1997)
OT : OSX file limitations (2001)
Country & Ship-to address & other fields ? (1997)
Sendmail doesn't (was Queertrons?) (1997)
Date problems-more (1997)
[OT] : Chat Room on OSX (2003)
updating checkbox in a db (1998)
international time (1997)
[append] problem (1997)