Hello again,

I have not received any response to my previous post so I thought I'd be more specific as to my issue. In Page_results.ss, the template used to display the search results, I would like to be able to display more information on the pages found than just the title.

I want to pass the SiteTree ID from inside the <% control Results %> loop to a function which takes that ID and gets the other fields from the BlogEntry table:

function BlogPostInfo($identifier) {
      
      $results = new DataObjectSet();
      
      $blog_posts = DB::query("SELECT * FROM BlogEntry, SiteTree WHERE BlogEntry.ID = SiteTree.ID AND BlogEntry.ID = '". $identifier ."'");
      
      foreach($blog_posts as $sqlResult) {

         $Author = $sqlResult['Author'];
         $Date = $sqlResult['Date'];
         $Tags = $sqlResult['Tags'];
      
         $results->push(new ArrayData(array(
            "Author" => $Author,
            "Date" => $Date,
            "Tags" => $Tags
         )));
         
      }
      
      return $results;
   }

So, inside my <% control Results %> loop, I have this:

<% control BlogPostInfo(ID) %>

Aaaaaand nothing happens! What am I doing wrong here? How can this sort of thing be achieved? Surely I should be able to get the other fields from a Page in the Results list, no?

Thanks again,
Garrett

Can't thank you enough for your help, willr. Tremendous. This makes good sense. However, I am confused by your use of "BlogInfo", as this appears nowhere in my code. My function is called BlogPostInfo(). Is this some other variable you are inventing? Also, where should the BlogPostInfo() function actually LIVE? The same place that GenericDataAdmin.php (that's where Results() is) or in Page.php, or...?

Thanks again,
Garrett

Hi,

I got this all sorted out and am getting the fieelds I need from the BlogEntry table. Thanks a lot for your help.

One more thing, though-- how come I can't perform a Long() on the Date?? When I say, "$Date.Long" or ".Nice" in the template, the Date disappears.

//Garrett