Re: EOF & pgSQL join syntax
Re: EOF & pgSQL join syntax
- Subject: Re: EOF & pgSQL join syntax
- From: Arturo Pérez <email@hidden>
- Date: Thu, 29 Apr 2004 20:46:48 -0400
On Apr 29, 2004, at 4:53 PM, Art Isbell wrote:
On Apr 29, 2004, at 4:13 AM, Arturo Pirez wrote:
The problem I'm having is that the syntax generated by EOF is
"SELECT <blah,blah> FROM x t0, y T3, z T2, w T1 WHERE T3.P1 = ? AND
T2.S = T3.S AND t0.P = T2.P AND t0.R *=* T1.R" withBindings:
1:"joey"(p1)>:
That *=* does not compute with PostgreSQL. Left outer generates *=
and right outer generates =*. How do I get EOF to generate SQL92
compliant join syntax; i.e. LEFT OUTER JOIN table1?
I suspect that that's the responsibility of the PostgreSQL WO plugin.
If you have the plugin source, look in the JDBCExpression subclass.
There are several methods that build a join clause. Looks like the
operator being used is incorrect.
Thanks, Art. I was beginning to think my plea fell on deaf mailing
lists :-)
In any case, I found a Radar for MySQL with the exact same issue in the
5.2 release notes. There was no fix and no workaround. With this
added information, do you still think I can fix it in the plugin?
----
WO in philadelphia - wanna cheesesteak with that?
Please visit webobjects.meetup.com.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.