ERROR: String literal not properly closed by a double quote

[katikatii]

this is a query which works in mysql but does not work in the jsp

SELECT (@rownum:=@rownum+1) AS pos, fname,lastname,othername,clas,(( tblbot.mtc+tblmot.mtc+tbleot.mtc)/3+ 
(tblbot.eng+tblmot.eng+tbleot.eng)/3 + (tblbot.che+tblmot.che+tbleot.che)/3+
(tblbot.bio+tblmot.bio+tbleot.bio)/3 + (tblbot.phy+tblmot.phy+tbleot.phy)/3+ 
(tblbot.agr+tblmot.agr+tbleot.agr)/3+(tblbot.his+tblmot.his+tbleot.his)/3+ 
(tblbot.fat+tblmot.fat+tbleot.fat)/3+( tblbot.geo+tblmot.geo+tbleot.geo )/3+ 
(tblbot.cre+tblmot.cre+tbleot.cre)/3+ (tblbot.kis+tblmot.kis+tbleot.kis)/3+ 
(tblbot.fre+tblmot.fre+tbleot.fre )/3+(tblbot.lug+tblmot.lug+tbleot.lug )/3+ 
(tblbot.ent+tblmot.ent+tbleot.ent)/3+ (tblbot.com+tblmot.com+tbleot.com)/3 ) AS tot  
FROM tblemp_dtai LEFT JOIN tblbot ON tblbot.employee_id  LEFT JOIN tblmot ON
 tblmot.employee_id LEFT JOIN tbleot ON tbleot.employee_id, (SELECT @rownum:=0) r WHERE 
 tblemp_dtai.employee_id = tblbot.employee_id AND 
 tblemp_dtai.employee_id = tblmot.employee_id AND 
 tblemp_dtai.employee_id = tbleot.employee_id AND clas = 'S.1' ORDER BY tot DESC;

i am new to this sit i have a problem, my query works in mysql but fails in the jsp file reporting an error; String literal not properly clsoed by a double help

regards
Thanks in advance

[r035198x]

Most likely you haven't enclosed your SQL in the " quotes properly.

1.) Separate your Java code from your HTML by using a separate Java class to execute the SQL rather than the JSP.
2.) Use a PreparedStatement for the building the query.