XML-RPC ... sending a query result back as a result

[eluser]skattabrain[/eluser]
here is what the ODBC $query looks like (var_dump)

Code:

object(CI_DB_odbc_result)#12 (7) {
  ["conn_id"]=>
  resource(30) of type (odbc link persistent)
  ["result_id"]=>
  resource(31) of type (odbc result)
  ["result_array"]=>
  array(0) {
  }
  ["result_object"]=>
  array(0) {
  }
  ["current_row"]=>
  int(0)
  ["num_rows"]=>
  int(59)
  ["row_data"]=>
  NULL
}

In order to use it in a normal controller/view scenrio it's same there anyways...

Code:

echo '<ul>';
        foreach($query->result() as $row)
        {
            echo '<li>'.anchor('get_customer/profile/'.$row->CustomerNo, $row->CustomerName).' </li>';            
        }
        echo '</ul>';