Need littlebit help with SQL

[Guest]

Hi,

 

www.satnor.no/catalog

 

I have done this:

 

1. Instaled a new copy og OSC 2.2

2. Norwegian language added

3. Installed the contribution "Servicepakke" as a shipping module in Norway.

http://www.oscommerce.com/community/contributions,520

 

5. I get this error if a person wants to checkout_shipping:

 

1064 - 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 '>=fra_nr and <=til_nr' at line 1

 

select * from posten_postnr where >=fra_nr and <=til_nr

 

[TEP STOP]

 

Posten_Postnr (Postnr = Is Zip code)(Posten = Postoffice in Norway).

 

Anyone to elp me out of this ? Maybe a minor problem, but i am not good with SQL.

 

Thanks :)

[♥Vger]

Did you add the Norwegian Zones (Counties/States) along with the contribution?

 

Vger

[Guest]

Ok, havent done that. I`ll try to find the zones and insert them into the sql first :-)

 

Thanks so far

 

 

Did you add the Norwegian Zones (Counties/States) along with the contribution?

 

Vger