aspose file tools*
The moose likes JDBC 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 Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "problem in request.getparameter" Watch "problem in request.getparameter" New topic
Author

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'

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

Joined: Oct 14, 2005
Posts: 18666
    
    8

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

 
Consider Paul's rocket mass heater.
 
subject: problem in request.getparameter