I have a small problem,
The execution of my stored procedure from my php
does not return values:
$op=1;
the variable $op
contains the number of my procedure
the variable $cadena
contains the search for the where
$SP="[ele].[Buscar_clientes]".$op.",".$cadena."'";
$recordSet=$fn->SP_BD($SP);
comppruebo si hay datos
if(!$recordSet->EOF){
while{....}
}else{
echo "error";
}
I print my variable $SP
to check that it executes
[ele].[Buscar_clientes]1,'Mario|Juan'
and I execute it in my sql and it brings the data that I am looking for but in my php it falls into the error
I have already used other procedures to insert and update but the problem is only when I have a procedure that brings data.