Have you tried named pipes..? and maybe samba...?



mitchell.miller@bankof
america.com (Mitch) To: informix-list (AT) iiug (DOT) org
Sent by: cc:
owner-informix-list@ii Subject: BLOB from database to Browser with out writing it out to a file.
ug.org


27/08/2003 10:38
Please respond to
mitchell.miller






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?




--------------------------------------------------------------------------


THE FOLLOWING WARNINGS ATTACH TO THIS COMMUNICATION
This material is intended for the named recipient only and has been created
solely for the purpose and function of Livestock Improvement Corporation
Limited and may contain information that is subject to the Privacy Act /
Confidentiality / Privilege / Copyright. Any person other than the named
recipient is prohibited from retaining / disclosing / copying /
distributing / using all or part of this material.


sending to informix-list

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:

--
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 (AT) dtgna (DOT) altanet.org
--


sending to informix-list