RE: [ANN] ExistsInRelationshipQualifier: WHERE EXISTS (SELECT 1FROM A WHERE ...)
RE: [ANN] ExistsInRelationshipQualifier: WHERE EXISTS (SELECT 1FROM A WHERE ...)
- Subject: RE: [ANN] ExistsInRelationshipQualifier: WHERE EXISTS (SELECT 1FROM A WHERE ...)
- From: <email@hidden>
- Date: Wed, 20 Apr 2005 10:24:01 +0200
- Thread-topic: [ANN] ExistsInRelationshipQualifier: WHERE EXISTS (SELECT 1FROM A WHERE ...)
Kaj!
You might want to make sure you've got the latest version of ExistsInRelationshipQualifier and QualifierUtilities as available on my web site.
I am a bit surprised by the SQL you are seeing. The code generated by ExistsInRelationshipQualifier always starts with "SELECT 1 FROM". That part is hard-coded. Or did you accidentliy mix up the 2 SQL instructions quoted in your email.
Could you give me more details on your model. E.g. what are the entities and their relationship. What I understood so far is:
Person <----------------->> BESVART_SKJEMA <<----------------------------------> Sporreundersokelse
<- personerBesvart
What are the primary keys of those entities? Are there flattened relationships?
What are you trying to achive? Are you trying to find every instance of Sporreundersokelse which has a relationship to Person 1638 ?
You would be aiming for:
SELECT * from Sporreundersokelse t0
WHERE EXISTS (
SELECT 1 FROM BESVART_SKJEMA A0
WHERE A0.PERSONID = 1638
AND t0.SPORREUNDID = a0.SPORREUNDID);
That's exactly what you would get with my understanding of the situation. If you don't we'll have to step through the code of ExistsInRelationshipQualifierSupport.sqlStringForSQLExpression().
Pierre.
P.S.: Please refrain from using you PGP.sig when replying. The company mail filter thinks its a script or worm and chokes.
**********************************************************************
This email and any files transmitted with it are intended solely for
the use of the individual or entity to whom they are addressed.
If you have received this email in error please notify the sender
of this message. (email@hidden)
This email message has been checked for the presence of computer
viruses; however this protection does not ensure this message is
virus free.
Banque centrale du Luxembourg; Tel ++352-4774-1; http://www.bcl.lu
**********************************************************************
_______________________________________________
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