no php exp but just a thought:

have you tried calling the stored proc with

$rec = ibase_execute($prep,$name->STR_TEST);

ie. is the assignation to $extravar causing the problem?

bill

Nigel Weeks wrote:

>$prep = ibase_prepare("SELECT * FROM SP_FIND(?)");
>while($name = (gets set from another query - but can contain spaces)){
> $extravar = $name->STR_TEST; // Put it into another variable
> $rec = ibase_execute($prep,$extravar);
>--------if $extravar has spaces, it dies--------
>
> $rec = ibase_execute($prep,'$extravar');
>--------it dies all the time, "Value '?' unknown" -----------
>
>
>
>
>