Re: EOF & pgSQL join syntax
Re: EOF & pgSQL join syntax
- Subject: Re: EOF & pgSQL join syntax
- From: Art Isbell <email@hidden>
- Date: Thu, 29 Apr 2004 10:53:49 -1000
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.
Aloha,
Art
[demime 0.98b removed an attachment of type application/pkcs7-signature which had a name of smime.p7s]
_______________________________________________
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.