CustomQueryExpressionHintKey and rawRowKeyPaths?
CustomQueryExpressionHintKey and rawRowKeyPaths?
- Subject: CustomQueryExpressionHintKey and rawRowKeyPaths?
- From: Marcos Trejo Munguia <email@hidden>
- Date: Tue, 7 Mar 2006 13:02:26 -0600
Hi list:
I am trying to make a fetch using custom SQL, I tried with CustomQueryExpressionHintKey, but I also needed to return raw rows instead of complete Enterprise Objects, the thing is that it looks like if I use raw rows my custom SQL is ignored. Here is the code:
EOFetchSpecification fs = new EOFetchSpecification("Inventory", null, null, false, false, null);
fs.setHints(new NSDictionary("SELECT t0.productid, t0.qty FROM public.inventory t0 WHERE t0.productid IN(1, 2, 3, 4, 5, 6)", "CustomQueryExpressionHintKey");
fs.setRawRowKeyPaths(new NSArray(new String[] {"productid", "qty"}));
fs.setRefreshesRefetchedObjects(true);
NSArray inventory = ec.objectsWithFetchSpecification(fs);
Logged SQL:
SELECT t0.productid, t0.qty FROM public.inventory
as you can see my SQL was ignored.
Am I doing something wrong?, or the CustomQueryExpressionHintKey is only intended to fetch complete EO's?
_______________________________________________
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