OLE/Image Datatypes using in IDC and HTX

OLE/Image Datatypes using in IDC and HTX

Post by Todd A. Hyat » Fri, 03 Jan 1997 04:00:00



I have a need to use gif images that I have saved in SQL database using the
image datatype.  I would like to display these in dynamic web pages created
via the IDC and published using HTX template page.

Has anyone tried this?

Is there another product that would do this? (I am using IIS 3.0 SQL 6.5
and NT4.0)

Thank you in advance for any help on this issue,

Todd Hyatt

 
 
 

OLE/Image Datatypes using in IDC and HTX

Post by Icem » Sun, 05 Jan 1997 04:00:00



Quote:

>I have a need to use gif images that I have saved in SQL database using the
>image datatype.  I would like to display these in dynamic web pages created
>via the IDC and published using HTX template page.

>Has anyone tried this?

I don't actually store the image in the database, because most browsers expect
an inline file to have a recognized extension in order to determine how to
display it. I store the images in a directory on the disk, and simply put the
relative path in the database, and then include that as <img
src="<%pathname%>"> in the .htx file.

I'm not familiar with any server software that will format the image and
output the mime type with the image stream.

Hope this helps

Ice

 
 
 

1. Images from SQL with IDC/HTX?

 I am using the IDC/HTX method to query a SQL database and return some
product information. However I would like to return an image of the product
with the rest of the information and this is where I am stuck. I have
decided not to put the images into the SQL table due to other
considerations, and I have put the URL's path to the images in the table.
The images are stored in my web servers directories.(IIS 4.0) Now, how do I
return a link to the image or return the image with the result set?
Any help would be appreciated.
Jonathan Amos

2. SQL query

3. Long text display truncated using IDC/HTX

4. large string data type

5. Updating a record from a webpage using idc + htx

6. US-NY: Manhattan-Sr. Developer – Oracle and Java

7. Result Sets using .idc and .htx

8. Progress w/ ODBC database

9. Need help using files .idc and .htx

10. Q: SQL6.5 and web using IDC, HTX?

11. using IDC and htx files to be displayed on a web page from Access

12. Store image by using image datatype in SQL 7.0