[thelist] SQL Blob Field Image Error

Annie Phelan aphelan at norlink.net
Thu Jun 1 11:49:38 2000


I'm using SQL 7.0 and an ASP (VBscript) query to write.

"Daniel J. Cody" wrote:

> Annie -
>
> What DB are you using? What are you using to write the blob to the DB?
> Bit more technical detail might help :)
>
> .djc.
>
> Annie Phelan wrote:
> >
> > 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?
>
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !