Hi, i have used your code for displaying images from the database, and adapted it. i do not have any compiler errors, but it is not workin.
my code is as follows:-
<%
Response.buffer = True
connStr = "driver={MySQL}; server=localhost; uid=sxb00u; pwd=sheetal; database=sxb00u"
Dim rs
Set rs = Server.CreateObject("ADODB.Recordset")
Dim sql_select
sql_select = "SELECT imagedata,content_type FROM image WHERE username='sheetal2' "
rs.Open sql_select, connStr,2, 4
If Not rs.EOF Then
Response.ContentType = rs("content_type")
if path is root
Response.Write "<img src=""&rs("imagedata")&"" border=""0"">"
if path is not root
Response.Write "<img src=""location\"&rs("imagedata")&"" border=""0"">"
End If
rs.Close
Set rs=Nothing
%>
I was wondering if you had any idea why it is now working.
Thank you
