That's what I try but te result isn't better, I also try 'as Resultat.sg' but it dosen' change anything.
Array ( [0] => Array ( [Resultat] => Array ( [id] => 102 ) [0] => Array ( [sg] => ) ) [1] => Array ( [Resultat] => Array ( [id] => 103 ) [0] => Array ( [sg] => ) ) ) And now I ve any other idea. and you? On 2/8/07, Ámon Tamás <[EMAIL PROTECTED]> wrote: > > > Luigi wrote: > > Yes that's what I try first: > > > > $tests=$this->Resultat->findAll(null, > > array( 'id', > > 'IF ( message IS NULL , > > NULL , 1)'), > > null, > > null, > > null, > > -1); > > > > pr($tests); > > > > Give me : > > > > [1] => Array ( [Resultat] => Array ( [id] => 103 ) [0] => Array ( [IF ( > > message IS NULL , NULL , 1)] => ) ) [2] => Array ( [Resultat] => Array ( > > [id] => 104 ) [0] => Array ( [IF ( message IS NULL , NULL , 1)] => 1 ) ) > > > > Try this: 'IF ( message IS NULL , NULL , 1) as sg' > > > > -- > Ámon Tamás > http://linkfelho.amon.hu > > > > > -- Luigi --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
