Jeg er ikke så færm til det asp. Kan du ikke prøve at skrive det ind i min kode. For det virker ikke rigtigt for mig. Altså det med:
request.form("Kursusdato1") request.form("Kursusdato2") request.form("Kursusdato3")
På modtager siden. Du må også gerne ændre min form action. Min kode ser således ud nu:
<% mode = request("mode") %>
<%
Const adOpenKeyset = 1
Const adLockOptimistic = 3
strMode = Request.QueryString("mode")
tempConn = "PROVIDER=MSDASQL;DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("it.mdb") & ";UID=admin;PWD=;"
If Request.Form("Gem") <> "" Then
strKursusnavn = Trim(Request.Form("Kursusnavn"))
strKursusdato = Trim(Request.Form("Kursusdato"))
strKursusid = Trim(Request.Form("Kursusid"))
strInitialer = Trim(Request.Form("Initialer"))
strDeltagernavn = Trim(Request.Form("Deltagernavn"))
strLokalnummer = Trim(Request.Form("Lokalnummer"))
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM tilmelding WHERE (TilmeldingID = 0)"
rs.Open strSQL, tempConn, adOpenKeyset, adLockOptimistic
If (rs.BOF Or rs.EOF) Then
rs.AddNew
rs("Kursusnavn") = strKursusnavn
rs("Kursusdato") = strKursusdato
rs("Kursusid") = strKursusid
rs("Initialer") = strInitialer
rs("Deltagernavn") = strDeltagernavn
rs("Lokalnummer") = strLokalnummer
rs.Update
End If
rs.Close
Set rs = Nothing
End If
%>
<html>
<head>
<title>AIDA Intranet</title>
<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript">
<!--
NS4 = (document.layers);
IE4 = (document.all);
ver4 = (NS4 || IE4);
isMac = (navigator.appVersion.indexOf("Mac") != -1);
isMenu = (NS4 || (IE4 && !isMac));
function popUp(){return};
function popDown(){return};
if (!ver4) event = null;
//-->
</SCRIPT>
<SCRIPT LANGUAGE="JavaScript1.2" TYPE="text/javascript">
<!--
if (isMenu) {
menuVersion = 3;
menuWidth = 130;
childOverlap = 50;
childOffset = 5;
perCentOver = null;
secondsVisible = .5;
fntCol = "#000000";
fntSiz = "10";
fntBold = false;
fntItal = false;
fntFam = "sans-serif";
backCol = "#DDDDDD";
overCol = "#FFCCCC";
overFnt = "#000000";
borWid = 0;
borCol = "black";
borSty = "solid";
itemPad = 3;
imgSrc = "../images/pil.gif";
imgSiz = 10;
separator = 1;
separatorCol = "red";
isFrames = false; // <-- IMPORTANT
navFrLoc = "left";
keepHilite = true;
NSfontOver = true;
clickStart = false;
clickKill = false;
}
//-->
</SCRIPT>
<SCRIPT LANGUAGE="JavaScript1.2">
<!--
if (isMenu) {
document.write("<SCR" + "IPT LANGUAGE='JavaScript1.2' SRC='../hierArrays.js'><\/SCR" + "IPT>");
document.write("<SCR" + "IPT LANGUAGE='JavaScript1.2' SRC='../hierMenus.js'><\/SCR" + "IPT>");
}
//-->
</SCRIPT>
<style type="text/css">
<!--
.tabeltext { font-family: Arial, Helvetica, sans-serif; font-size: 11px; line-height: normal}
-->
</style>
<link rel="stylesheet" type="text/css" href="../style.css">
</head>
<body bgcolor="#000000">
<table width="700" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" align="center">
<tr>
<td><img src="../images/top_logo1.jpg" width="251" height="61"><img src="../images/top_logo2.gif" width="304" height="61"><img src="../images/top_logo3.gif" width="145" height="61"><br>
<table width="700" border="0" cellpadding="0" cellspacing="0" name="Help line" height="18">
<tr>
<td width="259" bgcolor="#C2B26A" height="18">
<div align="center"><font face="Arial, Helvetica, sans-serif" size="2">Den
Sociale Ankestyrelses Intranet</font></div>
</td>
<td width="224"><img src="../images/rh_corner.gif" width="5" height="19" align="absbottom"></td>
<td width="22"> </td>
<td width="37" bgcolor="#C2B26A"><img src="../images/lh_corner.gif" width="5" height="18"></td>
<td width="49" bgcolor="#C2B26A">
<div align="center" class=text><a href="
http://pc077/aida2/index.htm">Hjem</a></div> </td>
<td width="61" bgcolor="#C2B26A">
<div align="center" class=text><a href="../links/index.htm">Links</a></div>
</td>
<td width="48" bgcolor="#C2B26A">
<div align="center" class=text><a href="../help/index.htm">Hjælp</a></div>
</td>
</tr>
</table>
</td>
</tr>
<tr valign="top">
<td height="182">
<table width="700" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="128" bgcolor="#EFEAD6" valign="top">
<p><a href="#" onMouseOver="popUp('elMenu1',event)"
onMouseOut="popDown('elMenu1')"><img src="../images/menu_but1.jpg" width="128" height="44" border="0"></a><br>
<a href="#" onMouseOver="popUp('elMenu2',event)"
onMouseOut="popDown('elMenu2')"><img src="../images/menu_but2.jpg" width="128" height="23" border="0"></a><br>
<a href="#" onMouseOver="popUp('elMenu3',event)"
onMouseOut="popDown('elMenu3')"><img src="../images/menu_but8.jpg" width="128" height="23" border="0"></a><br>
<a href="#" onMouseOver="popUp('elMenu4',event)"
onMouseOut="popDown('elMenu4')"><img src="../images/menu_but3.jpg" width="128" height="23" border="0"></a><br>
<a href="#" onMouseOver="popUp('elMenu5',event)"
onMouseOut="popDown('elMenu5')"><img src="../images/menu_but4.jpg" width="128" height="23" border="0"></a><br>
<a href="#" onMouseOver="popUp('elMenu6',event)"
onMouseOut="popDown('elMenu6')"><img src="../images/menu_but5.jpg" width="128" height="23" border="0"></a><br>
<a href="#" onMouseOver="popUp('elMenu7',event)"
onMouseOut="popDown('elMenu7')"><img src="../images/menu_but6.jpg" width="128" height="23" border="0"></a><br>
<a href="#" onMouseOver="popUp('elMenu8',event)"
onMouseOut="popDown('elMenu8')"><img src="../images/menu_but7.jpg" width="128" border="0"></a></p>
<form method="post" action="">
<div align="center"><font face="Arial, Helvetica, sans-serif" size="2" color="#C2B26A">
</font>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<div align="center"><font face="Arial, Helvetica, sans-serif" size="2" color="#C2B26A"><b><font color="#000000">Simpel
søgning</font></b></font></div>
</td>
</tr>
<tr>
<td>
<div align="center">
<input type="text" name="textfield" size="14">
</div>
</td>
</tr>
</table>
</div>
</form>
</td>
<td valign="top" colspan="2" name="editable region">
<table width="450" border="0" cellpadding="10">
<tr>
<td>
<% if mode = "tilmeld" Then %>
<%
Select Case strMode
Case "add"
%>
<%
Case Else
Set myConn = Server.CreateObject("ADODB.Connection")
strSQL = "SELECT * FROM Kursus WHERE (KursusID = " & Request.QueryString("KursusID") & ")"
myConn.Open tempConn
Set rs = myConn.Execute(strSQL)
If Not (rs.BOF Or rs.EOF) Then
Response.Write "<form method=post action=kurser_tilmeld.asp?kursusid=" & rs("kursusID") & "><table width=450 border=0><tr>"
Do While Not rs.EOF
Response.Write "<td class=subheader>Valgt kursus:<br><input type=text name=Kursusnavn value=""" & rs("Kursusnavn") & """></td>"
Response.Write "<td><span class=subheader>Kursus dato:<br></span><span class=text><select name=Kursusdato><option>Vælg en dato" & "</span></option>"
Response.Write "<option value=rs(""Kursusdato1"")>" & rs("Kursusdato1") & "</option>"
Response.Write "<option value=rs(""Kursusdato2"")>" & rs("Kursusdato2") & "</option>"
Response.Write "<option value=rs(""Kursusdato3"")>" & rs("Kursusdato3") & "</option>"
Response.Write "<option value=rs(""Kursusdato4"")>" & rs("Kursusdato4") & "</option>"
Response.Write "<option value=rs(""Kursusdato5"")>" & rs("Kursusdato5") & "</option>"
Response.Write "<option value=rs(""Kursusdato6"")>" & rs("Kursusdato6") & "</option>"
Response.Write "<option value=rs(""Kursusdato7"")>" & rs("Kursusdato7") & "</option>"
Response.Write "<option value=rs(""Kursusdato8"")>" & rs("Kursusdato8") & "</option>"
Response.Write "<option value=rs(""Kursusdato9"")>" & rs("Kursusdato9") & "</option>"
Response.Write "<option value=rs(""Kursusdato10"")>" & rs("Kursusdato10") & "</option>"
Response.Write "<input type=hidden name=kursusid value=" & rs("kursusID") & ">"
rs.MoveNext
Loop
Response.Write "</td></select>"
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
%>
</tr>
<tr>
<td class=subheader>Deltagernavn:<br>
<input type="text" name="Deltagernavn">
</td>
<td class=subheader>Initialer:<br>
<input type="text" name="Initialer">
</td>
</tr>
<tr>
<td class=subheader>Lokalnummer:<br>
<input type="text" name="Lokalnummer">
</td>
<td></td>
</tr>
<tr><td colspan=2><input type="submit" value="Gem" name="Gem"></td></tr>
</table>
</form>
<%
Set myConn = Server.CreateObject("ADODB.Connection")
strSQL = "SELECT top 4 * FROM tilmelding WHERE (kursusID = " & Request.QueryString("kursusid") & ")"
myConn.Open tempConn
Set rs = myConn.Execute(strSQL)
If Not (rs.BOF Or rs.EOF) Then
Response.Write "<table width=500 border=0><tr class=subheader><td width=170>Kursus</td>" & "<td width=70>Dato</td>" & "<td width=60>Initialer</td>" & "<td width=120>Deltagere</td>" & "<td width=80>Lokalnummer</td></tr>"
Do While Not rs.EOF
Response.Write "<tr class=text><td>" & rs("Kursusnavn") & "</td>"
Response.Write "<td>" & rs("kursusdato") & "</td>"
Response.Write "<td>" & rs("Initialer") & "</td>"
Response.Write "<td>" & rs("deltagernavn") & "</td>"
Response.Write "<td>" & rs("lokalnummer") & "</td></tr>"
rs.MoveNext
Loop
Response.Write "</table>"
Else
Response.Write "<p><font face=arial size=2>Der er ingen tilmeldte</font></p>"
End If
myConn.Close
Set myConn = Nothing
%>
<% end if %>
<% if mode = "" then %>
<%
'###############FORSINKELSE
Sub TLdelaySec(DelaySeconds)
SecCount = 0
Sec2 = 0
While SecCount < DelaySeconds + 1
Sec1 = Second(Time())
If Sec1 <> Sec2 Then
Sec2 = Second(Time())
SecCount = SecCount + 1
End If
Wend
End Sub
TLdelaySec(2)
'###############FORSINKELSE
Set myConn = Server.CreateObject("ADODB.Connection")
strSQL = "SELECT TOP 4 * FROM tilmelding WHERE ID = " & request("kursusID") & " AND kursusdato = '" & request.form("Kursusdato") & "';"
myConn.Open tempConn
Set rs = myConn.Execute(strSQL)
If Not (rs.BOF Or rs.EOF) Then
Response.Write "<table width=500 border=0><tr class=subheader><td width=200>Kursus</td>" & "<td width=50>Dato</td>" & "<td width=50>Initialer</td>" & "<td width=120>Deltagere</td>" & "<td width=80>Lokalnummer</td></tr>"
Do While Not rs.EOF
Response.Write "<tr class=text><td>" & rs("Kursusnavn") & "</td>"
Response.Write "<td>" & rs("kursusdato") & "</td>"
Response.Write "<td>" & rs("Initialer") & "</td>"
Response.Write "<td>" & rs("deltagernavn") & "</td>"
Response.Write "<td>" & rs("lokalnummer") & "</td></tr>"
rs.MoveNext
Loop
Response.Write "</table>"
Else
Response.Write "<p><font face=arial size=2>Der er ingen tilmeldte</font></p>"
End If
myConn.Close
Set myConn = Nothing
%>
<% end if %>
<a href=kurser.asp><span class=text>Tilbage til kursusoversigt </span><img src=../images/link.gif border=0></a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr bgcolor="#C2B26A">
<td height="16">
<p align="center"></p>
</td>
</tr>
</table>
</body>
</html>