problem in request.getparameter

[priya pratheepp]

I have one table with field

EMP_ID varchar(10) latin1_swedish_ci PRI

I am passing the value of emp_id from one page to another.In the second page using request.getParameter i am receiving the value
first page

 out.println("<td><a href = viewEmp.jsp?id=" + id + " /a>View</td>");

in second page

String tempQuery ="Select * from GSIS_EMP_MASTER where EMP_ID = "+ request.getParameter("id");

Above are working fine if the EMP_ID is integer.If it is not integer like 3sd or 1a... i am getting error of

Exception : java.sql.SQLException: Error during query: Unexpected Exception: java.sql.SQLException message given: Column not found: Unknown column '1a' in 'where clause'

thanks
[ May 14, 2008: Message edited by: priya pratheepp ]

[Paul Clapham]

If you print out your SQL command what do you see? My guess is this:

Select * from GSIS_EMP_MASTER where EMP_ID = 1a

This tells the database that you're comparing the column EMP_ID to the column 1a.

The short fix for that is to put the 1a into quotes. But don't do that. The correct fix is to use a PreparedStatement and call its setString() method.

[priya pratheepp]

HI Paul

thank you

problem is solved