This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
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: 18541

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
Similar Threads
Sending Email from jsp page
reading data from jsp page to another jsp page using request.getParameter
Problem in inserting data into access database through jsp file
calling a java Script file into the Jsp
How to store option format value in database in jsp