I have encountered this before... the last time i had this problem, i took a
while to debug and realise that it's due to my own stupidity... some of the
columns are missing in your access table... go and double check ur access
table... make sure the field names are correct, observing case
sensitivity...
hope this helps....
zac
<% Visit my HomePage %>
<zac:forward> http://prosurfr.tripod.com </zac:forward>
----- Original Message -----
From: "sufi malak" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, February 23, 2001 2:36 AM
Subject: Too few parameters. Expected 11. ?
> I am sorry I don't know if this is an off topic.
> The employee table has exactly 11 columns, and this is my jsp code :
>
> <%@page language="java" import="java.sql.*"%>
> <%@ include file="Connections/connCompass.jsp" %>
>
> <%
> String photo = (String)request.getParameter("txtImageURL");
> String employee_last= (String)request.getParameter("txtLastName");
> String employee_first = (String)request.getParameter("txtFirstName");
> String employee_id = (String)request.getParameter("txtId");
> String phone = (String)request.getParameter("txtPhone");
> String reward_date = (String)request.getParameter("txtDate");
> String department = (String)request.getParameter("txtDept");
> String employee_extension = (String)request.getParameter("txtExt");
> String email = (String)request.getParameter("txtEmail");
> String nominee_info = (String)request.getParameter("txtNotes");
> String nominated_by = (String)request.getParameter("txtNominatedby");
>
> %>
> <%
> System.out.println("test zero....");
> Driver DriverResults =
> (Driver)Class.forName(MM_connCompass_DRIVER).newInstance();
> Connection ConnResults =
>
DriverManager.getConnection(MM_connCompass_STRING,MM_connCompass_USERNAME,MM
_connCompass_PASSWORD);
> PreparedStatement StatementResults;
> String stmt = "insert into employee VALUES(employee_id, employee_first,
> employee_last, nominated_by, photo, employee_extension, department,
> nominee_info, phone, email, reward_date)";
> StatementResults = ConnResults.prepareStatement(stmt);
> if (!((photo == null) | (employee_last == null) | (employee_first == null)
|
> (employee_id == null) | (phone == null) |
> (department == null) | (reward_date == null) | (employee_extension ==
> null) | (email == null) | (nominee_info == null) | ( nominated_by == null)
> ))
> {
> StatementResults.executeQuery();
> response.sendRedirect("insertok.jsp");
> System.out.println("test one....");
> }
> %>
>
> But when I run it, I got this error,( is this a Microsoft Access error?):
> A Servlet Exception Has Occurred
> Exception Report:
> javax.servlet.ServletException: [Microsoft][ODBC Microsoft Access Driver]
> Too few parameters. Expected 11.
> at
>
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImp
l.java:481)
>
> Thank you so much for your help.
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
