0 Replies Latest reply on Oct 1, 2006 6:49 PM by tku62

    How to create dynamic menu/list

    tku62
      Dear All,
      I have a problem linking the dynamic data to the menu/list function.
      I have a simple recordset that contains different size of a product. For example, my recordset contains 3 string data: S, M, L

      I have created the menu/list fucntion using dreamweaver 8, i have click the dynamic button under property.

      I have selected the only menu provided under "Menu:"
      I left "Static Options" blank.
      I selected my only recordset from Binding for "Option from Recordset"
      I selected the field name size under both "values" & "labels"
      Also selection the correct field under "Select Vaule equal to"

      But the page would not compile properly.

      It shows error below:

      exception

      javax.servlet.ServletException: No data found
      org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
      org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
      org.apache.jsp.dmenu_jsp._jspService(dmenu_jsp.java:139)
      org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
      org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
      org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


      root cause

      java.sql.SQLException: No data found
      sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7139)
      sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3908)
      sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java:5699)
      sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:353)
      sun.jdbc.odbc.JdbcOdbcResultSet.getObject(JdbcOdbcResultSet.java:1677)
      sun.jdbc.odbc.JdbcOdbcResultSet.getObject(JdbcOdbcResultSet.java:1742)
      org.apache.jsp.dmenu_jsp._jspService(dmenu_jsp.java:99)
      org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
      org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
      org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
      javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

      Could anyone tell me what the problem is?
      I have test my recordset, and it does work fine, it shows 3 data.

      Thank you.