The moose likes JDBC and Relational Databases and the fly likes problem in request.getparameter Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "problem in request.getparameter" Watch "problem in request.getparameter" New topic

problem in request.getparameter

priya pratheepp
Ranch Hand

Joined: Apr 02, 2008
Posts: 59
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

in second page

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'

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

Joined: Oct 14, 2005
Posts: 19973

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
Ranch Hand

Joined: Apr 02, 2008
Posts: 59
HI Paul

thank you

problem is solved

I agree. Here's the link:
subject: problem in request.getparameter
It's not a secret anymore!