Re: Repost: Orderfile, Grandtotal: How do I get it to all add up.
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 31734
interpreted = N
texte = Yep. taxRate is coming back 6.0. I read the archive and this one and am still stuck. products.db shows all items with taxable as T, the taxRate is returning as 6.0. I suspect my db. But I've now checked four or five times? I'm going nuts.What should the exact field name be? Does case matter? Incedentally, is there a definitive source on capitalization for WebCatalog? Or does it not matter at all? WebDNA Support wrote: > > >Yep. All my items are marked taxable, T. The field is called > >taxable and the case the field data is capital T or F. > > > >Triple checked products.db. > > And your taxRate is something other than 0.0? > > The grandtotal is computed automatically using the standard business > formula, basically shipCost + nonTaxableTotal + taxableTotal*taxRate > + taxableTotal. If all of your subtotals are correct, the grandtotal > will reflect all of those. Why not dump out all of the various > subtotal variables on a page and see what they look like? > > Technical Support ********************************** > Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) > 16855 West Bernardo Drive, #380 | ------------------------- > San Diego, CA 92127 | Software & Site Development > WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com > Fax: (858) 675-0372 ********************************** > > ------------------------------------------------------------- > 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://search.smithmicro.com/------------------------------------------------------------- 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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Yep. taxRate is coming back 6.0. I read the archive and this one and am still stuck. products.db shows all items with taxable as T, the taxRate is returning as 6.0. I suspect my db. But I've now checked four or five times? I'm going nuts.What should the exact field name be? Does case matter? Incedentally, is there a definitive source on capitalization for WebCatalog? Or does it not matter at all? WebDNA Support wrote: > > >Yep. All my items are marked taxable, T. The field is called > >taxable and the case the field data is capital T or F. > > > >Triple checked products.db. > > And your taxRate is something other than 0.0? > > The grandtotal is computed automatically using the standard business > formula, basically shipCost + nonTaxableTotal + taxableTotal*taxRate > + taxableTotal. If all of your subtotals are correct, the grandtotal > will reflect all of those. Why not dump out all of the various > subtotal variables on a page and see what they look like? > > Technical Support ********************************** > Smith Micro, Internet Solutions Div | eCommerce (WebCatalog) > 16855 West Bernardo Drive, #380 | ------------------------- > San Diego, CA 92127 | Software & Site Development > WebCatalog Support: (858) 675-0632 | http://www.smithmicro.com > Fax: (858) 675-0372 ********************************** > > ------------------------------------------------------------- > 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://search.smithmicro.com/------------------------------------------------------------- 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://search.smithmicro.com/
Bob McPeak
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:
WebCatalog NT beta 18 now available (1997)
Was 5.0 Pricing, now Sandbox versus Website and ruminating (2003)
no [include]s with encryption? (1998)
PIXO support (1997)
Apache processes (2003)
UPPERCASE (1997)
[LOOKUP] (1997)
Using [purchase] (1998)
test (2002)
RE: E-mailer error codes (1997)
still having shipCost.db Problem (1997)
tcpconnect/tcpsend frustrations (2002)
Size limit for tmpl editor ? (1997)
WebCatalog can't find database (1997)
Template Not Found (1998)
Store Builder, technical infos (1998)
Tab Charactor (1997)
3.0 [TEXT] variables (1998)
Navigator 4.01 (1997)
Hiding URL ? (1998)