View Full Version : Update problem

06-02-2009, 07:15 PM
I m using dreamweavermx 2004 v-7. with tomcat.I have successfully created a search/result page as instructed in "using dreamweaver" help.
My result page displays the result well.Now I want to link it to an update page for updating that data.I tried as instructed in "Opening the update page and passing the record ID".Going to detail page from server behavior window I added the following things-
Detail page- update.jsp
Pass URL parametr- FIRST_NAME
Recordset- rs_update
URL Parameter- checked
When I run the link from result page it says-

HTTP Status 500 -
org.apache.jasper.JasperException: An exception occurred processing JSP page /result.jsp at line 111

108: %>
109: </table>
110: <br>
111: <A HREF="update.jsp?<%= MM_keepURL + ((MM_keepURL!="")?"&":"") + "FIRST_NAME=" + (((rs_search_data = rs_search.getObject("FIRST_NAME"))==null || rs_search.wasNull())?"":rs_search_data) %>">Detail</A>
112: </body>
113: </html>
114: <%
org.apache.jasper.servlet.JspServletWrapper.handle JspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.servic e(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFil e(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspSe rvlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet .java:717)

root cause

javax.servlet.ServletException: java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state