It is essential that your database allows nulls for values not being
updated.Also your insert statement must include the field names in which you
are inserting values:
inser into test(name,score) values(?,?)
Piyush Nigam
-----Original Message-----
From: Synu Jacob Vengal [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 08, 2000 10:33 AM
To: [EMAIL PROTECTED]
Subject: prepared statement problem
> > Hi,
> > I am using a prepared statement to insert values into the database
> fields.
> > Is it always necessary that we should insert data in all the fields or
> else null values??
> > for eg. i gave the sql as
> > sql ="INSERT INTO test VALUES(?,?)";
> > when the actual table contained 3 fields.
> > When i skipped one field it shows the following error
> > java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid argument
> value
> > Pls give me a solution.
> > Thanks ,
> > SJ
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
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".
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
