[TYPO3-shop] No tax outside of country

[Simon Browning]

Franz Holzinger wrote:
> Hello Simon,
> 
>>     20.title = Shipping ###STATICCOUNTRIES_CN_OFFICIAL_NAME_EN###
>>     20.where.static_countries = cn_short_local == 'Canada'
>>     ...
>>
>> I get an sql error (debug output pasted below).  The server is running
>> mysql server 4.1.22 if that is of use.
>>
>> If I use
>>
>>    20.where.static_countries = cn_short_local = 'Canada'
>>
>> ERROR    You have an error in your SQL syntax; check the manual that
>> corresponds to your MySQL server version for the right syntax to use
>> near '== 'Canada'' at line 4
>>
>> lastBuiltQuery    SELECT static_countries.uid uid,static_countries.pid
>> pid,static_countries.cn_official_name_en cn_official_name_en
>> FROM static_countries static_countries
>> WHERE
>> 1=1 AND static_countries.cn_short_local == 'Canada'
>>
> 
> This is wrong SQL syntax to use == symbol. = must be used here.
> 
> - Franz

Hi Franz.

With = the shipping dropdown contains all of the options (10 & 20 
below), but the delivery & address country dropdowns only have the first 
item, so in this case, just Canada.


     10.title = Shipping ###STATICCOUNTRIES_CN_OFFICIAL_NAME_EN###
     10.where.static_countries = cn_short_local = 'Canada'
     ...


     20.title = Shipping ###STATICCOUNTRIES_CN_OFFICIAL_NAME_EN###
     20.where.static_countries = cn_short_local != 'Canada'
     ...

Where am I going wrong?

Thank you

Simon