Hi, thanks for your answer, but i don't understand what
ERXFrameworkPrincipal work. when is it called?
Le 26/07/12 23:17, Ricardo J. Parada a écrit :
Hi Grégoire,
I don't know if this will help or not. The problem I had is that
in-memory sorting treated nulls different that sorting in the d
Hi Grégoire,
I don't know if this will help or not. The problem I had is that in-memory
sorting treated nulls different that sorting in the database query. The
database in my case was ORACLE. To make in-memory sorting congruent with
ORACLE's sorting of nulls I had to do the following:
First
On 2012-07-19, at 9:39 AM, Maik Musall wrote:
>
> Am 18.07.2012 um 22:00 schrieb Farrukh Ijaz
> :
>
>> 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.
>
> It us
Am 18.07.2012 um 22:00 schrieb Farrukh Ijaz
:
> 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.
It uses less memory, but still does the null filtering in Java. I thi
Try fetchSpecification.setHints(...) method and see if this can solve your
problem? May be there is a way to tell the query optimizer through some hint to
use nulls first or nulls last.
Farrukh
On 2012-07-19, at 9:02 AM, ALEXANDRE Grégoire wrote:
> hi,
> thanks for your reply, but i don't hav
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
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 objects1 = // objects where myDate() is null;
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() //
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 wrote:
> hi,
> i need to create fecth specification with my null element at the end of the
> response
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 ROUF
10 matches
Mail list logo
