Text data type problem – Informix Archive

nierjesh kumar — Mon, 08 Mar 2010 11:52:56 — source: IIUG Forums & Mailing Lists

Dear All Platform Detail: OS :Fedora 8 Database :Informix 11.50 PHP :PHP 4.3.9 I have stored the some value in text data type but when i try to get the values through php it does not return any thing. *Query to store the data in text_col,text_col1 which is Text Data Type* $data="nierjesh"; $data1="anshu"; $blobs = ifx_create_blob(1, 0, $data); $blobs1 = ifx_create_blob(1, 0, $data1); $blob_arr[0]=$blobs; $blob_arr[1]=$blobs1; $sql="insert into care_ambulence(amb_no,amb_model,create_date,submit_by, modify_id,modify_date,text_col,text_col1)values(0,0,'2010-10-10 10:00:00','nierjesh','nierjesh','2010-10-10 10:00:00',?,?)"; if($res=$db->Execute($sql,$blob_arr)){ echo "nierjesh"; }else{ echo ifx_error(); } *Query to retrieve the values of text data type* $sql="select * from care_ambulence"; if($res=$db->Execute($sql)){ while($row=$res->FetchRow()){ echo $row['amb_no']."::".$row['amb_model']."::".ifx_get_blob($row["text_col"])."::".i fx_get_blob($row["text_col1"]).'<br>'; } }else{ echo "nierjesh";exit; echo ifx_error(); exit; } but does not return any thing so please help me. Regards- Nierjesh --0016363b797a8de4a2048148b435

↪ replying to nierjesh kumar

nierjesh kumar — Tue, 09 Mar 2010 08:31:54 — source: IIUG Forums & Mailing Lists

Dear All Platform Detail: OS :Fedora 8 Database :Informix 11.50 PHP :PHP 4.3.9 I have stored the some value in text data type but when i try to get the values through php it does not return any thing. *Query to store the data in text_col,text_col1 which is Text Data Type* $data="nierjesh"; $data1="anshu"; $blobs = ifx_create_blob(1, 0, $data); $blobs1 = ifx_create_blob(1, 0, $data1); $blob_arr[0]=$blobs; $blob_arr[1]=$blobs1; $sql="insert into care_ambulence(amb_no,amb_model,create_date,submit_by, modify_id,modify_date,text_col,text_col1)values(0,0,'2010-10-10 10:00:00','nierjesh','nierjesh','2010-10-10 10:00:00',?,?)"; if($res=$db->Execute($sql,$blob_arr)){ echo "nierjesh"; }else{ echo ifx_error(); } *Query to retrieve the values of text data type* $sql="select * from care_ambulence"; if($res=$db->Execute($sql)){ while($row=$res->FetchRow()){ echo $row['amb_no']."::".$row['amb_model']."::".ifx_get_blob($row["text_col"])."::".i fx_get_blob($row["text_col1"]).'<br>'; } }else{ echo "nierjesh";exit; echo ifx_error(); exit; } but does not return any thing so please help me. Regards- Nierjesh --001636283988821ccd04815a03af

↪ replying to nierjesh kumar

nierjesh kumar — Thu, 01 Apr 2010 09:46:03 — source: IIUG Forums & Mailing Lists

Dear All Platform Detail: OS :Fedora 8 Database :Informix 11.50 PHP :PHP 4.3.9 I have stored the some value in text data type but when i try to get the values through php it does not return any thing. *Query to store the data in text_col,text_col1 which is Text Data Type* $data="nierjesh"; $data1="anshu"; $blobs = ifx_create_blob(1, 0, $data); $blobs1 = ifx_create_blob(1, 0, $data1); $blob_arr[0]=$blobs; $blob_arr[1]=$blobs1; $sql="insert into care_ambulence(amb_no,amb_model,create_date,submit_by, modify_id,modify_date,text_col,text_col1)values(0,0,'2010-10-10 10:00:00','nierjesh','nierjesh','2010-10-10 10:00:00',?,?)"; if($res=$db->Execute($sql,$blob_arr)){ echo "nierjesh"; }else{ echo ifx_error(); } *Query to retrieve the values of text data type* $sql="select * from care_ambulence"; if($res=$db->Execute($sql)){ while($row=$res->FetchRow()){ echo $row['amb_no']."::".$row['amb_model']."::".ifx_get_blob($row["text_col"])."::".i fx_get_blob($row["text_col1"]).'<br>'; } }else{ echo "nierjesh";exit; echo ifx_error(); exit; } but does not return any thing so please help me. Regards- Nierjesh --0016363b916ade2f53048329ba7e