Vise billede istedet for tekst
Jeg vil gerne have den til at vise et billede, som er angivet som et text link i en access kollonne. I øjeblikket viser den kun texten, se:http://www.s-bs.dk/eminem/lyrics/slimshadylp/
Min kode ser pt således ud:
<%
Response.Buffer = True
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath ("../cd.mdb")
Conn.Open DSN
If Request.QueryString("id") <> "" Then
strSQL = "SELECT * FROM Lyrics WHERE (ID = " & Request.QueryString("id") & ")"
Set rs = Conn.Execute(strSQL)
If Request.Cookies("harstemt")("1") <> "Ja" Then
strUrl = rs("Url")
strClicks = rs("Clicks") +1
strSQL1 = "Update Lyrics set "
strSQL1 = strSQL1 & "Clicks= " & strClicks
strSQL1 = strSQL1 & " WHERE (ID = " & Request.QueryString("id") & ")"
Conn.Execute(strSQL1)
Response.Cookies("harstemt")("1") = "Ja"
Response.Cookies("harstemt").Expires = Date+1
Response.Redirect(strUrl)
Else
strSQL11 = "SELECT * FROM Lyrics WHERE ID = " & Request.QueryString("id")
Set rs11 = Conn.Execute(strSQL11)
strURL1 = rs("Url")
Response.Redirect(strURL1)
End If
End If
%>
************************************ og
<%
strSQL = "SELECT * FROM Lyrics ORDER BY Track ASC"
Set rs = Conn.Execute(strSQL)
Response.Write "<table border=""0"" width=""100%"">"
If Not (rs.BOF Or rs.EOF) Then
Do While Not rs.EOF
Response.Write "<tr>"
Response.Write "<td width=""4%"">" & rs("track") & "." & "</td>"
Response.Write "<td width=""61%""><a href=""default.asp?id=" & rs("ID") & """>" & rs("Titel") & "</a></td>"
Response.Write "<td width=""15%"">" & rs("Clicks") & "</td>"
Response.Write "<td width=""20%""><img src=""default.asp?id=" & rs("ID") & """>" & rs("Rating") & "</img></td>"
Response.Write "</tr>"
rs.Movenext
Loop
Response.Write "</table>"
End If
Conn.Close
Set Conn = Nothing
%>
Det er sætningen her der er fejl i.......
Response.Write "<td width=""20%""><img src=""default.asp?id=" & rs("ID") & """>" & rs("Rating") & "</img></td>"
Se eksempel på:
http://www.s-bs.dk/eminem/lyrics/slimshadylp/
Håber i kan hjælpe.
