Re: select 'top' query??
Re: select 'top' query??
- Subject: Re: select 'top' query??
- From: "WebObjects EMail" <email@hidden>
- Date: Tue, 23 Mar 2004 10:04:54 +0100
in the EOModeler select ur Fetch
Options
set Max Row to 1 or 10 or 100 as much u want
so u will get the TOP 1 without using TOP.
Pease
Sako!
----- Original Message -----
From: "Jonathan Rochkind" <email@hidden>
To: <email@hidden>
Sent: Monday, March 22, 2004 9:03 PM
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.