Re: OpenBase vs MySQL
Re: OpenBase vs MySQL
- Subject: Re: OpenBase vs MySQL
- From: Jacky Gagnon <email@hidden>
- Date: Mon, 11 Apr 2005 12:13:16 -0400
- Resent-date: Mon, 11 Apr 2005 12:14:01 -0400
- Resent-from: Jacky Gagnon <email@hidden>
- Resent-message-id: <email@hidden>
- Resent-to: WebObjects Development <email@hidden>
Hi Erwin,
You must use MySQL 4.1 and later for using subselect request.
Jacky
On 05-04-10, at 13:31, Erwin wrote:
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
_______________________________________________
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