On Thu, 18 Oct 2007 01:02:21 -0500, Drew Jensen
<[EMAIL PROTECTED]> 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?
I modify the csv with the correct statements (NULL, NULL.....) as opposed
to just (,,,,,).
--
Alexandro Colorado
CoLeader of OpenOffice.org ES
http://es.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
