Re: Image datablade to Web?

syay · 1997-04-05T07:11:28Z

Markus Grønneberg Wold wrote: Has anyone managed to make pictures stored as "image" accessible on the web? I want to use the functions available in the Image Datablade on the images, so using LargeObjects doesn't do the trick. We use Illustra Release 3.2.1 on Windows NT 3.51, Web datablade release 2.1 and Image release 1.3. Markus Grønneberg Wold -- We'll make | Mail: markus@hiof.no great pets | Web: < http://www.hiof.no/~markusg/ > Hello Markus, 1) I assume that you manage to store the image using FileToLO through a normal sql statement or upload from a web page. 2) Assume that you have a table name "t_Image" with a shema like this: create table t_Image ( imgName text not null unique…

Posted in 1997

syay — Fri, 04 Apr 1997 23:11:28 -0800 — source: Informix-list mailing list archive (1991-1998)

<HTML><BODY> Markus Grønneberg Wold wrote:  <BLOCKQUOTE TYPE=CITE>Has anyone managed to make pictures stored as "image" accessible on the web? I want to use the functions available in the Image Datablade on the images, so using LargeObjects doesn't do the trick. We use Illustra Release 3.2.1 on Windows NT 3.51, Web datablade release 2.1 and Image release 1.3. Markus Grønneberg Wold -- We'll make | Mail: markus@hiof.no great pets | Web:  <<A HREF="http://www.hiof.no/~markusg/">http://www.hiof.no/~markusg/</A>> </BLOCKQUOTE>  Hello Markus, 1) I assume that you manage to store the image using FileToLO through a normal sql statement or upload from a web page. 2) Assume that you have a table name "t_Image" with a shema like this:   create table t_Image (      imgName     text not null unique,      imgFile         large_object  not null,      primary key(imgName)   ); 3) Now.. insert an image file (btnok.gif) from a  dir /www/tmp as:   insert into t_Image values ('img_btn_OK',FileToLO('/www/tmp/btnok.gif')); 4) well, this is the MI tag that you need to add into your page: <?MISQL SQL="select imgFile from t_Image where imgName = 'img_btn_OK';">  <img src="$WEB_HOME?LO=$1&type=image/gif" height="50" width=450" alt="image: button OK"> <?/MISQL> syay  syay@spyder.net.my SpyderNet Sdn Bhd <A HREF="http://www.spyder.net.my">http://www.spyder.net.my</A>; </BODY> </HTML>