Hi,
vielleicht schaue ich ja einfach schon zu lange drauf, aber ich bekomme den Fehler
ERROR 1064 (42000): 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 'WHERE order_deleted=0' at line 5
bei folgendem Query
Jemand eine Idee?
Gruß
Claus
vielleicht schaue ich ja einfach schon zu lange drauf, aber ich bekomme den Fehler
ERROR 1064 (42000): 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 'WHERE order_deleted=0' at line 5
bei folgendem Query
Code:
SELECT `order_id`, `sp_partnumber` AS order_partnumber, `sp_description` AS `order_name`, `order_count`,`order_jobnumber`,`order_date`, `order_mustnumber`,`order_receiver`, CASE sp_type WHEN 0 THEN 'SR' WHEN 1 THEN 'HT' WHEN 2 THEN 'BT' END AS order_type FROM sp_order LEFT JOIN sp_parts ON (sp_parts.sp_id=order_partid) HAVING (`order_type` LIKE '%a%' OR `order_partnumber` LIKE '%a%' OR `order_name` LIKE '%a%' OR `order_count` LIKE '%a%' OR `order_date` LIKE '%a%' OR `order_jobnumber` LIKE '%a%' OR `order_mustnumber` LIKE '%a%' OR `order_receiver` LIKE '%a%' ) WHERE order_deleted=0
Gruß
Claus
Kommentar