[TYPO3-shop] No tax outside of country

[Simon Browning]

Simon Browning wrote:
> Franz Holzinger wrote:
>> Hello Simon,
>>
>>> I'm trying to set it so that no tax is charged outside of Canada, I've
>>> evidentally got something wrong with the below though, when I add in the
>>> 10.where line, I get a mysql error on the website (mysql_fetch_assoc():
>>> supplied argument is not a valid MySQL result resource in
>>> /home/allergy/typo3_src-4.1.5/t3lib/class.t3lib_db.php on line 796), and
>>>  the cart pops up a "you have not entered your country" message.
>>
>> And which SQL statement is shown in error_log?
>>
>>> I'm using the useStaticInfoCountry=1 and have the country dropdowns,
>>> they seem to work find unless I add the 10.where line.
>>>
>>>   shipping {
>>>       10.title = Standard Shipping
>>>       10.where.static_countries = cn_short_local != 'Canada'
>>
>>> Where have I erred? Also, will this kill all tax outside Canada, or just
>>> the tax on shipping?  If shipping,  do I need to then do similar under
>>> payment?
>>
>> It must be like this at the moment (tt_products 2.6.0-2.8.0):
>>
>>     10.title = Shipping ###STATICCOUNTRIES_CN_OFFICIAL_NAME_EN###
>>     10.where.static_countries = cn_short_local != 'Canada'
>>     10.replaceTAXpercentage = 0
>>     10.price.type = price
>>     10.price.0 = 10
>>     10.price.200 = 16
>>     10.price.400 = 22
>>
>>
>> The title field must contain a STATICCOUNTRY marker. Otherwise the where
>> condition will not be taken into account.
>>
>> - Franz
>>
> 
> 
> Hmm, somethings not right with that I think (on 2.6 now).  It gives me a 
> massive country list, and Canada isn't in the list.  The list is out of 
> alpha order too.
> 
> If I comment out the where line, Canada shows up in the list.
> 
> Simon
.... actually, thats not quite right.  If I comment out the where line, 
I get the marker showing up in the shipping select box.