Re: Qualifiers, many-to-many and horizontal inheritance
Re: Qualifiers, many-to-many and horizontal inheritance
- Subject: Re: Qualifiers, many-to-many and horizontal inheritance
- From: Timo Hoepfner <email@hidden>
- Date: Sat, 22 Jul 2006 11:28:11 +0200
You pretty much have to use some sort of extension to the
qualifiers that ship with WO. It looks like Pierre Bernard has
posted updated versions of his here:
http://www.bernard-web.com/pierre/webobjects/code.html
Trying these qualifiers right now, but no luck. The generated SQL
looks into the wrong tables.
3. All Assets that belong to a certain Keyword and have a certain
filename
I tried
q2 = new InSetQualifier(Asset.KEY_KEYWORDS, new NSSet(selectedKeyword));
Which generates SQL like
FROM assets t0, keyword T2, assets_keywords T1
WHERE T2.id IN ( ?) AND T1.keyword_id = T2.id AND t0.id = T1.asset_id
But the keyword table is empty, as it belongs to an abstract entity
in the horizontal inheritance scheme. This is the SQL I would need to
solve my problems 3 and 4:
FROM assets t0, assets_keywords T1
WHERE T1.keyword_id IN ( ? ) AND t0.id = T1.asset_id
So back to plan B for now: If I specify raw SQL for a FetchSpec in
EOModeler, how can I specify named bindings?
Timo
_______________________________________________
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