The JSP newbie here again....
I'm passing form values to a page, and want to reference one of the variables in my SELECT statement - that is - instaed of using
ResultSet rs = stmt.executeQuery("SELECT * FROM TABLE_T WHERE ACCT_NO = 123 ");
I want to use a variable for the account number instead of the actual number. I can reference that number by using <%= request.getParameter("custn") %>, but that synatax won't work if I use it in the SELECT statement like so:
ResultSet rs = stmt.executeQuery("SELECT * FROM TABLE_T WHERE ACCT_NO = request.getParameter("custn") ");
I know I'm doing something wrong, but what?
Thx again for the help - I don't know what I would do without this site!