Sorry it doesn't... that was a second attempt and I see its typo, the
myQualifier1 twice..
However, I am certainly not getting back what I can visually see in my
data.
I can definitely debug sql, if I can only see it. :(
-James
On Nov 8, 2004, at 8:15 PM, Chuck Hill wrote:
> Its not your qualifiers, you've just typed it in wrong. Take them all
> out.
> Add back one. Run. I just tried it. It works, trust me.
>
> Chuck
>
>
> At 07:56 PM 08/11/2004 -0600, James Cicenia wrote:
>> nothing... it's set in both places..
>>
>> Is there a way I can just get the sql my one fetch spec is creating?
>>
>> I am nesting a large or with an and and the results are not what
>> I am expecting
>>
>>
>>
>>
>>
>>
>> EOQualifier myQualifier1;
>> NSMutableArray args1 = new NSMutableArray();
>> args1.addObject("projectState.lifeCycleState");
>> args1.addObject(pLifeCycle);
>> myQualifier1 = EOQualifier.qualifierWithQualifierFormat("..= %@",
>> args1);
>>
>> EOQualifier myQualifier2;
>> NSMutableArray args2 = new NSMutableArray();
>> args2.addObject("portfolio");
>> args2.addObject(portfolio);
>> myQualifier2 = EOQualifier.qualifierWithQualifierFormat("..= %@",
>> args2);
>>
>> EOQualifier myQualifier3;
>> NSMutableArray args3 = new NSMutableArray();
>> args3.addObject("rosterMembers.resource.tosuser");
>> args3.addObject( this);
>> myQualifier3 = EOQualifier.qualifierWithQualifierFormat("..= %@",
>> args3);
>>
>> EOQualifier myQualifier4;
>> NSMutableArray args4 = new NSMutableArray();
>> args4.addObject("assignedProjectManager.tosuser");
>> args4.addObject( this);
>> myQualifier4 = EOQualifier.qualifierWithQualifierFormat("..= %@",
>> args4);
>>
>> EOQualifier myQualifier5;
>> NSMutableArray args5 = new NSMutableArray();
>> args5.addObject("sponsor.tosuser");
>> args5.addObject( this);
>> myQualifier5 = EOQualifier.qualifierWithQualifierFormat("..= %@",
>> args5);
>>
>> EOQualifier myQualifier6;
>> NSMutableArray args6 = new NSMutableArray();
>> args6.addObject("submitter.tosuser");
>> args6.addObject( this);
>> myQualifier6 = EOQualifier.qualifierWithQualifierFormat("..= %@",
>> args6);
>>
>> EOOrQualifier orQualifier =
>> new EOOrQualifier(
>> new NSArray(
>> new Object[] {
>> myQualifier3,
>> myQualifier4,
>> myQualifier5,
>> myQualifier6}));
>>
>> EOAndQualifier andQualifier =
>> new EOAndQualifier(
>> new NSArray(
>> new Object[] {
>> myQualifier1,
>> myQualifier1}));
>>
>> EOAndQualifier andQualifier1 =
>> new EOAndQualifier(
>> new NSArray(
>> new Object[] {
>> andQualifier,
>> orQualifier}));
>>
>> EOFetchSpecification fs = new
>> EOFetchSpecification("PortfolioProject",andQualifier1,null);
>>
>>
>>
>> On Nov 8, 2004, at 7:35 PM, Chuck Hill wrote:
>>
>>> Same way as ever. In the run config add -EOAdaptorDebugEnabled=true
>>> on
>>> either the Arguments or WO tab.
>>>
>>> Chuck
>>>
>>>
>>> At 07:00 PM 08/11/2004 -0600, James Cicenia wrote:
>>>> Hello -
>>>>
>>>> I can't for the life of me figure out how to see the generated SQL
>>>> for
>>>> a fetch specification I wrote.
>>>>
>>>> My qualifiers all look good so now I need to see the sql. Is there
>>>> an
>>>> easy way to System.out it?
>>>> I have set all the debugs to true in Eclipse's WO and EO Arguments.
>>>>
>>>> Nothing is being displayed to the console.
>>>>
>>>> -James
>>>>
>>>>
>>>
>>>
>>>
>>> --
>>>
>>> Chuck Hill chil..lobal-village.net
>>> Global Village Consulting Inc.
>>> http://www.global-village.net
>>>
>>
>>
>
> --
>
> Chuck Hill chil..lobal-village.net
> Global Village Consulting Inc.
> http://www.global-village.net
>
This archive was generated by hypermail 2.0.0 : Mon Nov 08 2004 - 21:23:35 EST