Re: servlet & JDBC

[Vyas Vemu]

There is syntax error in your code. You forgot the single quotes around the data field info1. Wrap it this way: The semi colon is really not necessary for odbc connection.

ResultSet rs ............... WHERE ename= ' " + info1 + " ' ");
 

Vyas

mahesh wrote:

 HiI am getting runtime error while executing an sql query using variable name with WHERE clause. But if i am using some  value instead of var name it is working and fetching data from database.here is the code.ResultSet rs = stmt.executeQuery ("SELECT * FROM sample1 WHERE ename = 'mahesh' ");this is working butResultSet rs = stmt.executeQuery ("SELECT * FROM sample1 WHERE ename = "+ info1 +";");it is giving java131 runtime error. where info1 = request.getParameter("acct"); acct is the name of the text field. please point out the fault in it...thanks in advanceregardsMahesh