Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem in request.getparameter

 
priya pratheepp
Ranch Hand
Posts: 59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 21312
32
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
HI Paul

thank you

problem is solved

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic