hi Guys,

I'm using Firebird 1.5 with PHP5.

I have a problem where by I am trying to do the equivelant of:

        $a = 'A';
        $b = 'AG';
        if (stristr($b, $a)) {
                // do something.
        }

Inside a Stored procedure, where $a and $b are both input variables
to the stored procedure.

The Interbase Lang Ref (PDF) doesn't help
me here - I've tried all sorts of forms of syntax using CONTAINS and LIKE
but it all gives syntax errors... (which didn't surprise me!)

Then I thought that I could used Ard Biesheuvels php_ibase_udf UDF lib for
firebird,  php_ibase_udf.c is in the php cvs (somewhere); this lib allows access
to php functions defined in your calling scripts. at any rate I get BLR type 
errors
when I tried to use the UDFs (btw googling php_ibase_udf.c doesn't return a 
lot, but
you will definitely find one email mentioning the BLR error!!). Actually I have 
tried
setting up this UDF lib on 3 different servers (all fbird1.5/php5 - different 
minor versions)
with out any luck.

does anyone have a clue as to how do the equivalent of the PHP above inside
a firebird stored procedure? or possibly can point out so good 
literature/examples
(all the good firebird stuff seems to be in russian) on/of 'advanced' stored
procedures.

alternatively is there anyone out there that has gotten the php_ibase_udf UDF 
lib
to work (Lester Caine have you tried it yet?, I ask you specifically because 
your
name often pops up on php lists in relation to firebird :-).

before any says: "why not ask the developer" - we'll his is an aquaintance of 
mine,
I have his mobile number and I have asked him!, its just a case of he has _no_ 
time
(due to dissitation/research  commitments) to dig into the problem and
I know that he will help when he gets some free time again, but for now I'm on 
mine own.

hope somebody can give me a clue :-),

thanks and regards,
Jochem

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



Reply via email to