Discussion :

[management10]

Bonjour,
j'ai un problème qui me bloque depuis 2 jours, pouvez vous m'aider svp c'est urgent!!
Voila le message d'erreur qui m'affiche sous eclipse :

#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 'AS total_price, SUM(PL.pipe_price*(1-((CASE WHEN T.pipe <> 0 THEN ((SUM((1-T.pip' at line 1

==> La requete est la suivante :

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

SELECT CONCAT(T.spec,'@',MT.material) AS lkey, SUM((PL.pipe_price*(1-((CASE WHEN T.pipe <> 0 THEN ((SUM((1-T.pipe)*T.weight)/SUM(T.weight))*100) ELSE ((SUM(((((0.0035*EXP(12*(CASE WHEN (-0.0895*(T.length/(CASE WHEN T.weld > 1 THEN T.weld-1 ELSE 1 END)) + 0.85) < 0 THEN 0 ELSE (-0.0895*(T.length/(CASE WHEN T.weld > 1 THEN T.weld-1 ELSE 1 END)) + 0.85) END))+6)/100)))*T.weight)/SUM(T.weight))*100) END) ) + PL.fitting_price*((CASE WHEN T.pipe <> 0 THEN ((SUM((1-T.pipe)*T.weight)/SUM(T.weight))*100) ELSE ((SUM(((((0.0035*EXP(12*(CASE WHEN (-0.0895*(T.length/(CASE WHEN T.weld > 1 THEN T.weld-1 ELSE 1 END)) + 0.85) < 0 THEN 0 ELSE (-0.0895*(T.length/(CASE WHEN T.weld > 1 THEN T.weld-1 ELSE 1 END)) + 0.85) END))+6)/100)))*T.weight)/SUM(T.weight))*100) END) )*(CASE WHEN T.unit = '1' THEN T.weight*1*1 ELSE T.weight*1 END)) AS total_price, SUM(PL.pipe_price*(1-((CASE WHEN T.pipe <> 0 THEN ((SUM((1-T.pipe)*T.weight)/SUM(T.weight))*100) ELSE ((SUM(((((0.0035*EXP(12*(CASE WHEN (-0.0895*(T.length/(CASE WHEN T.weld > 1 THEN T.weld-1 ELSE 1 END)) + 0.85) < 0 THEN 0 ELSE (-0.0895*(T.length/(CASE WHEN T.weld > 1 THEN T.weld-1 ELSE 1 END)) + 0.85) END))+6)/100)))*T.weight)/SUM(T.weight))*100) END) )*(CASE WHEN T.unit = '1' THEN T.weight*1*1 ELSE T.weight*1 END)) AS pipe_total_price, SUM(PL.fitting_price*((CASE WHEN T.pipe <> 0 THEN ((SUM((1-T.pipe)*T.weight)/SUM(T.weight))*100) ELSE ((SUM(((((0.0035*EXP(12*(CASE WHEN (-0.0895*(T.length/(CASE WHEN T.weld > 1 THEN T.weld-1 ELSE 1 END)) + 0.85) < 0 THEN 0 ELSE (-0.0895*(T.length/(CASE WHEN T.weld > 1 THEN T.weld-1 ELSE 1 END)) + 0.85) END))+6)/100)))*T.weight)/SUM(T.weight))*100) END) )*(CASE WHEN T.unit = '1' THEN T.weight*1*1 ELSE T.weight*1 END)) AS fitting_total_price, FROM line_list T INNER JOIN project_rev PR ON T.idpr = PR.idpr INNER JOIN material MT ON T.material = MT.material INNER JOIN margin M ON (M.data = T.spec) AND (M.block = T.pi_rop) AND (M.trigramme = PR.trigramme) INNER JOIN price_list PL ON MT.price_class = PL.price_class AND PR.ref_price_table = PL.price_table_id INNER JOIN project P ON PR.trigramme = P.trigramme WHERE PR.trigramme='GHN' AND PR.revision = 'ref_A' AND T.pi_rop = 'pi' and PR.idpr=13 GROUP BY T.spec, MT.material

[CinePhil]

Vu la complexité de la requête, je dirais à vue de nez qu'il doit manquer une parenthèse quelque part ou bien il y en a une en trop.

Indente ta requête proprement et il y a des chances que tu trouves ce qui ne va pas.

Bon courage !