Access Image Data Type from ASP

microsoft.public.sqlserver.programming

12 Aug 2005 4:50 AM

DNKMCA

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

12 Aug 2005 4:56 AM

Uri Dimant

Hi
Good stuff
http://www.aspfaq.com/show.asp?id=2149

Show quote

"DNKMCA" <d**@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
>
>