Hello every body, I am trying in ASP to upload and download pictures in a mysql database. AND I have some problem with the download, could you help me???

my code is the following:

for the upload:
'Conn.Execute("INSERT Push.imageupload(user_id,image_full,image_desc) VALUES('1',LOAD_FILE('/azerty/qsdfgh.jpeg'))")

(the field which contain the picture is a longblob type)

for the download:

  SQL = "select image from XXX.YYY"
   set RSIDB = conn.Execute(SQL)
   Response.Expires = 0
   Response.Buffer = TRUE
   Response.Clear
   Response.ContentType ="image/JPEG"
   Response.binarywrite RSIDB("image")


And I get this:
ÿØÿàJFIF
ddÿìDucky
ÿîAdobedÀ
ÿÛ†ž&&0$$0,%$$%,;22222;C>>>>>>CCCCCCCCCCCCCC CCCCCCCCCCCCCCC
%%4%%4C4))4CCC?2?CCCCCCCC CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCÿÀ–f
"

à ¿Ã„{










!1AQa"q‘ ¡±2BðÁRbÑr#3




!1Qa"ÿÚ 
?é:

I cheched the content type but it is ok, do you have other ideas???
Thanks in advance

Reference this post:

http://p2p.wrox.com/topic.asp?TOPIC_ID=48962

Also, are you sending anything else to the response stream besides this image? On the page you are trying to display the images to, is there HTML or anything on the page?

"The one language all programmers understand is profanity."

you are right my friend, I put a response.write before that's why the picture did not display.

thanks for your help!

Alex