[eluser]adanyc[/eluser]
Hi guys, I'm having many problems in code igniter and I would like u could help me.
I have the following stored procedure created in SQL Server 2008.
Code:
CREATE PROCEDURE [dbo].[USP_CODEIGNITER_DEMO]
@nAreId INT=NULL,
@cAreDescripcion VARCHAR(100)=NULL,
@error VARCHAR(100) OUTPUT
AS
BEGIN TRANSACTION
BEGIN TRY
BEGIN
UPDATE AREA SET cAreDescripcion=@cAreDescripcion WHERE nAreId=@nAreId
END
SET @error ='exito'
COMMIT TRANSACTION
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
SET @error =ERROR_MESSAGE()
END CATCH
This stored make an update in one table I have.
My PHP code is this:
Code:
function update_usuarios() {
$nAreId='767';
$cAreDescripcion='mydescripcion';
$error = ""; // I tested it whith null also
$query = $this->db->query("USP_CODEIGNITER_DEMO ?,?,?", array(
$nAreId,
$cAreDescripcion,
$error
));
return $error;
}
In my view I only wanna print my output resul from my sql stored procedure, of 'exito' or 'error' from my action.
I give u my model code too:
Code:
function index() {
$data['datax'] = $this->usuarios_model->update_usuarios();
$this->load->view('usuarios_view', $data);
}
Sorry 4 my bad english, I'm from Peru.
Thanxs 4 all.
I hope ur help.
CYA