Jonathon Coombes wrote:
On 18/10/2007, at 4:02 PM, Drew Jensen wrote:
Alexandro Colorado wrote:
On Thu, 18 Oct 2007 00:13:03 -0500, Drew Jensen
<[EMAIL PROTECTED]> wrote:
Alexandro Colorado wrote:
So I have a bunch of fields on a MySQL table that has a NULL value
on the date-type fields.
However when I open the table on Base I get an error saying:
""
Value '0000-00-00' can not be represented as java.sql.Date
""
I change the mask from MM/DD/YYYY into YYYY-MM-DD which is the
MySQL format but still got the same error.
Hmm, I just fired up 2.3 stable, against MySQl 5.0.11 and don't
have any problems with NULL date fields at all. For date controls
and pattern controls with edit masks, bot strict and not. I am non
XP at the moment however, I might give it a try under Ubuntu also,
but would need to update to 2.3 on that PC.
Sorry, I got it solved form the #mysql guys at freenode. Thanks.
Great what did you have to do?
JDBC does not allow zero dates in the protocol as in MySQL zero dates.
There is however a flag for JDBC to bypass this rule and allow it,
although it does break the JDBC protocol I believe.
But it sounded like he was getting the error for null fields. I was
being to literal, he meant zero dates I suppose.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
