Access Image Data Type from ASP

Hi how to i access image datatype using ASP
my code throws type mismatch error. any suggestion to correct it
Set sRS1 = Server.CreateObject("ADODB.Recordset")
sRS1.LockType = 3
sRS1.CursorType = 3
sRS1.CursorLocation = 3
sql1 = "select image1 from tbl where id=100"
sRS1.open sql1,Con
...
...
response.write sRS1(0)
...
...
Thanks in advance.
-dnkHi
Good stuff
http://www.aspfaq.com/show.asp?id=2149
"DNKMCA" <dnk@.msn.com> wrote in message
news:ugVCHlvnFHA.3960@.TK2MSFTNGP12.phx.gbl...
> Hi how to i access image datatype using ASP
> my code throws type mismatch error. any suggestion to correct it
> Set sRS1 = Server.CreateObject("ADODB.Recordset")
> sRS1.LockType = 3
> sRS1.CursorType = 3
> sRS1.CursorLocation = 3
> sql1 = "select image1 from tbl where id=100"
> sRS1.open sql1,Con
> ...
> ...
> response.write sRS1(0)
> ...
> ...
>
> Thanks in advance.
> -dnk
>