[thelist] Re: SQL Blob Field Image Error (Code)

Look at http://www.4guysfromrolla.com/webtech/060100-1.shtml they're
discussing this.

Simon

-----Original Message-----
From: thelist-admin@lists.evolt.org
[mailto:thelist-admin@lists.evolt.org]On Behalf Of Annie Phelan
Sent: Friday, 2 June 2000 00:09
To: thelist@lists.evolt.org
Subject: [thelist] Re: SQL Blob Field Image Error (Code)


Here's the query:

     Response.Expires = 0
     Response.Buffer = TRUE
     Response.Clear
     Response.ContentType = "image/gif"

     Set cn = Server.CreateObject("ADODB.Connection")
     cn.Open "DSN=imgDB;UID=sa;PWD=;DATABASE=img"
     Set rs = cn.Execute("SELECT img FROM img_01 WHERE img_id='0001'")
     Response.BinaryWrite rs("img")
     Response.End

and I call it like so
<IMG SRC="SHOWIMG.ASP">
Very simple




Scott Dexter wrote:

> let's see the code, please =)
>
> sgd
> --
> think safely
>
> > -----Original Message-----
> > From: Annie Phelan [mailto:aphelan@norlink.net]
> > Sent: Thursday, June 1, 2000 10:51 AM
> > To: thelist@lists.evolt.org
> > Subject: Re: [thelist] SQL Blob Field Image Error
> >
> >
> > 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 :)
> > >
>
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !


---------------------------------------
For unsubscribe and other options, including
the Tip Harvester and archive of TheList go to:
http://lists.evolt.org Workers of the Web, evolt !