> Nope. I put that in the example to prevent the idea that the original
> $name->STR_TEST had any size or quoting inside it.
> In my application, it's rattling though an array of varchars(with spaces) -
> doing a prepare every time(just using ibase_query) makes it run incredibly
> slow...
>
> If the string has spaces, it dies.
> I've just had an idea, that may be the cause...nope. Dies silently(and stops
> all output)
>
> Anyone got it going?
> Shall I submit a PHP bug?

It may be worth trying on the php-db list.
http://www.php.net/mailing-lists.php -> Databases and PHP
I've had a quick scan, but not can't see and current answer.

The other thing is perhaps to look at ADOdb which seems to
go a good job at some other 'conversions'.
http://php.weblogs.com/ADODB

> -----Original Message-----
> From: Bill Katelis [mailto:bill@...]
> Sent: Monday, 23 June 2003 14:14
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Serious PHP question
>
>
> 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" -----------

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services