Subject Re: Exexcutable Stored Procedures
Author constantijnw
yahdominiek wrote:

>
> This I use like this:
>
> function fb_gettekst($item, $lng, $cmp) {
> $fbconn = fb_connect();
> $stmt = "SELECT * FROM P_C_GETTEKST ( ? , ?, ? )";
$fbqry = ibase_prepare($fbconn, $stmt);
> $res = ibase_execute($fbqry, $item, $lng, $cmp);
> $result = ibase_fetch_row($res);
> ibase_free_query($fbqry);
> ibase_close($fbconn);
> return htmlentities($result[0]);
> }



And when you use this:

function fb_gettekst_X($item, $lng, $cmp) {
$fbconn = fb_connect();
$stmt = "EXECUTE PROCEDURE P_X_GETTEKST($item, $lng, $cmp)";
$fbqry = ibase_prepare($fbconn, $stmt);
$res = ibase_execute($fbqry);
$result = ibase_fetch_row($res);
ibase_free_query($fbqry);
ibase_close($fbconn);

return htmlentities($result[0]);
}

you don't get a result?