Re: Is it a bug of CakePHP?

Pham Huu Le Quoc Phuc a écrit :

I catch an error, could you tell me if you have some ideas? class Dsptraining extends AppModel {

     function GetDsptrainings()
     {
          return $this->findBySql("select max(start_date) start_date from

tbl_dsptrainings");

     }

} did you try your sql query directly using sql ?

try this one : select max(start_date) as start_date from tbl_dsptrainings N F

class DsptrainingsController extends AppController {

        function index()
        {
          $data = $this->Dsptraining->GetDsptrainings();
          echo $data[0]['start_date'];
      }

} Error message: Undefined index: start_date in c:\Inetpub\wwwroot\Cake\app\controllers\dsptrainings_controller.php on line 33