hi,
thanks for your reply, but i don't have all my object because i use
objectInRange function so when i execute my fetchSpecification i just
have the first ten element so i need to have "last null" sql function
execute by my fetchSpecification.
Le 18/07/12 22:00, Farrukh Ijaz a écrit :
I don't think the API supports this function as it appears to be a
vendor specific feature. There are two approaches and you can adapt
whatever you like:
Approach 1: This will make 2 db calls at minimum and will have more
memory consumption.
NSArray<MyTable> objects1 = // objects where myDate() is null;
NSArray<MyTable> objects2 = // objects where myDate() is not null but
sorted as you like...
NSArray<MyTable> objects = // append objects1 and objects2
Approach 2: This will make 1 db call, uses less memory. It's quite
simple and easy to understand. The whole idea is to push the nulls at
the end with minimum instructions.
Case 1: descs()
NSArray<MyTable> objects = // sorted objects either using descs() so
nulls are already at the end so no worries
Case 2: ascs()
NSArray<MyTable> objects = // sorted objects using ascs() so nulls are
in the beginning
MyTable object = objects.get(objects.count() / 2); // to check if the
*if*(object.myDate() != *null*) {
Enumeration<MyTable> e = objects.objectEnumerator();
*while*(e.hasMoreElements()) {
object = e.nextElement();
*if*(object.myDate() != *null*) *break*;
objects.remove(object);
objects.add(object);
}
} *else* {
Enumeration<MyTable> e = objects.reverseObjectEnumerator();
*while*(e.hasMoreElements()) {
object = e.nextElement();
*if*(object.myDate() == *null*) *break*;
objects.remove(object);
objects.add(0, object);
}
}
// After the above code execution, the nulls are pushed to the end in
minimum execution time.
Farrukh
On 2012-07-18, at 6:06 PM, ALEXANDRE Grégoire <g.alexan...@symaris.com
<mailto:g.alexan...@symaris.com>> wrote:
Yes but i need
MyTable.MY_DATE.descs() // will put nulls at the end
MyTable.MY_DATE.ascs() // will put nulls at the end
=> "nulls last" in sql and i used ERXEOControlUtilities.ObjectInRange...
Le 18/07/12 16:14, Farrukh Ijaz a écrit :
Hi,
Should be something like:
MyTable.MY_DATE.descs() // will put nulls at the end
MyTable.MY_DATE.ascs() // will put nulls at the first
Farrukh
On 2012-07-18, at 2:02 PM, ALEXANDRE Grégoire
<g.alexan...@symaris.com <mailto:g.alexan...@symaris.com>> wrote:
hi,
i need to create fecth specification with my null element at the
end of the response
for example i need tu create this;
select * from my_table order by my_date*nulls first*;
thanks for reply.
--
Grégoire ALEXANDRE
Développeur
GIP Sym@ris
Pavillon 1
27 rue du 4ème RSM B.P. 29
F-68250 ROUFFACH
tel : 0389787406
Courriel :g.alexan...@symaris.com
Web :http://www.symaris.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com
<mailto:Webobjects-dev@lists.apple.com>)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/farrukh.ijaz%40fuegodigitalmedia.com
This email sent to farrukh.i...@fuegodigitalmedia.com
--
Grégoire ALEXANDRE
Développeur
GIP Sym@ris
Pavillon 1
27 rue du 4ème RSM B.P. 29
F-68250 ROUFFACH
tel : 0389787406
Courriel :g.alexan...@symaris.com
Web :http://www.symaris.com
--
Grégoire ALEXANDRE
Développeur
GIP Sym@ris
Pavillon 1
27 rue du 4ème RSM B.P. 29
F-68250 ROUFFACH
tel : 0389787406
Courriel : g.alexan...@symaris.com
Web : http://www.symaris.com
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
