Re: Tax Troubles
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 53960
interpreted = N
texte = I suppose that's just a way of hard-coding the taxable variable. But what it the item is not taxable (as is the case with some items in my shop). In your products.db you need a TAXABLE field, which is either T or F. Then you have the best of both worlds. Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837 > From: Clint Davis
> Reply-To: (WebDNA Talk) > Date: Tue, 11 Nov 2003 11:42:37 -0600 > To: (WebDNA Talk) > Subject: Re: Tax Troubles > > That did it! > > THANKS! > > > On 11/11/03 10:49 AM, "Donovan Brooke" wrote: > >> Hi Clint, try adding: >> >> TaxableT >> >> to your formulas.db. >> >> >> Clint Davis wrote: >> >>> My store isn't calculating the [taxTotal] variable. >>> >>> I have my formulas.db and taxrates.db in the same directory as all my store >>> files. >>> >>> >>> Formulas.db: >>> ------------ >>> NameFormula >>> Price[price] >>> taxRate[lookup >>> db=taxrates.db&lookinfield=State&value=[State]&returnfield=taxRate¬found= >>> 0.00] >>> >>> >>> TaxRates.db >>> ----------- >>> StatetaxRate >>> IN6.0 >>> >>> >>> My shopping cart shows "IN" for the State and "6.000000" for the taxRate, >>> but the [taxTotal] tag is displaying "0.00" in my invoice page. Anyone see >>> something amiss? >>> >>> >>> --------------------------------------------------------------------- >>> Clint Davis >>> Webmaster / Interactive Media Specialist >>> Gray Loon Marketing Group, Inc. http://www.grayloon.com >>> 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 >>> --------------------------------------------------------------------- >>> >>> >>> ------------------------------------------------------------- >>> 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/ >>> >> > > > --------------------------------------------------------------------- > Clint Davis > Webmaster / Interactive Media Specialist > Gray Loon Marketing Group, Inc. http://www.grayloon.com > 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 > --------------------------------------------------------------------- > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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 suppose that's just a way of hard-coding the taxable variable. But what it the item is not taxable (as is the case with some items in my shop). In your products.db you need a TAXABLE field, which is either T or F. Then you have the best of both worlds. Regards, Tim -- Tim Robinson IDFK Web Developments tim@idfk.com.au 114a/40 Yeo Street Neutral Bay 2089 Australia Phone +612 9908 2134 Fax +612 9908 4837 > From: Clint Davis > Reply-To: (WebDNA Talk) > Date: Tue, 11 Nov 2003 11:42:37 -0600 > To: (WebDNA Talk) > Subject: Re: Tax Troubles > > That did it! > > THANKS! > > > On 11/11/03 10:49 AM, "Donovan Brooke" wrote: > >> Hi Clint, try adding: >> >> TaxableT >> >> to your formulas.db. >> >> >> Clint Davis wrote: >> >>> My store isn't calculating the [taxTotal] variable. >>> >>> I have my formulas.db and taxrates.db in the same directory as all my store >>> files. >>> >>> >>> formulas.db: >>> ------------ >>> NameFormula >>> Price[price] >>> taxRate[lookup >>> db=taxrates.db&lookinfield=State&value=[State]&returnfield=taxRate¬found= >>> 0.00] >>> >>> >>> TaxRates.db >>> ----------- >>> StatetaxRate >>> IN6.0 >>> >>> >>> My shopping cart shows "IN" for the State and "6.000000" for the taxRate, >>> but the [taxTotal] tag is displaying "0.00" in my invoice page. Anyone see >>> something amiss? >>> >>> >>> --------------------------------------------------------------------- >>> Clint Davis >>> Webmaster / Interactive Media Specialist >>> Gray Loon Marketing Group, Inc. http://www.grayloon.com >>> 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 >>> --------------------------------------------------------------------- >>> >>> >>> ------------------------------------------------------------- >>> 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/ >>> >> > > > --------------------------------------------------------------------- > Clint Davis > Webmaster / Interactive Media Specialist > Gray Loon Marketing Group, Inc. http://www.grayloon.com > 204 Main Street | Evansville, IN 47708 | Phone:812-422-9999 > --------------------------------------------------------------------- > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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/
Tim Robinson
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:
Friday night shopping site joke (1997)
[WebDNA] multi hyperlinks in text paragraphs (2014)
Pop-Up Redirects (1998)
Bug? (1997)
[Sum] function? (1997)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
File Upload (1997)
OT-Load balance (2004)
OT - quiet on the list today - here's something (2004)
wild question (1998)
WebCat2: Found Items syntax, etc. (1997)
Caching [include] files ... (1997)
[off] Promotions Co? (1997)
RePost: NAT and the CART (1999)
Bug Report, maybe (1997)
PageMaker/Quark to db (1999)
Username for Admin Group (1997)
triggers.db (1999)
Creating a back button (1999)
form data submission gets truncated (1997)