Using DataTables with Symfony (Doctrine version)

  public function executeList(sfWebRequest $request)
  {
    if ($request->isXmlHttpRequest())
    {
      $q = Doctrine_Query::create()
      ->select('column1,column2,column3,column4')
      ->from('table');
 
      $pager = $this->getPager('table', $q, $request->getParameter('page', $this->getPage()), $request->getParameter('iDisplayLength'));
 
      $aaData = array();
      $list = $pager->getResults();
      foreach ($list as $v)
      {                                             
	$aaData[] = array(
          "0" => $v->getColumn1(),
          "1" => $v->getColumn2(),
          "2" => $v->getColumn3(),
          "3" => $v->getColumn4(),
        );
      }
 
      $output = array(
     	"iTotalRecords" => count($pager),
     	"iTotalDisplayRecords" => $request->getParameter('iDisplayLength'),
    	"aaData" => $aaData,
      );
 
      return $this->renderText(json_encode($output));
   }
  }

<style type="text/css" title="currentStyle">
	@import "/sfDataTables/css/demo_page.css";
	@import "/sfDataTables/css/demo_table.css";
</style>
 
<script type="text/javascript" language="javascript" src="/sfDataTables/js/jquery.dataTables.js">
 
<table cellpadding="0" cellspacing="0" border="0" class="display" id="example">
	<thead>
		<tr>
			<th width="25%">Column1</th>
			<th width="25%">Column2</th>
			<th width="25%">Column3</th>
			<th width="25%">Column4</th>
		</tr>
	</thead>
	<tbody>
		<tr>
			<td colspan="3" class="dataTables_empty">Loading data from server</td>
		</tr>
	</tbody>
	<tfoot>
		<tr>
			<th width="25%">Column1</th>
			<th width="25%">Column2</th>
			<th width="25%">Column3</th>
			<th width="25%">Column4</th>
		</tr>
	</tfoot>
</table>
 
 
<script>
$(document).ready(function() {
   $('#example').dataTable( {
      "bStateSave": true,
      "sPaginationType": "full_numbers",
      "bProcessing": true,
      "bServerSide": true,
      "sAjaxSource": "<?php echo url_for('module/list') ?>",
   })
});
</script>