I hope that I'm posting this correctly. I have populated a vector of my resultSet from a query. I tested it on an application side code and am now trying to access a method from my web side jsp.
Here is my error page:
org.apache.jasper.JasperException: Exception in JSP: /searchResults.jsp:32 29: String colChoice = request.getParameter("colChoice"); 30: String tableChoice = request.getParameter("tableChoice"); 31: 32: resultQuery.createSearchQuery(tableChoice, colChoice, searchWord);

Here is my embedded code:

<%
      ConnectDB resultQuery = new ConnectDB();
      Vector tableResults = new Vector();
      Vector row = new Vector();
      
      String searchWord = request.getParameter("searchWord");
      String colChoice = request.getParameter("colChoice");
      String tableChoice = request.getParameter("tableChoice");
      
      resultQuery.createSearchQuery(tableChoice, colChoice, searchWord);
      //tableResults = resultQuery.storeResultSet();
       
      %> 
<table border=2>
<%
        String strData;
        for (int i=0; i<tableResults.size(); i++)
        {
            row = (Vector)tableResults.get (i);
            for (int j=0; j<row.size(); j++)
            {
                strData = (String)row.get (j);
                %><p><%out.print(strData);%></p>
          <%}
        }
    
%>

can anyone help me figure why i can't access my method?

Don't use scriptlets, put that code in a servlet.

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.