OpenBase vs MySQL
OpenBase vs MySQL
- Subject: OpenBase vs MySQL
- From: Erwin <email@hidden>
- Date: Sun, 10 Apr 2005 19:31:15 +0200
I know it's not a generic WO Question, but ... I am sure some MySQL expert will have the answer (origin WODev Guide Ravi..)
I have the following fetch in my EOModel , it's running fine with OpenBase but it's seems to be wrong with MySQL 4
-------
<x-tad-bigger>SELECT FORUM_ID, NAME,
(SELECT COUNT(*) FROM POST, TOPIC WHERE POST.TOPIC_ID = TOPIC.TOPIC_ID AND TOPIC.FORUM_ID = FORUM.FORUM_ID),
(SELECT COUNT(*) FROM TOPIC WHERE TOPIC.FORUM_ID = FORUM.FORUM_ID)
FROM FORUM
------
</x-tad-bigger>the <x-tad-bigger>SELECT FORUM_ID, NAME FROM FORUM</x-tad-bigger> alone runs well...
the <x-tad-bigger>SELECT COUNT(*) FROM POST, TOPIC, FORUM WHERE POST.TOPIC_ID = TOPIC.TOPIC_ID AND TOPIC.FORUM_ID = FORUM.FORUM_ID</x-tad-bigger> alone runs well...
the SELECT COUNT( * ) FROM TOPIC, FORUM WHERE TOPIC.FORUM_ID = FORUM.FORUM_ID alone runs well...
but all together they generate a syntax error :
<x-tad-smaller>#1064 - 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 COUNT( * )
FROM POST, TOPIC
WHERE POST.TOPIC_ID = TOP</x-tad-smaller> _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden