Re: Problem with query comparing to a DATE on Linux OpenOffice

2003-11-11 Thread Marc
On Tue, 2003-11-11 at 00:15, Alaios wrote: what a front-end is? And what OO1.1.0 provides? MySQL is a database server and a front-end is another program that you use to get to that server and use the database. OpenOffice is a complete office software package (word processor, spreadsheet, ...)

Problem with query comparing to a DATE on Linux OpenOffice

2003-11-10 Thread Marc
I'm using OpenOffice 1.1.0 as a front-end to MySQL 4.0.14 on Gentoo Linux and can't compare a field to CURDATE(). The error is, The field cannot be compared with a date. The column is formatted as a DATE, and I can perform the compare fine using mysql. I realize this is probably related only to

Re: Problem with query comparing to a DATE on Linux OpenOffice

2003-11-10 Thread Alaios
what a front-end is? And what OO1.1.0 provides? Marc [EMAIL PROTECTED] wrote:I'm using OpenOffice 1.1.0 as a front-end to MySQL 4.0.14 on Gentoo Linux and can't compare a field to CURDATE(). The error is, The field cannot be compared with a date. The column is formatted as a DATE, and I can