Re: Simple Query Issues (Improved Grammer)
Re: Simple Query Issues (Improved Grammer)
- Subject: Re: Simple Query Issues (Improved Grammer)
- From: Art Isbell <email@hidden>
- Date: Sun, 30 Mar 2003 17:22:32 -1000
On Sunday, March 30, 2003, at 08:54 AM, Brian Allen wrote:
I have not been able to determine how to do some basic queries within
WebObjects that can be easily done using SQL.
For example, two tables A and B with a number of columns.
SELECT A.item1, A.item2, A.item3 FROM A,B WHERE A.item1 <> B.item1
The query should return all of the records within table A that did not
have
any matches between the A.item1s and the B.item1s.
The above query doesn't specify any relationship between entities A
and B. Using an eomodel, I believe one must traverse relationships to
generate queries, so I don't think you can specify a qualifier that
will generate the above SQL. Someone please correct me if I am wrong.
I saw that I could type this as SQL within EOModeler, but WO or
EOModeler
should have this a basic capability.
See EOUtilities.rawRowsForSQL().
Aloha,
Art
_______________________________________________
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.