mysql error: [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 'SELECT COUNT (*) FROM Machine WHERE ((OS_NAME like '%XP%') AND (OS_NAME like '%W' at line 2] in EXECUTE(
"SELECT GROUP_CONCAT(DISTINCT IF(LABEL.NAME NOT LIKE 'HDN_LABEL_%', LABEL.NAME, NULL) SEPARATOR '\n') AS LABEL_NAME, OS_NAME, USER_LOGGED  FROM MACHINE  LEFT JOIN MACHINE_LABEL_JT ON (MACHINE_LABEL_JT.MACHINE_ID = MACHINE.ID)  LEFT JOIN LABEL ON (LABEL.ID = MACHINE_LABEL_JT.LABEL_ID) WHERE ((OS_NAME like '%XP%') AND (OS_NAME like '%Windows%'))  GROUP BY MACHINE.ID ORDER BY LABEL_NAME, OS_NAME, USER_LOGGED,
SELECT COUNT (*) FROM Machine WHERE ((OS_NAME like '%XP%') AND (OS_NAME like '%Windows%')) GROUP BY TOTAL RESULT LIMIT 0")

0 Comments   [ + ] Show Comments

Comments

Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity