• 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: 21972
36
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

 
The knights of nee want a shrubbery. And a tiny ad:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!