RE: select 'top' query??
RE: select 'top' query??
- Subject: RE: select 'top' query??
- From: Marius Strumyla <email@hidden>
- Date: Mon, 22 Mar 2004 17:04:17 -0500
Jonathan, fetch specification in EOModeler has "Use Raw SQL Expression"
option.
Check the option and just add TOP 100 after select. Would that not work? I
think
the fetch would still create a EOF objects for you.
I know I wanted to use it for fetching DISTINCT records. But I had to
specify which
attributes should be distinct. And this didn't work out for me.
Let me know how it goes for you.
--
marius
-----Original Message-----
From: email@hidden
[mailto:email@hidden]On Behalf Of Jonathan
Rochkind
Sent: Monday, March 22, 2004 3:04 PM
To: email@hidden
Subject: select 'top' query??
My DB will accept SQL of the form:
SELECT TOP 100 column1, column2, etc
FROM [etc]
To return just the first 100 records, for instance.
Has anyone figured out a good easy way to get EOF to send a query
like this? In a full EO query, not raw rows with hand constructed
SQL. None of my usual tricks for customizing SQL apply here. Anyone
have any ideas for something relatively easy?
--Jonathan
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.