Page 1 of 1

problem type ratings in VA integration

Posted: Mon Oct 08, 2007 5:46 pm
by vaccaro
Hi,
When I try to manage the type ratings via remote integration
By pilot, I get this error
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'Select ACDB_ID from FlyNET_Aircrafts where Owner = 'Air Mermaid
When I try the other way, on the fleet section the drop down list is empty.

Airline: Air Mermaid [1065]

Cheers,

Posted: Mon Oct 08, 2007 10:42 pm
by oge978
Hi ,

I'm aware the matter (and some others) which are due to a version mismatch between MySQL 4.1 and 4.0 ...

If I can find some really free time I will change the codes .

Technically MySQL 4.0 do not support subqueries , but 4.1 and upper does like MsSQL . To prevent any furthers incomp. I will use more standard codes :)

Thanks for pointing this out and waiting .

Posted: Mon Oct 08, 2007 11:11 pm
by vaccaro
Ah! OK.
Actually not really a problem 'cos we don't have many a/c.
I thought it was only me having the problem.
Teşekk