Jump to:

17452 Posts in 4473 Topics by 1971 members

Archive

SilverStripe Forums » Archive » show query result

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

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

Page: 1
Go to End
Author Topic: 1356 Views
  • ojalà
    Avatar
    Community Member
    87 Posts

    show query result Link to this post

    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;
    }

    1356 Views
Page: 1
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.