kontrolere output?
Hvordan laver jeg denne kode om så den tjekker om et felt i min database indeholder data og kun hvis det indeholder data bliver skrevet ud på min side.---------------------------------------------------
<html>
<head>
<title>EP-Produkter Assens A/S</title>
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">
<link rel=\"stylesheet\" href=\"ep.css\">
</head>
<body bgcolor=\"#FFFFFF\" text=\"#000000\" leftmargin=\"0\" topmargin=\"50\" marginwidth=\"0\" marginheight=\"0\">
<table width=\"554\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\">
<tr>
<td align=\"center\">
<%
Set Conn = Server.CreateObject(\"ADODB.Connection\")
DSN = \"DRIVER={Microsoft Access Driver (*.mdb)}; \"
DSN = DSN & \"DBQ=\" & Server.MapPath (\"varer.mdb\")
Conn.Open DSN
strSQL = \"Select * From varer where varenr = \" & Request.Querystring(\"id\")
Set rs = Conn.Execute(strSQL)
Response.Write\"<table border=1 cellspacing=5 width=520><tr><td valign=top><font size=1 face=Verdana, Arial, Helvetica, sans-serif><b>\" & rs(\"Titel\") &\"</b>\"
Response.Write \"<font size=1 face=Verdana, Arial, Helvetica, sans-serif><li>\" & rs(\"Beskrivelse\") & \"<br>\"
Response.Write \"<font size=1 face=Verdana, Arial, Helvetica, sans-serif><br><b>Varenr</b>:<br><b>\" & rs(\"varenummer1\") & \"</b> \" & rs(\"tekst1\") & \"<br><b>\" & rs(\"varenummer2\") & \"</b> \" & rs(\"tekst2\") & \"<br><b>\" & rs(\"varenummer3\") & \"</b> \" & rs(\"tekst3\") & \"<br><b>\" & rs(\"varenummer4\") & \"</b> \" & rs(\"tekst4\") &\"<br><b>\" & rs(\"varenummer5\") & \"</b> \" & rs(\"tekst5\") &\"<br><b>\" & rs(\"varenummer6\") & \"</b> \" & rs(\"tekst6\") &\"<br><b>\" & rs(\"varenummer7\") & \"</b> \" & rs(\"tekst7\") &\"<br><b>\" & rs(\"varenummer8\") & \"</b> \" & rs(\"tekst8\") &\"<br><b>\" & rs(\"varenummer9\") & \"</b> \" & rs(\"tekst4\") &\"<br><b>\" & rs(\"varenummer9\") & \"</b> \" & rs(\"tekst10\") &\"<br><b>\" & rs(\"varenummer10\") & \"</b> \" & rs(\"tekst11\") &\"<br><b>\" & rs(\"varenummer11\") & \"</b> \" & rs(\"tekst11\") &\"<br><b>\" & rs(\"varenummer12\") & \"</b> \" & rs(\"tekst12\") &\"\"
Response.Write \"<td align=right valign=top>\"
Response.Write \"<img src=Images/\" & rs(\"Images\")& \" class=border> \"
Response.Write \"</td>\"
Response.Write \"</td></tr></table>\"
Conn.Close
Set Conn = Nothing
%>
</td>
<tr>
<td align=\"center\"><font size=1 face=Verdana, Arial, Helvetica, sans-serif><a href=\"tilbehor.asp\" target=\"mainFrame\">Retur til listen</a></td>
</tr>
</table>
</body>
</html>
