databaseobjekter til ny side???
hvordan får jeg objRS(0) fra det bestemte tabelfelt hvor jeg trykker submitknappen med over til vis.asp???Dim objConn, objRS, strQ, strConnection
Set objConn = Server.CreateObject(\"ADODB.Connection\")
strConnection = \"Data Source=navi;\"
objConn.Open strConnection
Set objRS = Server.CreateObject(\"ADODB.Recordset\")
Set objRS.ActiveConnection = objConn
strQ = \"SELECT Vare.Nummer, Vare.Beskrivelse, Vare.Basisenhed, Vare.Salgspris \"
strQ = strQ & \"FROM Vare Vare \"
strQ = strQ & \"WHERE (Vare.Nummer>\'69000\') \"
strQ = strQ & \"ORDER BY Vare.Nummer \"
\' Response.Write strQ
objRS.Open strQ
%>
<html>
<head><title>Produkter</title></head>
<body bgcolor=#ffffff>
<table border=1><tr>
<th align=\"left\">Varenummer</th>
<th align=\"left\">Vare</th>
<th align=\"left\">enhed</th>
<th align=\"left\">Pris</th>
<th align=\"left\">Antal</th>
</tr>
<%
\' objRS(4) = \"1\"
While Not objRS.EOF
\' Response.Write(\"<script> top.right.location = \'vis.asp?id=\' </script>\")
Response.Write \"<tr><td>\" & objRS(0) & \"</td>\"
Response.Write \"<td>\"
Response.Write Server.HtmlEncode(objRS(1)) &\"</a></td>\"
Response.Write \"<td>\" & objRS(2) & \"</td>\"
Response.Write \"<td>\" & objRS(3) & \",00</td>\"
Response.Write \"<td><input type=\"\"Text\"\" name=\"\"antal\"\" value=\"\"1\"\" size=\"\"3\"\">\"
Response.write \"<input type=\"\"Submit\"\" name=\"\"Tilfoej\"\" value=\"\"Tilføj\"\" a href=\"\"vis.asp?varenummer=\"\" & objRS(0) & >\"
Response.Write \"<input type=\"\"Submit\"\" name=\"\"Fjern\"\" value=\"\"Fjern\"\"></td>\"
Response.Write \"</tr>\" & vbCrLf
objRS.MoveNext
Wend
objRS.close
objConn.close
Set objRS = Nothing
Set objConn = Nothing
%>
</table>
</body>
</html><%
end function
