Tax Rates

[gm_dan]

i was formatting the tax rates, tried to delete the default florida tax rate and got this msg:

 

Tax Rates

 

Priority Tax Class Zone Tax Rate Action

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 '-20, 20' at line 1

 

select r.tax_rates_id, z.geo_zone_id, z.geo_zone_name, tc.tax_class_title, tc.tax_class_id, r.tax_priority, r.tax_rate, r.tax_description, r.date_added, r.last_modified from tax_class tc, tax_rates r left join geo_zones z on r.tax_zone_id = z.geo_zone_id where r.tax_class_id = tc.tax_class_id limit -20, 20

 

 

how do i fix this as now i can't make any changes to the tax rates?

thanks

[Guest]

you must be using php5, search the tips/tricks forum for 20, 20