u can use something like this
sql ="INSERT INTO test (fieldname1,fieldname2) VALUES(?,?)";
i.e. give the names of the fields for which u r entering the data!
:-)
Have a great Day!
-Ginni
-----Original Message-----
From: Synu Jacob Vengal <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, November 08, 2000 10:52 AM
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
