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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)