One for the experts - show image from a database 
Author Message
 One for the experts - show image from a database
Hey all,

not sure if this is the correct NG or not, but I'm displaying images in an
.asp file, by pulling the image from a database with code such as:

[show-image.asp]

[dsn connection]
mySQL="select * from images where id = 1"
set myRS = conntemp.execute(mySQL)

response.contenttype = myRS("contenttype")
response.binarywrite myRS("filedata")

this works perfectly, nothing overly complicated there - but it DOES NOT
work for progressive jpegs...

I've tried setting response.buffer = TRUE, and using response.flush and
response.clear, but to no avail. BMP's GIF, non-progressive JPEG's are all
fine, it's just progressive JPEG's that dont work.

Anyone have any ideas?

Help!

Ben



Mon, 28 Nov 2005 13:09:18 GMT  
 One for the experts - show image from a database
Set the Response.ContentType dependent on what sort of file it is. (and
store that with the DB record)

IIRC, progressives are Image/pjpeg

________________________________________
I got bored with my old signature,
so I changed it

Atrax. MVP, IIS
http://rtfm.atrax.co.uk/

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!



Mon, 28 Nov 2005 15:30:14 GMT  
 One for the experts - show image from a database
tried that - for a pjpeg I am sending "image/pjpeg" but it still don't work

and neither do ANY of the display image examples that I can find.....

B.


Quote:
> Set the Response.ContentType dependent on what sort of file it is. (and
> store that with the DB record)

> IIRC, progressives are Image/pjpeg

> ________________________________________
> I got bored with my old signature,
> so I changed it

> Atrax. MVP, IIS
> http://rtfm.atrax.co.uk/

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!



Tue, 29 Nov 2005 19:00:42 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Duplicate database fields in report expert, select expert...

2. image database slide show tpe application

3. How to access the Image from one Database to other

4. Some formulas not showing up in Chart Expert on Crystal 9

5. Index not showing in Visual Link Expert

6. HOWTO: Show few fields in Select Expert

7. Select Expert doesn't shown all fields

8. Combine Multiple images into one large image

9. Combining uncompressed TGA image slices into one image

10. one file->one image

11. Attention Access Experts, this one is tough...

12. One for the experts!

 

 
Powered by phpBB® Forum Software