[thelist] SQL Blob Field Image Error
Annie Phelan
aphelan at norlink.net
Thu Jun 1 11:23:32 2000
ok, now i'm going to beg help :)
I'm working with a SQL blob field, attempting to write images.
Everything is set up as it should be, I've checked and double checked and had
other programmers look at my query, everything is perfect.
Here's the problem: When I try to write the image file from the Blob field, i
get nothing, no error, no source code, nothing. I did a recordcount and got a
result of -1, but when I add a text file to the field and change the contenttype
to application/msword, it writes! My connection works, the query works,
technically, i should NOT be getting a count of -1, and if I do, where's the
error? whats the error? I tried to capture any errors that might be occuring,
but there are none. What am I missing?
Thanks much
Annie
<tip type="SQL" author="Annie Phelan">
When working with images in a SQL Blob field, be sure to define the ContentType
in your query. If not the header will be sent to the HTML file along with the
image and your image will appear as broken.
</tip>