Re: JDBC and ODBC driver problems querying mysql from OOo

Alex Thurgood wrote:
> Well here I am again, with more problems querying a mysql server from OOo.
>
> Problem 1
> I have the following query :
>
> select File_num, Ctry_short, Filing_num, Filing_Date1, MONTHNAME(Filing_Date1) as 'Mois_Ann', TRUNCATE(DATEDIFF(CURRENT_DATE,Filing_Date1)/365, 0) as 'Quantième', Client_Copy, Owner1, Ann_Fees1 as 'Délai Annuité', pay_ann_fee as 'Gestion Annuités', Comments, Summary from oldfmpro where Ctry_Short = 'FR' and pay_ann_fee = 'Y' and MONTH(Filing_Date1) = 12 ORDER BY Filing_Date1
>
>  
Hi Alex

Opened a new issue for the MySQL datediff syntax:
http://qa.openoffice.org/issues/show_bug.cgi?id=103425

I set it for the Native Connector sub_component as that was what I had
running when I read your email mail..if you want to update it for JDBC /
ODBC also.

Drew

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...