What value is being returned by the getParameter call? If you do a System.out.println(request.getParameter("selection")), I have a feeling that it will be a value that does not convert directly to an int.

OCJP6, OCWCD5

Ron Ingram
Ranch Hand

Joined: Mar 11, 2011
Posts: 73

posted Jun 14, 2011 13:45:33

0

returns 1 for parameter call "selection".

line 68 returns "test" which is def not a number. Got to figure this out where the problem lies. The database is correct for that field though

I don't think this is the problem causing your issue but you may wish to update your query to not use select * or using positional index to retrieve values from a ResultSet. I have seen way too many maintenance issues come out of this practice.

Ron Ingram
Ranch Hand

Joined: Mar 11, 2011
Posts: 73

posted Jun 14, 2011 14:03:34

0

Thanks Mike for your time

I just figured it out. It had the positional index numbers off trying to retrieve the values from the resultset. I'll go back and cleanup the query and use column names vs index.