[TYPO3-shop] No tax outside of country

[Franz Holzinger]

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