her er lige resten af scriptet.. det kan være jeg har udelagt noget vigtigt
<%@ LANGUAGE="VBSCRIPT"%>
<% Response.Expires = 0 %>
<!-- #include file="html.inc" -->
<%
strID = request.QueryString("ID")
function GetFileName
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
if objFSO.FileExists(Server.MapPath(strID & ".gif")) then
GetFileName = strID & ".gif"
else
if objFSO.FileExists(Server.MapPath(strID & ".jpg")) then
GetFileName = strID & ".jpg"
else
GetFileName = "Does not exist"
end if
end if
Set objFile = Nothing
Set objSFO = Nothing
end function
sub VisInfo
Response.Write("<html><head><LINK HREF='styles.css' REL='stylesheet' TYPE='text/css'></head>")
Response.Write("<body><h3><p align='center'>The Picture</p></h3>")
Response.Write("<hr width='90%' align='center'>")
Response.Write("<form method='POST' action='default.asp'>")
Response.Write("<div align='center'><table>")
Response.Write("<table width='90%'>")
' *** Submitknap bestemmer om der skal postes eller fortrydes ***
Response.Write("<tr>")
ListHeader "Title", "20%"
RowInputStr "EditTitel", RS("Titel"), 30, "80%"
Response.Write("</tr>")
Response.Write("<tr>")
ListHeader "From", "20%"
RowInputStr "EditNavn", RS("Navn"), 50, "80%"
Response.Write("</tr>")
Response.Write("<tr>")
ListHeader "Added", "20%"
RowInputStr "EditDato", RS("Dato"), 50, "80%"
Response.Write("</tr>")
Response.Write("</table>")
' *** Knapper i bunden ***
Response.Write("<hr width='90%' align='center'>")
Response.Write("<table width='90%'>")
NewSmallButton "submit", "submit", "Back"
Response.Write("</table>")
Response.Write("</table></div>")
Response.Write("</form>")
' *** Vis billede ***
Response.Write("<div align='center'>")
Response.Write "<img src='" & "
http://www.url.dk" & "/" & GetFileName & "'>"
Response.Write("</div>")
end sub
' Opret ADO-connection
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("info.mdb")
' Opret RecordSet
Set rs = Server.CreateObject("ADODB.RecordSet")
' Hent første post i tabellen tabelnavn
rs.Open "SELECT * FROM info where ID=" & strID, myConn
VisInfo
' Luk det hele igen
rs.Close
myConn.Close
Set rs = Nothing
Set myConn = Nothing
Response.Write("</body></html>")
%>