Hi
I 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 but
ResultSet 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 advance
regards
Mahesh
