File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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

Win a copy of Head First Android this week in the Android forum!
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: 19693

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
jQuery in Action, 3rd edition