Database Library does not support prepared statements

[zombor]

Database library should support prepared statements.

[ae]

hiya - please see attached file for how we dealt with stored procedures. its based of a VERY early revision of kohana, so its very codeigniterish :)

note how it completely overrides the db object. we are supplying thyis more as a point of reference, rather than a replacement.

cheers

andrew (code done by gary)

[ae]

stored procedures example contained within

[ae]

heres an example of how the sp was called in code :

public function events_count($u_id) {

$this->K->db->call('events_count', $u_id);

# Check the return result of the procedure call if($this->K->db->error){

# generate an error parent::generate_error('events_count_'.$this->K->db->error); return False;

}else{

# check to see what the count is $e_data = $this->K->db->results; return $e_data[0]e_count?;

}

}