Re: shipcost
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 15123
interpreted = N
texte = As I put my book away, wiping my brow in a sweat of confusion, Icongradulate you!!RayAt 03:02 PM 11/25/97 -0000, you wrote:>ohmygod, I think it works. I put the formatted shipcost in the lookup >and I am in fact getting the right numbers. Here is my solution.>>[lookup db=ship.db&lookInField=subtot&value=[format >.0f][subtotal][/format]&returnField=shipping¬Found=over$500, please >call]>>Thank you so much for all you help Grant and Ray and Ken and everyone. >YEA!!!>>Janna>>>I believe he was refering to the [format .0f] to round your prices. such as>>[format .0f][shipping][/format] should show 1.00, if that's what's found,>>go ahead and take the f out of your database. This might solve your problem.>>>>What your trying to match (i believe) is the subtotal of the purchase, to a>>dollar amount in your shipping database, to return the proper cost of>>shipping for that ammount. When your search looks at that database trying>>to compare 10.00 and sees 10.00f it doesn't consider that a match. So by>>taking the f out, it should. =) >>>>Ray>>>>>>>>At 12:20 PM 11/25/97 -0000, you wrote:>>>Good question. Here was Grant's reason: To simplify this, you could >>>round off to the nearest dollar with [format .0f] and then your database >>>would only have whole dollars in it. That has the advantage that it's >>>very easy to update your shipping tables (I know it's really hard to read >>>those formulas, so a table would be nice).>>>>>>Janna>>>>>>>I'm curious what the { f } is for in your actual database, why not just1.0?>>>>>>>>Ray>>>>>>>>At 11:45 AM 11/25/97 -0000, you wrote:>>>>>BTW: I also tried it with the math formula instead of the [subtotal]:>>>>>[format .2f][math show=f]sub=0[/math][LineItems][math >>>>>show=F]sub=sub+[quantity]*[price][/math][/lineitems][math]sub[/math][/forma>>>>>t]>>>>>>>>>> and in my lookup formula used [math]:>>>>>[lookup >>>>>db=ship.db&lookInField=subtot&value=[math]&returnField=shipping¬Found=ov>>>>>er$500, please call]>>>>>>>>>> but then I just get a blank response.>>>>>>>>>>Janna>>>>>>>>>>>>>>>>OK, so I have made a database and use the following formula asinstead of >>>>>>[shipcost] in my Invoice.tmpl (I tried using it in the formula.db,but it >>>>>>didn't work, but that is fine 'cause now it is working in the Invoice >>>>>>page).>>>>>>>>>>>>$[lookup >>>>>>db=ship.db&lookInField=subtot&value=[subtotal]&returnField=shipping¬F>>oun>>>>>>d=over$500, please call]>>>>>>>>>>>>My ship.db looks like this:>>>>>>subtot shipping>>>>>>1.0f 1>>>>>>2.0f 1>>>>>>3.0f 1>>>>>>4.0f 1>>>>>>5.0f 1>>>>>>6.0f 1>>>>>>7.0f 1>>>>>>8.0f 1>>>>>>9.0f 1>>>>>>10.0f 1>>>>>>>>>>>>and so until 500>>>>>>>>>>>>But my shipping keeps getting returned as over$500, please call. Why >>>>>>can't the formula find the subtotal? Did I use the .0f incorrectly?>>>>>>>>>>>>Janna>>>>>>>>>>>>>>>>>>>>>>>>Oh. I get it. I think you are right about using the lookup table. I >>>>>>will try it.>>>>>>>>>>>>Thank you,>>>>>>Janna>>>>>>>>>>>>First off, I think you're better off using a database table lookup>>>>because >>>>>>you have so many ranges that it causes the shipCost formula to bloat. >>>>>>Tables are a nice way to simplify these kinds of calculations, and they >>>>>>are not a 'waste' of databases.>>>>>>>>>>>>But, using your current technique, you would use [math] to 'remember' a >>>>>>numeric value for later use, and stick that math equation at the>>>>beginning >>>>>>of your shipcost formula. The math context remembers all its variable >>>>>>names for the duration of the page.>>>>>>>>>>>>[math show=f]sub=all the stuff to calc the subtotal[/math][showif >>>>>>[math]sub[/math]<20.00]...[/showif]>>>>>>>>>>>>Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of>>Us >>>>>====>>>>>>Pacific Coast Software | WebCatalog, WebMerchant,>>>>>>11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,>>>>>>San Diego, CA 92128 | Typhoon>>>>>>619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>******************************>>>>>>Janna S. Kohen>>>>>>Big Mind Media L. L. C.>>>>>>http://www.bigmindmedia.com/>>>>>>janna@bigmindmedia.com >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Associated Messages, from the most recent to the oldest:
|
- Re: Updating shipcost ( Mark Derrick 2005)
- Updating shipcost ( Mark Derrick 2005)
- Re: Shipcost formula ( WJC Limited 2004)
- Re: Shipcost formula ( WJC Limited 2004)
- Re: Shipcost formula ( Gary Krockover 2004)
- Re: Shipcost formula ( Gary Krockover 2004)
- Re: Shipcost formula ( WJC Limited 2004)
- Re: Shipcost formula ( Gary Krockover 2004)
- Re: Shipcost formula ( WJC Limited 2004)
- Re: Shipcost formula ( Gary Krockover 2004)
- Re: Shipcost formula ( WJC Limited 2004)
- Re: Shipcost formula ( Gary Krockover 2004)
- Shipcost formula ( WJC Limited 2004)
- Re: Shipcost formula ( WJC Limited 2004)
- Re: Shipcost formula ( Gary Krockover 2004)
- Shipcost formula ( WJC Limited 2004)
- Re: the dreaded unitShipCost ( Stuart Tremain 2003)
- Re: the dreaded unitShipCost ( Donovan Brooke 2003)
- Re: the dreaded unitShipCost ( Stuart Tremain 2003)
- Re: the dreaded unitShipCost ( Donovan Brooke 2003)
- Re: the dreaded unitShipCost ( Stuart Tremain 2003)
- Re: the dreaded unitShipCost ( Donovan Brooke 2003)
- Re: the dreaded unitShipCost ( Stuart Tremain 2003)
- Re: the dreaded unitShipCost ( John Peacock 2003)
- Re: the dreaded unitShipCost ( Donovan Brooke 2003)
- Re: the dreaded unitShipCost ( Alain Russell 2003)
- Re: the dreaded unitShipCost ( Alain Russell 2003)
- Re: the dreaded unitShipCost ( Donovan Brooke 2003)
- Re: the dreaded unitShipCost ( John Peacock 2003)
- Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
- Re: the dreaded unitShipCost ( Donovan Brooke 2003)
- Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
- Re: the dreaded unitShipCost ( Donovan Brooke 2003)
- Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
- Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
- Re: the dreaded unitShipCost ( Tim Robinson 2003)
- Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
- Re: the dreaded unitShipCost ( Stuart Tremain 2003)
- the dreaded unitShipCost ( "Andrew Simpson" 2003)
- Re: Taxes shipcost ( "Helpdesk - Jambolaya" 2003)
- Taxes shipcost ( "Helpdesk - Jambolaya" 2003)
- Re: UnitShipCost Slight Return (Donovan 2003)
- UnitShipCost Slight Return (Alphonse MacDonald 2003)
- 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)
- Re: shopcost, unitshipcost (Andrew Simpson 2002)
- Re: shopcost, unitshipcost (Donovan Brooke 2002)
- Re: shopcost, unitshipcost (Arturo Vargas 2002)
- Re: shopcost, unitshipcost (Andrew Simpson 2002)
- shopcost, unitshipcost (Arturo Vargas 2002)
- Re: unitShipCost - setlineitem nevermind (Donovan 2002)
- unitShipCost - setlineitem (Donovan 2002)
- Re: and more [shipcost].... (Arturo Vargas 2001)
- Re: and more [shipcost].... (Glenn Busbin 2001)
- Re: and more [shipcost].... (Arturo Vargas 2001)
- Re: and more [shipcost].... (Anup Setty 2001)
- Re: and more [shipcost].... (Arturo Vargas 2001)
- Re: and more [shipcost].... (Anup Setty 2001)
- and more [shipcost].... (Arturo Vargas 2001)
- shipCost problems (Nitai @ Eyework 2000)
- Re: Stumped on ShipCosts.db Problem (Bob McPeak 2000)
- Re: Stumped on ShipCosts.db Problem (John Butler 2000)
- Re[2]: shipCost -vs- shippingtotal ? (jpeacock@univpress.com 2000)
- Re: shipCost -vs- shippingtotal ? (John Butler 2000)
- Re[2]: shipCost -vs- shippingtotal ? (jpeacock@univpress.com 2000)
- Re[2]: shipCost -vs- shippingtotal ? (jpeacock@univpress.com 2000)
- Re: shipCost -vs- shippingtotal ? (John Butler 2000)
- Re: shipCost -vs- shippingtotal ? (John Butler 2000)
- Re: shipCost -vs- shippingtotal ? (John Butler 2000)
- Re: shipCost -vs- shippingtotal ? (jpeacock@univpress.com 2000)
- shipCost -vs- shippingtotal ? (John Butler 2000)
- Correction: shipCost (Robert Wade 2000)
- shipCost (Robert Wade 2000)
- Re: shipcost and Formulas.db (John Butler 2000)
- Re: shipcost and Formulas.db (Chris Vargas 2000)
- Re: shipcost and Formulas.db (Chris Vargas 2000)
- Re: shipcost and Formulas.db (John Butler 2000)
- shipcost and Formulas.db (Chris Vargas 2000)
- Re: Calculate UnitShipCost in Formulas.db (Smith Micro Support 1999)
- Re: Calculate UnitShipCost in Formulas.db (Rodolfo de la Garza 1999)
- Re: Calculate UnitShipCost in Formulas.db (Chris Vargas 1999)
- Calculate UnitShipCost in Formulas.db (Rodolfo de la Garza 1999)
- Setting shipCost -- thanks! (Chris Vargas 1999)
- Re: ShipCost formula (for weight *and* quantities)? (PCS Technical Support 1998)
- ShipCost formula (for weight *and* quantities)? (Dale Stokdyk 1998)
- Re: TaxRate and ShipCost Problem (PCS Technical Support 1998)
- TaxRate and ShipCost Problem (Karl Isselhardt 1998)
- Re: ShipCost and TaxRate problems (PCS Technical Support 1998)
- Re: shipCost (PCS Technical Support 1998)
- Re: shipCost (Brian B. Burton 1998)
- ShipCost and TaxRate problems (Karl Isselhardt 1998)
- Re: shipCost (PCS Technical Support 1998)
- shipCost (Brian B. Burton 1998)
- Re: When is unitShipCost calculated? (Luke Melia 1998)
- Re: When is unitShipCost calculated? (Brian Drum 1998)
- Re: When is unitShipCost calculated? (Brian Drum 1998)
- Re: When is unitShipCost calculated? (PCS Technical Support 1998)
- When is unitShipCost calculated? (Brian Drum 1998)
- Shipcost Based on SubTotal (Michael Fichtenmayer 1998)
- [unitshipcost] values do NOT write to orderfile (Kenneth Grome 1998)
- Re: ShipCost Problems (PCS Technical Support 1998)
- ShipCost Problems (Richard Kirsner 1998)
- Re: ShipCost Data Base (Kenneth Grome 1998)
- Re: ShipCost Data Base (Richard Kirsner 1998)
- Re: ShipCost Data Base (Kenneth Grome 1998)
- Re: ShipCost Data Base (bob 1998)
- ShipCost Data Base (Richard Kirsner 1998)
- Re: shipCost (PCS Technical Support 1998)
- shipCost (Raymond Hatch (by way of Jay Van Vark) 1998)
- Re: shipCost (Raymond Hatch 1998)
- Re: shipcost - cleaner with a table (Brian B. Burton 1998)
- shipcost - cleaner with a table (PCS Technical Support 1998)
- Shipcost Prob solved, new one arises (Kevin Furuta 1998)
- shipcost - fed up with the old way (Kevin Furuta 1998)
- Re: shipcost vs shiptotal (PCS Technical Support 1998)
- shipcost vs shiptotal (Kevin Furuta 1998)
- Re: shipCost not working v2.1b4 (Grant Hulbert 1997)
- Re: shipCost not working v2.1b4 (Pat McCormick 1997)
- Re: shipCost not working v2.1b4 (Pat McCormick 1997)
- shipCost not working v2.1b4 (Pat McCormick 1997)
- more on the Shipcost update problem (Jim Lanford 1997)
- Shipcost update problem (Jim Lanford 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Grant Hulbert 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Grant Hulbert 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Grant Hulbert 1997)
- Re: shipcost (Grant Hulbert 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (grichter@panavise.com (Gary Richter) 1997)
- Re: shipcost (Kenneth Grome 1997)
- Re: shipcost (Kenneth Grome 1997)
- Re: shipcost (Kenneth Grome 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Raymond Hatch 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- Re: shipcost (Janna S. Kohen 1997)
- shipcost (Janna S. Kohen 1997)
- Re: [shipCost] math formula? (Grant Hulbert 1997)
- [shipCost] math formula? (dwilfong@world-wide-art.com (David Wilfong) 1997)
- shipCost formula (Janna S. Kohen 1997)
- calculating ShipCost depending on weight (Mike Heininger 1997)
- RE: Tax and ShipCost Problem (Marc Eagle 1997)
- Tax and ShipCost Problem (Mike Heininger 1997)
- THANKS!!! Re: ShipCosts.db and debugging (Dale Stokdyk 1997)
- Re: ShipCosts database (Grant Hulbert 1997)
- Re: ShipCosts database (Dale Stokdyk 1997)
- 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)
- Re: unitshipcost vs shipcosts (Grant Hulbert 1997)
- unitshipcost vs shipcosts (Kevin Furuta 1997)
- Re: still having shipCost.db Problem (Richard Wylie 1997)
- Re: still having shipCost.db Problem (Grant Hulbert 1997)
- still having shipCost.db Problem (Richard Wylie 1997)
- Re: Shipcost lookup? (Kenneth Grome 1997)
- Shipcost lookup? (Richard Wylie 1997)
- Re: Further tests with the infamous shipCost (Sven U. Grenander 1997)
- Further tests with the infamous shipCost (w curt eggemeyer 1997)
- Further on formula.db failure to calculate shipCost (w curt eggemeyer 1997)
|
As I put my book away, wiping my brow in a sweat of confusion, Icongradulate you!!RayAt 03:02 PM 11/25/97 -0000, you wrote:>ohmygod, I think it works. I put the formatted shipcost in the lookup >and I am in fact getting the right numbers. Here is my solution.>>[lookup db=ship.db&lookInField=subtot&value=[format >.0f][subtotal][/format]&returnField=shipping¬Found=over$500, please >call]>>Thank you so much for all you help Grant and Ray and Ken and everyone. >YEA!!!>>Janna>>>I believe he was refering to the [format .0f] to round your prices. such as>>[format .0f][shipping][/format] should show 1.00, if that's what's found,>>go ahead and take the f out of your database. This might solve your problem.>>>>What your trying to match (i believe) is the subtotal of the purchase, to a>>dollar amount in your shipping database, to return the proper cost of>>shipping for that ammount. When your search looks at that database trying>>to compare 10.00 and sees 10.00f it doesn't consider that a match. So by>>taking the f out, it should. =) >>>>Ray>>>>>>>>At 12:20 PM 11/25/97 -0000, you wrote:>>>Good question. Here was Grant's reason: To simplify this, you could >>>round off to the nearest dollar with [format .0f] and then your database >>>would only have whole dollars in it. That has the advantage that it's >>>very easy to update your shipping tables (I know it's really hard to read >>>those formulas, so a table would be nice).>>>>>>Janna>>>>>>>I'm curious what the { f } is for in your actual database, why not just1.0?>>>>>>>>Ray>>>>>>>>At 11:45 AM 11/25/97 -0000, you wrote:>>>>>BTW: I also tried it with the math formula instead of the [subtotal]:>>>>>[format .2f][math show=f]sub=0[/math]
[lineitems][math >>>>>show=F]sub=sub+[quantity]*[price][/math][/lineitems]
[math]sub[/math][/forma>>>>>t]>>>>>>>>>> and in my lookup formula used
[math]:>>>>>[lookup >>>>>db=ship.db&lookInField=subtot&value=
[math]&returnField=shipping¬Found=ov>>>>>er$500, please call]>>>>>>>>>> but then I just get a blank response.>>>>>>>>>>Janna>>>>>>>>>>>>>>>>OK, so I have made a database and use the following formula asinstead of >>>>>>[shipcost] in my Invoice.tmpl (I tried using it in the formula.db,but it >>>>>>didn't work, but that is fine 'cause now it is working in the Invoice >>>>>>page).>>>>>>>>>>>>$[lookup >>>>>>db=ship.db&lookInField=subtot&value=[subtotal]&returnField=shipping¬F>>oun>>>>>>d=over$500, please call]>>>>>>>>>>>>My ship.db looks like this:>>>>>>subtot shipping>>>>>>1.0f 1>>>>>>2.0f 1>>>>>>3.0f 1>>>>>>4.0f 1>>>>>>5.0f 1>>>>>>6.0f 1>>>>>>7.0f 1>>>>>>8.0f 1>>>>>>9.0f 1>>>>>>10.0f 1>>>>>>>>>>>>and so until 500>>>>>>>>>>>>But my shipping keeps getting returned as over$500, please call. Why >>>>>>can't the formula find the subtotal? Did I use the .0f incorrectly?>>>>>>>>>>>>Janna>>>>>>>>>>>>>>>>>>>>>>>>Oh. I get it. I think you are right about using the lookup table. I >>>>>>will try it.>>>>>>>>>>>>Thank you,>>>>>>Janna>>>>>>>>>>>>First off, I think you're better off using a database table lookup>>>>because >>>>>>you have so many ranges that it causes the shipCost formula to bloat. >>>>>>Tables are a nice way to simplify these kinds of calculations, and they >>>>>>are not a 'waste' of databases.>>>>>>>>>>>>But, using your current technique, you would use
[math] to 'remember' a >>>>>>numeric value for later use, and stick that math equation at the>>>>beginning >>>>>>of your shipcost formula. The math context remembers all its variable >>>>>>names for the duration of the page.>>>>>>>>>>>>[math show=f]sub=all the stuff to calc the subtotal[/math][showif >>>>>>
[math]sub[/math]<20.00]...[/showif]>>>>>>>>>>>>Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of>>Us >>>>>====>>>>>>Pacific Coast Software | WebCatalog, WebMerchant,>>>>>>11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,>>>>>>San Diego, CA 92128 | Typhoon>>>>>>619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>******************************>>>>>>Janna S. Kohen>>>>>>Big Mind Media L. L. C.>>>>>>http://www.bigmindmedia.com/>>>>>>janna@bigmindmedia.com >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Raymond Hatch
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:
IE Cache Problems... (1999)
[WebDNA] maybe silly suggestion? [founditems] (2015)
wild question (1998)
[WebDNA] version 7.1 on ubuntu apache2 virtual host config (2014)
Flushdatabases - WCAT4 not functioning (2000)
Tax on shipping (1998)
Re:Running 2 two WebCatalog.acgi's (1996)
New servers and new inline cache (1997)
WebDNA module - Automated database archiving (1997)
shipcost (1997)
[shippingtotal] & Formulas.db prob (2003)
Multiple prices (1997)
Interfacing WebMerchant to www.fedex.com (1997)
catagories (1997)
[WebDNA] WebDNA-folder-Mac-FastCGI-8.5.1.zip (404 error) (2018)
WebCat consulting $ (1998)
PCS Frames (1997)
t or f (1997)
send mail problem? (1997)
db (2003)