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?

Nige

-----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" -----------
>
>
>
>
>

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/