2007/9/21, Oliver Egger <[EMAIL PROTECTED]>:
>
> hi
>
> check out the message:
>
> http://lists.apple.com/archives/webobjects-dev/2004/Nov/msg00158.html
>
> i suspect this is still the same problem/bug ...
probably, I prepared a way in code to make it working, also because I think
that it is not possible to do with a simple query.
thank you, for the help!
cheers
> oliver
>
> On 9/21/07, Daniele Corti <[EMAIL PROTECTED]> wrote:
> >
> >
> > 2007/9/20, Oliver Egger <[EMAIL PROTECTED]>:
> > > hi
> > >
> > > did you try to specify the relationship as an left outer join?
> > > otherwise it will not
> > > be working (the join will not return any results). not all database
> > > plugins however
> > > support left outer join as far as i know ...
> >
> > I tried but It doen't work good!
> >
> > let me give the example:
> >
> > I have two Objects GWSLicense and GWSStock with the relations
> >
> > stock>
> > GWSLicense <<--------> GWSStock
> > <licenses
> >
> > I want the stocks that doesn't have any license associaed or that all
> the
> > licenses associaed are invalid (GWSLicense.isValid = 0)
> >
> > I try to ut two Key value qualifier:
> >
> > keyvaluequalifier = new EOKeyValueQualifier("licenses",
> > EOQualifier.QualifierOperatorEqual,
> > EOEnterpriseObject.NullValue);
> >
> > keyvaluequalifier = new EOKeyValueQualifier("licenses.isvalid",
> > EOQualifier.QualifierOperatorNotEqual, new Integer(1));
> >
> > in a EOOrQualifier
> >
> > I get this:
> >
> > SELECT t0."idConfiguration", t0."idStock", t0."serialNumber" FROM
> > "_SYSTEM"."GWS_STOCK" t0, "_SYSTEM"."GWS_LICENSE" T1 WHERE
> ((t0."idStock" is
> > NULL OR T1."isValid" <> 1) AND t0."idConfiguration" = 6) AND
> t0."idStock" *=
> > T1."idStock"
> >
> > of course this is absurd because t0.idStock is the primary key of
> GWS_STOCK
> >
> > I don't know if this is possible, also because I don't know how the SQL
> > query should be...
> >
> >
> > > cheers
> > > oliver
> > >
> > >
> > >
> > > On 9/20/07, Daniele Corti <[EMAIL PROTECTED]> wrote:
> > > > Hi all,
> > > > I was looking for a way to fetch an object that have empty
> relations
> > > > using EOQualifiers
> > > >
> > > >
> > > > I used this qualifier:
> > > >
> > > > keyValueQualifier = new
> > EOKeyValueQualifier("activations",
> > > > EOQualifier.QualifierOperatorEqual ,
> > > > EOEnterpriseObject.NullValue );
> > > >
> > > > but it doesn't seem to work. activations is a toMany relation of the
> > fetched
> > > > object
> > > >
> > > > --
> > > > Daniele Corti
> > > > AIM: S0CR4TE5
> > > > Messenger: [EMAIL PROTECTED]
> > > >
> > > > --
> > > > Computers are like air conditioners -- they stop working properly if
> you
> > > > open
> > > > WINDOWS
> > > >
> > > > --
> > > > What about the four lusers of the apocalypse? I nominate:
> > > > "advertising", "can't log in", "power switch" and "what backup?"
> > > > --Alistair Young
> > > > _______________________________________________
> > > > Do not post admin requests to the list. They will be ignored.
> > > > Webobjects-dev mailing list ([email protected])
> > > > Help/Unsubscribe/Update your Subscription:
> > > >
> >
> http://lists.apple.com/mailman/options/webobjects-dev/oliver.egger%40gmail.com
> > > >
> > > > This email sent to [EMAIL PROTECTED]
> > > >
> > >
> > >
> > > --
> > > oliver egger
>
> >
> > --
> >
> > Daniele Corti
> > AIM: S0CR4TE5
> > Messenger: [EMAIL PROTECTED]
> >
> > --
> > Computers are like air conditioners -- they stop working properly if you
> > open
> > WINDOWS
> >
> > --
> > What about the four lusers of the apocalypse? I nominate:
> > "advertising", "can't log in", "power switch" and "what backup?"
> > --Alistair Young
> > _______________________________________________
> > Do not post admin requests to the list. They will be ignored.
> > Webobjects-dev mailing list ([email protected])
> > Help/Unsubscribe/Update your Subscription:
> >
> http://lists.apple.com/mailman/options/webobjects-dev/oliver.egger%40gmail.com
> >
> > This email sent to [EMAIL PROTECTED]
> >
>
--
Daniele Corti
AIM: S0CR4TE5
Messenger: [EMAIL PROTECTED]
--
Computers are like air conditioners -- they stop working properly if you
open
WINDOWS
--
What about the four lusers of the apocalypse? I nominate:
"advertising", "can't log in", "power switch" and "what backup?"
--Alistair Young
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
