Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Archive /

Our old forums are still available as a read-only archive.

Moderators: martimiz, Sean, biapar, Willr, Ingo, simon_w

show query result


Reply


1426 Views

Avatar
ojalà

Community Member, 87 Posts

25 November 2008 at 5:06am

Hi!
I have a big problem with my query. Can you hel me to show the result?
I create a function in Page.php that contain my query and that return $result. then I copy $result uin my template but nothig happen. what is wrong?
This is my code:

function TakeValue(){
      $sqlQuery = new SQLQuery();
      $sqlQuery->select[] = array(
          'nome AS nome',
          'tipologia AS tipologia'
         
      );
      $sqlQuery->from[] = "
       RicercaPollSubmission
      ";
      $sqlQuery->where = "
       Tipologia(RicercaPollSubmission.tipologia) = 1
      ";
      
      // get the raw SQL
      $rawSQL = $sqlQuery->sql();
      
      // execute and return a Query-object
      $result = $sqlQuery->execute();
      
      //turn it into SilverStripe objects
      $result = new DataObjectSet();
      foreach($query as $row) {
      $result->push(new TakeValueDataObject($row));

      }
      return $result;
}