I've got a query which could be dealt with by building up qualifiers, but I'd
prefer to use the model-based fetch spec.
As background: I have three tables: Image, Category and CategoryImage.
Image:
id name
1 Fred
2 Joan
CategoryImage
imageId categoryId
1 10
1 20
1 30
2 15
2 20
2 30
3 10
Category
id title
10 Hiking
15 Walking
20 Family
30 Older
The only value being passed into the query is the category title.
I want to return the image id for images which are in ALL the categories I'm
interested in - i.e., if the user selected 'Hiking', 'Family' and 'Older' then
I want to see only image 1. If the user selected 'Walking' and 'Older' I'd see
only image 2.
Can this be done in the model-based fetch-spec rather than having to build up
qualifiers?
Liz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
