Member Avatar for coervivekmca 
st.executeUpdate("update submittable set status='yes' WHERE compid='"+<%=request.getParameter("id")%>+"'");

can u rectify it ..i am having problem to solve it its urgent

  • 2 Contributors
  • 1 Reply
  • 60 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by masijade
Member Avatar for masijade

Is this a jsp or a servlet, as you are using jsp scriptlet tags, but seemingly inside another scriplet block, or inside a servlet. Neither of which, of course, works. If a servlet, use PreparedStatement and its setWhatever method with that getParameter call (transforming it to the proper type, of course). If a JSP (and you insist on doing this sort of action in a JSP, whic I know you will then, they always do) then use the JSTL sql tag package and its implementation PreparedStatement. BTW, a scriptlet to retreive a request property is not necessary in a JSP

${param.id}

(param is "hard-coded" and the part after the "." is the parameter name, of course)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.