loghova Posted March 8, 2007 Posted March 8, 2007 I am attempting to set up osCommerce to only charge sales tax to in state residents. I do not wish to have it charge sales tax to customers out of state. Is this poosible and how is it done?
loghova Posted March 8, 2007 Author Posted March 8, 2007 After searching the forum for possible solutions my Tax Rates table is screwed. This is the error I recieve after clicking 'Tax Rates' in the Admin Panel. 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 Any assistance would be appreciated.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.