Silverstripe Pastes

	function Awards() {

       

      $sqlQuery = new SQLQuery(); 

      $sqlQuery->select = array( 

      '*'

      );

       

      $sqlQuery->from = array("ProductAward"); 

      $sqlQuery->orderby = "AwardYear DESC, AwardIssuer"; 

    

      // get the raw SQL 

      $rawSQL = $sqlQuery->sql(); 

      // execute and return a Query-object 

      $result = $sqlQuery->execute(); 

      

      //setup our blank DataObjectSet to push SQL result data into it. 

      $year = new DataObjectSet(); 

      foreach($result as $row) { 

         //move the SQL result data to the DataObjectSet 

          $year->push(new ArrayData($row)); 

      } 

      fb::log($year, "Result");

      

   }