Link til ID (række)
HejJeg har lavet et udtræk fra en database. Men jeg vil kun have vist en række af gangen - altså 1 ID nr.
Mit kode er således:
<%
Const adOpenKeyset = 1
Const adLockOptimistic = 3
strMode = Request.QueryString("mode")
tempConn = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("news2.mdb") & ";UID=admin;PWD=;"
%>
<html>
<head>
<title>Sociale meddelelser</title>
<link rel="stylesheet" href="style.css"></head>
<body bgcolor="#FFFFFF">
<p class="overskrift">SM - Sociale Meddelelser</p>
<table width="400" border="1" cellpadding="5" bordercolorlight="#C2B26A" bordercolordark="#C2B26A">
<tr bgcolor="#EFEAD6" bordercolor="#C2B26A" class="tabeltext">
<%
Select Case strMode
Case "add"
%>
<%
Case Else
Set myConn = Server.CreateObject("ADODB.Connection")
strSQL = "SELECT * FROM SM"
myConn.Open tempConn
Set rs = myConn.Execute(strSQL)
If Not (rs.BOF Or rs.EOF) Then
Response.Write "<table width=600 border=0 cellpadding=3 cellspacing=0 class=tabeltext>"
Do While Not rs.EOF
Response.Write "<TABLE width=600 border=1 cellpadding=5 bordercolorlight=#C2B26A bordercolordark=#C2B26A><TR><TD><P><SPAN class=normaltext>Afgørelse truffet af: " & rs("Truffet af") & "<BR> " & rs("Journal") & "</SPAN></P></TD>"
Response.Write "<TD><P><SPAN class=normaltext>Afgørelsesdato:" & "<BR>" & rs("Afgoerelsesdato") & "</SPAN></P></TD>"
Response.Write "<TD><P><SPAN class=normaltext>SM udsendelsesdato:" & "<BR>" & rs("Udsendelsesdato") & "</SPAN></P></TD>"
Response.Write "<TD><P><SPAN class=normaltext>Meddelelsesnr.:" & "<BR>" & rs("Meddelelse") & "</SPAN></P></TD></TR></TABLE>"
Response.Write "<P></P><TABLE width=600><P><SPAN class=normaltext>Meddelelse om:" & " " & rs("Om") & "</SPAN></P>"
Response.Write "<P><SPAN class=normaltext>Lov:" & " " & rs("Lov") & "</SPAN></P>"
Response.Write "<P><span class=afsnitsoverskrift>Resumé:" & "<BR></span>" & "<SPAN class=normaltext>" & rs("Resume") & "</P>"
Response.Write "<P><span class=afsnitsoverskrift>Sagsfremstilling:" & "<BR></span>" & "<SPAN class=normaltext>" & rs("Sagsfremstilling") & "</SPAN></P>"
Response.Write "<P><span class=afsnitsoverskrift>Afgørelse:" & "<BR></span>" & "<SPAN class=normaltext>" & rs("Afgoerelse") & "</P>"
rs.MoveNext
Loop
Response.Write "</table>"
Else
Response.Write "<p><font face=arial size=2>Der er endnu ikke nogle nyheder i databasen endnu</font></p>"
End If
myConn.Close
Set myConn = Nothing
End Select
%>
</table>
</body>
</html>
Når jeg linker skriver jeg f.eks.:
<a href="sm.asp?ID=4">SM 4</a>
Men alligevel er det hele databasens indhold der vises. Hvad skal jeg så gøre??
