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:
read and write you own cookies with webcat (1997)
[TaxableTotal] - not working with AOL and IE (1997)
[WebDNA] Need to convert unix date? (2009)
MS Access (1999)
[WebDNA] TCPDoh (2009)
[isfile] ? (1997)
[shipCost] math formula? (1997)
Return records from another (1997)
Re[3]: 2nd WebCatalog2 Feature Request (1996)
New Command prefs ... (1997)
[WebDNA] Will Q2/2010 be the best quarter for WebDNA? (2010)
Odd request (2003)
TCPConnect misbehavin' for me. (2000)
Calendar (1997)
Can WC remember people? (1998)
Execute Applescript (1997)
Multiple cart additions (1997)
Reversed words (1997)
Loosing Quantity (2000)
[TaxableTotal] - not working with AOL and IE (1997)