It can also be an error specific to Your jdbc-driver.
Contact your drivervendor or try with another driver.
Sorry about my grmmatics today. hangover :(
At 08:20 01/25/01, you wrote:
>I think it's because you cannot set a null value to a DATE field.
>
>:^)
>Ricky Y. Artigas
>Analyst/Programmer
>Information Technology Division
>Easycall Communications Phils., Inc.
>418 Arayat St., Mandaluyong City 1550, Philippines
>Personal WAP Site: http://www.buzzed.co.uk/mobile/?rya
>Company Website: http://www.easycall.com.ph
>Tel.no: (+632) 5338001 ext.6574
>Mobile:(+63) 0917-8951783
>Pager: 141-002955
>Email: [EMAIL PROTECTED]
>
>
>> -------------------------------
>> IMPORTANT NOTICE:
>
>> This message (and any attachment hereto) may contain privileged and/or
>> confidential information specific to EasyCall. If you are not the intended
>> addressee indicated in this message, you may not copy or disseminate this
>> message (or any attachment hereto) to anyone. Instead, please destroy this
>> message (and any attachment hereto), and kindly notify the sender by reply
>> email. Any information in this message (and any attachment thereto) that
>> do not relate to the official business of EasyCall shall be understood as
>> neither given nor endorsed by the company.
>>
>>
>> -----Original Message-----
>> From: Kishor K [SMTP:[EMAIL PROTECTED]]
>> Sent: Thursday, January 25, 2001 2:45 PM
>> To: [EMAIL PROTECTED]
>> Subject: setNull function of the preparedstatement
>>
>> hi,
>>
>> When i tried to use the setNull function of the preparedstatement
>> class to set a Date/Time field in msaccess database as null i got the
>> following error.
>> can anyone help.
>>
>> so.setNull(++j, java.sql.Types.DATE);
>>
>> error- SQL data type out of range
>>
>>
>> thanx in advance
>> kishor
>>
>> ------=_NextPart_000_0011
>>
>>
>> _________________________________________________________
>> Do You Yahoo!?
>> Get your free @yahoo.com address at http://mail.yahoo.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
===========================================================================
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
