Why donot you use update statement?
Mike
>From: Mutahar Qayum <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: prepared statement problem
>Date: Wed, 8 Nov 2000 13:51:03 -0800
>
>Actually you can even specify what columns you are inserting.
>like.
>sql ="INSERT INTO test(userid,username) VALUES(?,?)";
>
>regards
>-----Original Message-----
>From: Synu Jacob Vengal [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, November 07, 2000 9:03 PM
>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
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
===========================================================================
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
