On Apr 21, 2006, at 4:03 PM, Daniel DeCovnick wrote:

I THINK 1 is working. It's generating what looks like valid SQL at least:
SELECT customerID FROM CUSTOMER WHERE hasShipped = ? AND customerID = customerID ORDER BY creationTime asc

Isn't hasShipped a QueueSpot property?  If so, the above SQL is invalid.

Hmm... I think I may be misinterpreting the nature of fetch requests then. Given a particular customer, I want to get an array of all their queuespots which have shipped. Something I could call like:

NSArray history = customer.shippingHistory(); 
or 
NSArray history = shippingHistory(session().defaultEditingContext()); 
whichever's appropriate.

NSArray history =  EOUtilities.objectsWithQualifierFormat(session().defaultEditingContext(), "QueueSpot", "customer = $@ and hasShipped = $@", new NSArray(new Object[] {customer, Boolean.TRUE)});

Aloha,
Art

 _______________________________________________
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]

Reply via email to