Re: BLOB from database to Browser with out writing it out to a file.
Posted in 2003
Hi All. We do that you want to do. My organization stores imatges (gif, jpeg, etc) in blob columns and need to show them in html pages dynamicaly and don't want generate files at web server side. We replace the SRC subtag of IMG html tag with a servlet. The servlet connect to informix database, select the apropiate row from the apropiate table and the image are displayad into the html page. We "translate" this idea from php examples at : http://www.zend.com/zend/tut/statistics.php And work perfectly for us. If you want display word files only need cange the content-type directive of the cgi/servlet program. I hope this help you. En Mitch va escriure el dia 26 Aug 2003 a les 15:38: > I would like to be able to extract a BLOB from the database (Informix) > and pass it to a browser without writing it to a file. (The BLOB's > are word doc's, MS project doc's, and Excel spreadsheets. > > Is it is possible on Unix to designate a directory as a virtual > directory, (i.e it only exist it memory), so that I can extract the > file from the database, write it to the virtual directory and then > pass it to the browser? > > Any other suggestions that would allow me to move a BLOB from an RDBMS > directly to a browser? > -- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputaci' de Tarragona) Sistemes d'Informaci' Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 253 404 Fax # +34 977 227 302 http://www.base.es ipons@dtgna.altanet.org -- sending to informix-list