Re: Php, Blob, Oracle

On Thu, Feb 27, 2003 at 05:51:01PM +0200, M.ALPER KARASAHIN wrote: > > Hi, > > How can i display a blob column that contins a "MS word" object. > OR > How can i display a blob column that contins a bitmap object. > > function foo() > { > $this->statement = OCIParse($this->db_con_id, > "SELECT blobcolumn > FROM XXXXXX "); > if (!$this->statement) { > $oerr = OCIError($this->statement); > echo "Fetch Code 1:".$oerr["message"]; > exit; > }else{ > OCIExecute($this->statement); > } > > $displaypage=" > <table>"; > while (OCIFetchInto($this->statement,$row,OCI_ASSOC)){ while (OCIFetchInto($this->statement,$row,OCI_ASSOC|OCI_RETURN_LOBS)){ > $displaypage =$displaypage. > " > <tr> > <td align=\"center\" > class=\"td_yazi\">".$row["blobcolumn"]."</td>"; <td align=\"center\" class=\"td_yazi\">".$row["BLOBCOLUMN"]."</td>"; > > }; > $displaypage=" > <\table>"; > return $displaypage; > } -- Thies C. Arntzen - Looking for all sorts of freelance work - just ask.. http://www.amazon.de/exec/obidos/wishlist/AB9DY62QWDSZ