CodeIgniter Forums - Search Results

Search Results

Thread: Mysql Stored Procedure multiple select
Post: RE: Mysql Stored Procedure multiple select

Lxocram Wrote: (06-12-2018, 11:49 PM) -- This is not possible. You only get 1 result variable. Split you stored proc in 3 separate calls and then make 3 calls. Or combine the 3 resultsets into 1 ...

Thread: Mysql Stored Procedure multiple select
Post: Mysql Stored Procedure multiple select

Hi, I have mysql stored procedure, which has multiple SELECT statements but I am getting results of first SELECT statement only in Codeigniter. Could you please suggest me how to get the remaining(2n...

Thread: MySQL stored procedure passing parameters issue in Model function.
Post: RE: MySQL stored procedure passing parameters issu...

pbarney Wrote: (01-25-2018, 01:58 PM) -- Can you show the code? What CI version? -- Hi, Below is the sample code. When I try to display all the parameter using "echo" it is displaying but these ar...

Thread: MySQL stored procedure passing parameters issue in Model function.
Post: MySQL stored procedure passing parameters issue in...

Hi All, While I am trying to pass parameters on MySQL stored procedure, it is passing empty values and getting the below error. But when pass the same value in a SELECT statement WHERE clause it is...

Thread: Execute MSSQL Stored Procedure
Post: RE: Execute MSSQL Stored Procedure

wahdicandras Wrote: (08-24-2017, 06:52 PM) -- Hello I have a problem to exec stored procedure of MSSQL use CodeIgniter. While i use $this->db->query("EXEC SP_NAME")->result(); also return an emp...