Re: null value in date field

Thanks to everyone who helped. I was using prepared statements with
java.sql.
I was using the setString() method to set the value to null, when I
needed to be using the setNull() method. It created the null values
that I needed.

Jeff
On Tuesday, February 18, 2003, at 07:25 PM, Josh Berkus wrote:

> Jeff,
>
>> I have a form that contains optional DATE fields. To enter null
>> values, I've tried null, 'null', '', '-', '0', 0, and each time I get
>> one of the following errors:
>
> NULL is correct, no quotes. Please post the actual insert statement
> you are sending; likely the problem is elsewhere.
>
> -Josh