Re: MySQL - PreparedStatement problem

[Jismon Olickal]

i am using MySql data base and java.

i was trying to execute this statement,
showing an error

public List getPersonalities(int intStart, int intResultsToReturn) throws DAOException
{

Connection conn;
PreparedStatement ps;

try{

ps = conn.prepareStatement("select * from PersonalityType LIMIT ?,? ");
ps.setInt(1, intStartIndex - 1);
ps.setInt(2, intNumberToReturn);
rs = ps.executeQuery();*/

}
}

unable to set values.


if i do like
ps = conn.prepareStatement("select * from Personality where active=1 LIMIT "+intStart+"," +intResultsToReturn);

can anybody solve this problem.

no error.