|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
July 8th, 2003, 07:56 AM
|
|||
|
|||
retrieving mysql blob using ASP (vbscript)
Hi, I am accessing a mysql table which contains several field- types such as int, varchar and BLOB.
I have no trouble reading the non-binary fields using an ADODB object, but I cannot access the content of the text blobs (I see cryptical binary code instead)... Anyone got a solution? Thx in advance!
|
|
#2
July 8th, 2003, 08:03 AM
|
||||
|
||||
|
Yes, if you simply do a normal response.write from your DB field, you will only see garbled data, as that is exactly what is being stored.
You need to "stream" the data out, and set the page "content-type". Google, or http://www.zdnet.com.au/builder/pro...20274969,00.htm
|
|
#4
October 17th, 2005, 05:30 PM
|
|||
|
|||
|
retrieving mysql blob using ASP (vbscript)
i was having the same type of trouble, but have gotten around the issue (response.binarywrite did the trick) however i am now only getting a fraction of the blob to output (1.47kb of a 998kb file) any idea what may be causing the response.binarywrite to truncate the file?
Jason C. Kelley
|
|
| Viewing: Dev Articles Community Forums > Databases > MySQL Development > retrieving mysql blob using ASP (vbscript) |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
