Subject Re: [firebird-php] Re: Problem in retrieving BLOB data
Author Lester Caine
Umberto Masotti wrote:
> bala_karat ha scritto:
>> Thanks again Lester Caine for yr valuable time.
>>
>> I tried the following:
>>
>> $host = "localhost:C:/BK_Share/file_test/FILE.FDB";
>> ibase_connect($host, "SYSDBA", "masterkey");
>> $result = ibase_query("select TEST from EMPLOYEEMASTER where EMPCODE = '002'");
>> $data = ibase_fetch_object($result,IBASE_TEXT);
>> $blob_hndl = ibase_blob_open($data->TEST);
>>
> No, you misunderstood. Quoting from manual " Passing *IBASE_TEXT* will
> cause this function to return BLOB contents instead of BLOB ids".
> So you should directly:
> echo $data->TEST;
> because you have a text not a blob-id.

Yes - I was rushing so was not explaining very well :( Sorry!

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php