Subject | Re: Exexcutable Stored Procedures |
---|---|
Author | constantijnw |
Post date | 2005-08-06T15:18:45Z |
yahdominiek wrote:
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?
>$fbqry = ibase_prepare($fbconn, $stmt);
> This I use like this:
>
> function fb_gettekst($item, $lng, $cmp) {
> $fbconn = fb_connect();
> $stmt = "SELECT * FROM P_C_GETTEKST ( ? , ?, ? )";
> $res = ibase_execute($fbqry, $item, $lng, $cmp);And when you use this:
> $result = ibase_fetch_row($res);
> ibase_free_query($fbqry);
> ibase_close($fbconn);
> return htmlentities($result[0]);
> }
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?