MySQL error

[Sree Jag]

Hi all,

The query is "SELECT * FROM tblPages t WHERE t.SiteID=1000 AND t.DisplayModule = 'on' and t.Deleted = 'N' order by t.navorder"

When i execute the above query using JDBC i get the following Exception:

java.sql.SQLException: Syntax error or access violation, message from server: "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 'BY t.navorder' at line 1"


but when i execute the same query at the command prompt it works without any problem.

I am using MySQL 4.1 database

Please help,
Seshu

[Ali Gohar]

use PreparedStatement to do that. like

String qry = "SELECT * FROM tblPages WHERE SiteID=? AND DisplayModule = ? and Deleted = ? order by navorder"

PreparedStatement pstmt = con.prepareStatement(qry);
pstmt.setInt(1,1000);
pstmt.setString(2,"on");
pstmt.setString(3,"No");
Resultset rs = pstmt.executeQuery();

[Sree Jag]

I tried that,
the same error comes up

what could be the problem?

seshu