creating a ShipCosts database

This WebDNA talk-list message is from

1997

It keeps the original formatting. numero = 12735
interpreted = N
texte = Am scratching my head (of thinning hair) on how to create a database forShipCosts.db that will allow me to charge for freight based on:(a) weight and (b) shipping method....And, oh yes, in the future, I'll want to also break out charges by:(c) zip code (first three digits)....but am not prepared to deal with zip codes yet!Before my newbie brain explodes, am seeking advice on this! To address weight and shipMethod....should I set up a ShipCosts.dbsimilar to below, then use Search with And to look up the correctprice...something like: [Search db=Shipcosts.db&eqWeight=[Weight]rqShipMethod=[ShipMethod]] Shipping Costs: [FoundItems][ShipCost][/FoundItems] [/Search]Or is there a better way to do this, say with more than one database(one for Ground and one for NextDay?) or using LookUp? TIA!Dale StokdykWorld Romancedstokdyk@dvs.mv.com--------------------------------------EXAMPLE db:Weight ShipMethod ShipCost1 Ground 3.002 Ground 4.003 Ground 4.504 Ground 5.001 NextDay 7.002 NextDay 7.003 NextDay 7.004 NextDay 9.005 NextDay 11.00-------------------------------------- Associated Messages, from the most recent to the oldest:

Re: creating a ShipCosts database (grichter@panavise.com (Gary Richter) 1997)
Re: creating a ShipCosts database (Grant Hulbert 1997)
Re: creating a ShipCosts database (Dale Stokdyk 1997)
Re: creating a ShipCosts database (Grant Hulbert 1997)
creating a ShipCosts database (Dale Stokdyk 1997)

Am scratching my head (of thinning hair) on how to create a database forShipCosts.db that will allow me to charge for freight based on:(a) weight and (b) shipping method....And, oh yes, in the future, I'll want to also break out charges by:(c) zip code (first three digits)....but am not prepared to deal with zip codes yet!Before my newbie brain explodes, am seeking advice on this! To address weight and shipMethod....should I set up a ShipCosts.dbsimilar to below, then use Search with And to look up the correctprice...something like: [Search db=Shipcosts.db&eqWeight=[Weight]rqShipMethod=[ShipMethod]] Shipping Costs: [founditems][ShipCost][/FoundItems] [/Search]Or is there a better way to do this, say with more than one database(one for Ground and one for NextDay?) or using LookUp? TIA!Dale StokdykWorld Romancedstokdyk@dvs.mv.com--------------------------------------EXAMPLE db:Weight ShipMethod ShipCost1 Ground 3.002 Ground 4.003 Ground 4.504 Ground 5.001 NextDay 7.002 NextDay 7.003 NextDay 7.004 NextDay 9.005 NextDay 11.00-------------------------------------- Dale Stokdyk

DOWNLOAD WEBDNA NOW!

creating a ShipCosts database

1997

Top Articles:

Related Readings: