PHP+IDS9.14: Problems retrieving CLOBS an SBLOBS
Posted in 2000
Hi, I tried to get some pictures and large texts out of an IDS 9.14.UC8 using PHP4 with Apache (on a SUN Solaris 2.6 Server). Everything works fine for standard SQL-Types (even for lvarchar) but I'm not able to reach this SBLOBS (I atached one sample from the tests) . PHP4 was included into Apache-Configuration using standard configure. How can I check afterwards if "HAVE_IFX_IUS" (for an IDS Version >=9.0) is configured? How can I get the data of an SBLOB-datatype (like BLOB,ClOB) maybe from the following table? : create table test (id serial, object clob); -- one version of this tests, which not work, I also tried ifxus_read_slob(long bid, long nbytes), but not if I got the right bid; <?php # get text $sqltext="select object from mf_newstextl where id=128;"; ifx_textasvarchar(1); ifx_byteasvarchar(1); $rid_text = ifx_query($sqltext, $conn_id); if ( ! $rid_text ) { $status->error( "Error on select intro!".ifx_errormsg().ifx_error() ); die; } ifx_htmltbl_result($rid_text, "border=\\"1\\""); $row_text = ifx_fetch_row ($rid_text); echo $row_text["object"].':'.$row_text.':'.$sqltext; #test=ifx_get_blob($row_text["object"]); #string_var = ifx_get_blob($blob_id);" ?> Thanks for your help and have a happy day Dirk -- dirk.liesch@messefrankfurt.com