From: | Fabrice Scemama <fabrice(dot)scemama(at)gesnet(dot)net> |
---|---|
To: | pgsql-general(at)hub(dot)org |
Subject: | Re: Displaying Image BLOBs |
Date: | 1999-01-26 16:01:03 |
Message-ID: | 36ADE6BF.793AB72A@gesnet.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> From: Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il>
(zip)
> In short, you should have a cgi whose URL may look something like:
>
> http://my.domain.com/cgi-bin/lo-dumper.cgi?oid=NNNNN&mime=image/jpeg
>
> When you have one, you can use it as your image source. Just write your
> image output with the above URL as its source:
>
> <IMG SRC="/cgi-bin/lo-dumper(dot)cgi?oid=123456(at)mime=image/jpeg"
> WIDTH=100 HEIGHT=40 ALT="Image of a bear">
>
> How did all the parameters get there? Well, I assume that anybody holding
> an image database will have an image table, which has fields for the image
> name or details (which can be used in the ALT), its width and height, and
> if there are several image types, also its type (jpeg, gif, png).
Keeping information about sizes of images might be embarrassing,
though I think there's on CPAN Perl modules to learn from an image
it's size, jpeg or gif alike (not sure).
But people might prefer using only the WIDTH *or* the HEIGHT
parameter; Netscape and Explorer will then keep the image ratio
when displaying the image.
My 2 cents ;)
Fabrice
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Ramsey | 1999-01-26 18:32:41 | Using SELECT to get table info. |
Previous Message | Mauricio C. de Oliveira | 1999-01-26 11:45:49 | Re: Re: Bad column offset? |