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: [email protected]
For additional commands, e-mail: [email protected]
