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
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: 18138
    
    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

 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: problem in request.getparameter
 
Similar Threads
Problem in inserting data into access database through jsp file
calling a java Script file into the Jsp
reading data from jsp page to another jsp page using request.getParameter
Sending Email from jsp page
How to store option format value in database in jsp