I tabellen BMT2 har jeg Id, KeyID og Key
Jeg kan ikke se hvor jeg linker forkert i min kode hvis det er tilføllet
<%@LANGUAGE="JavaScript"%>
<html>
<head>
<meta http-equiv="Content-Type"
content="text/html; charset=iso-8859-1">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<title>Landkort over specialer og kompetencer indenfor medicoområdet</title>
</head>
<body>
<% Response.Write("SELECT BMT2 WHERE = " + Request.Form("Value1") )
%>
<p align="center"> <%// =Request.queryString("Nøgle") %>
<% // =Request.queryString("Nøgle").replace(/@/g,"<br>") %>
<% tmp = Request.queryString("Value1")+"" %>
<%= tmp.replace(/£/g,"<br>") %>
<p>
<% Response.Write("Value1") %>
<body>
<form action="side4.asp" method="submit">
<p align="center">
<font size="3">
<select name="KEY2">
<%
//------------CONNECT TO DB--------------------------------
con = Server.CreateObject("ADODB.Connection");
con.Open(Application('db1_ConnectionString'));
//con.Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\\db1.mdb");
//------------EXTRACT DATA-------------------------------
var Value1 = Request("Value1");
RS= con.Execute("SELECT Key FROM BMT2 WHERE KeyID = " + Request.Form("Value1") + ""); //" & Request.Form("Value1") & "")
//RS= con.Execute("SELECT * FROM BMT2 WHERE Id = " + Request.Form("Value1") + "");
var Keys; var Id;
while(!RS.EOF)
{
Keys= RS("Key");
Id = RS("KeyID");
//----------DISPLAY HTML
%>
<option value= <" <% =id %> "> <% =Keys %> </option>
<%
//-----------------------
RS.MoveNext;
}
//------------CLOSE DB
RS.Close;
con.close;
//------------END OF DB STUFF %>;
</select></font><input type="submit" name="B2" value="Søg">
</p>
</form>
</p>
</body>
</html>
