Hvad er fejlen...og gider du at rette den?
Hejsa!Jeg har problemer med en asp-fil...den vil ikke som jeg vil, den skal sende nogle data ned i en database når der trykkes på knappen, men den melder fejl...:-[
Jeg kan godt sende filerne og databasen til jer, bare skriv email adr - her
Her kommer først formen: (Lang)
<%
Dim Connect, OnUngdom, OnMont
Set Connect = Server.CreateObject(\"ADODB.Connection\")
Connect.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath (\"../Databaser/HP.mdb\")
%>
<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0//EN\">
<HTML>
<HEAD>
<TITLE>Lunderskov Boldklub - Ungdomsstævne</TITLE>
<META NAME=\"Generator\" CONTENT=\"Stone\'s WebWriter 3\">
</HEAD>
<BODY BGCOLOR=\"#FFFFFF\" TEXT=\"#000000\" LINK=\"#0000FF\" VLINK=\"#660066\" ALINK=\"#FF0000\">
<CENTER><H1>Tilmelding til ungdomsstævne</H1></CENTER>
<HR>
Udfyld venligst nedenstående tilmeldingsskema
<BR>
<FORM action=\'Ungdom.asp\' NAME=\"Ungdom\" METHOD=\"POST\">
<BR>
<!-- Kluboplysninger -->
<TABLE BORDER=\"0\">
<TR>
<TD>Klub: </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"40\" MAXLENGTH=\"40\" NAME=\"Klub\"></TD>
<TD></TD>
</TR>
<TR>
<TD>Spilledragt:</TD>
<TD></TD>
<TD></TD>
</TR>
<TR>
<TD>Trøje:
</TD>
<TD><INPUT TYPE=\"text\" SIZE=\"10\" MAXLENGTH=\"10\" NAME=\"Troeje\"> Bukser: <INPUT TYPE=\"text\" SIZE=\"10\" MAXLENGTH=\"10\" NAME=\"Bukser\"></TD>
<TD></TD>
</TR>
<TD>Alternativ spilledragt:</TD>
<TD></TD>
<TD></TD>
</TR>
<TR>
<TD>Trøje:
</TD>
<TD><INPUT TYPE=\"text\" SIZE=\"10\" MAXLENGTH=\"10\" NAME=\"ATroeje\"> Bukser: <INPUT TYPE=\"text\" SIZE=\"10\" MAXLENGTH=\"10\" NAME=\"ABukser\"></TD>
<TD></TD>
</TR>
<TR>
<TD><BR><TD>
<TD><TD>
</TR>
<TR>
<TD>Kontakt person:</TD>
<TD><INPUT TYPE=\"text\" SIZE=\"40\" MAXLENGTH=\"40\" NAME=\"Kontakt\"></TD>
<TD></TD>
</TR>
<TR>
<TD>Tlf.:
</TD>
<TD><INPUT TYPE=\"text\" SIZE=\"8\" MAXLENGTH=\"8\" NAME=\"Tlf\"> Fax: <INPUT TYPE=\"text\" SIZE=\"8\" MAXLENGTH=\"8\" NAME=\"Fax\"></TD>
<TD></TD>
</TR>
<TR>
<TD>Adresse:</TD>
<TD><INPUT TYPE=\"text\" SIZE=\"40\" MAXLENGTH=\"40\" NAME=\"Adr\"></TD>
<TD></TD>
</TR>
<TR>
<TD>Postnr:</TD>
<TD><INPUT TYPE=\"text\" SIZE=\"4\" MAXLENGTH=\"4\" NAME=\"Postnr\"> By: <INPUT TYPE=\"TEXT\" SIZE=\"25\" MAXLENGTH=\"25\" NAME=\"By\"></TD>
<TD></TD>
</TR>
<TR>
<TD>Email:</TD>
<TD><INPUT TYPE=\"text\" SIZE=\"40\" MAXLENGTH=\"40\" NAME=\"Email\"></TD>
<TD></TD>
</TR>
<TD>Ankomst:
</TD>
<TD><SELECT SIZE=\"1\" NAME=\"Dag\" TYPE=\"TEXT\">
<OPTION TYPE=\"text\">Fredag
<OPTION TYPE=\"text\">Lørdag
</SELECT>
kl. (tt:mm)<INPUT TYPE=\"text\" SIZE=\"5\" MAXLENGTH=\"5\" NAME=\"Tid\"></TD>
<TD></TD>
</TR>
</TABLE>
<BR><BR>
<!-- Selve hold tilmeldingen -->
Herunder bedes I indtaste hvilke rækker i ønsker at tilmelde jeres hold i.
<BR>
Desuden vil vi gerne vide hvor mange af disse hold, der spiller i A og B rækken til dagligt.
<BR><BR><BR>
<TABLE BORDER=\"0\">
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT * FROM Raekker WHERE Raekke=\'Miniput\'\")
%>
<TD>Miniput, 7-mands</TD>
<TD>........</TD>
<TD><%=OnUngdom(\"Aargang\")%></TD>
<TD>Række A </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"MP7A\"></TD>
<TD>Række B</TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"M7B\"></TD>
</TR>
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT * FROM Raekker WHERE Raekke=\'Lilleput\'\")
%>
<TD>Lilleput, 11-mands</TD>
<TD>........</TD>
<TD><%=OnUngdom(\"Aargang\")%></TD>
<TD>Række A </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"L11A\"></TD>
<TD>Række B </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"L11B\"></TD>
</TR>
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT * FROM Raekker WHERE Raekke=\'Drenge\'\")
%>
<TD>Drenge, 11-mands</TD>
<TD>........</TD>
<TD><%=OnUngdom(\"Aargang\")%></TD>
<TD>Række A </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"D11A\"></TD>
<TD>Række B </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"D11B\"></TD>
</TR>
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT * FROM Raekker WHERE Raekke=\'Junior\'\")
%>
<TD>Junior, 11-mands</TD>
<TD>........</TD>
<TD><%=OnUngdom(\"Aargang\")%></TD>
<TD>Række A </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"J11A\"></TD>
<TD>Række B </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"J11B\"></TD>
</TR>
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT * FROM Raekker WHERE Raekke=\'Ynglinge\'\")
%>
<TD>Ynglinge, 11-mands</TD>
<TD>........</TD>
<TD><%=OnUngdom(\"Aargang\")%></TD>
<TD>Række A </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"Y11A\"></TD>
<TD>Række B </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"Y11B\"></TD>
</TR>
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT * FROM Raekker WHERE Raekke=\'Miniputpiger\'\")
%>
<TD>Miniputpiger, 7 mands</TD>
<TD>........</TD>
<TD><%=OnUngdom(\"Aargang\")%></TD>
<TD>Række A </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"MPA\"></TD>
<TD>Række B </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"MPB\"></TD>
</TR>
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT * FROM Raekker WHERE Raekke=\'Lilleputpiger\'\")
%>
<TD>Lilleputpiger, 7-mands</TD>
<TD>........</TD>
<TD><%=OnUngdom(\"Aargang\")%></TD>
<TD>Række A </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"LPA\"></TD>
<TD>Række B </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"LPB\"></TD>
</TR>
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT * FROM Raekker WHERE Raekke=\'Piger\'\")
%>
<TD>Piger, 11 mands</TD>
<TD>........</TD>
<TD><%=OnUngdom(\"Aargang\")%></TD>
<TD>Række A </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"PA\"></TD>
<TD>Række B </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"PB\"></TD>
</TR>
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT * FROM Raekker WHERE Raekke=\'Juniorpiger\'\")
%>
<TD>Juniorpiger, 11-mands</TD>
<TD>........</TD>
<TD><%=OnUngdom(\"Aargang\")%></TD>
<TD>Række A </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"JPA\"></TD>
<TD>Række B </TD>
<TD><INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"JPB\"></TD>
</TR>
</TABLE>
<BR>
<BR><BR>
<B>Forplejning</B>
<BR><BR>
I bedes venligst oplyse hvilken type forplejning I ønsker i forbindelse med Lunderskov Cup
<BR>
<BR>
<TABLE BORDER=\"0\">
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT * FROM Priser WHERE Beskrivelse=\'Middag\'\")
%>
<TD>Fredag middag </TD>
<TD>Antal <INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"FM\"></TD>
<%Set OnMont = Connect.Execute (_
\"SELECT * FROM MontEnhed\")
%>
<TD> á <%=OnMont(\"MontEnhed\")%> <%=OnUngdom(\"Pris\")%></TD>
</TR>
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT Pris FROM Priser WHERE Beskrivelse=\'Morgen\'\")
%>
<TD>Lørdag morgenmad </TD>
<TD>Antal <INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"LMO\"></TD>
<TD> á <%=OnMont(\"MontEnhed\")%> <%=OnUngdom(\"Pris\")%></TD>
</TR>
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT * FROM Priser WHERE Beskrivelse=\'Frokost\'\")
%>
<TD>Frokost </TD>
<TD>Antal <INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"LF\"></TD>
<TD> á <%=OnMont(\"MontEnhed\")%> <%=OnUngdom(\"Pris\")%></TD>
</TR>
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT * FROM Priser WHERE Beskrivelse=\'Middag\'\")
%>
<TD>Middag </TD>
<TD>Antal <INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"LMI\"></TD>
<TD> á <%=OnMont(\"MontEnhed\")%> <%=OnUngdom(\"Pris\")%></TD>
</TR>
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT * FROM Priser WHERE Beskrivelse=\'Morgen\'\")
%>
<TD>Søndag morgenmad </TD>
<TD>Antal <INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"SMO\"></TD>
<TD> á <%=OnMont(\"MontEnhed\")%> <%=OnUngdom(\"Pris\")%></TD>
</TR>
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT * FROM Priser WHERE Beskrivelse=\'Frokost\'\")
%>
<TD>Frokost </TD>
<TD>Antal <INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"SF\"></TD>
<TD> á <%=OnMont(\"MontEnhed\")%> <%=OnUngdom(\"Pris\")%></TD>
</TR>
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT * FROM Priser WHERE Beskrivelse=\'Middag\'\")
%>
<TD>Middag </TD>
<TD>Antal <INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"SMI\"></TD>
<TD>á <%=OnMont(\"MontEnhed\")%> <%=OnUngdom(\"Pris\")%></TD>
</TR>
<TR>
<%Set OnUngdom = Connect.Execute (_
\"SELECT * FROM Priser WHERE Beskrivelse=\'Frokostpakke\'\")
%>
<TD>Frokostpakke til rejse </TD>
<TD>Antal <INPUT TYPE=\"text\" SIZE=\"2\" MAXLENGTH=\"2\" NAME=\"FP\"></TD>
<TD>á <%=OnMont(\"MontEnhed\")%> <%=OnUngdom(\"Pris\")%></TD>
</TR>
</TABLE>
<BR>
<BR>
<INPUT TYPE=\"submit\" VALUE=\"Tilmeld\" NAME=\"Tilmeld\"> <INPUT TYPE=\"reset\" VALUE=\"Rens felter\" NAME=\"Reset\">
</FORM>
</BODY>
</HTML>
Og så kommer asp-filen der skal hælde i databasen her: (ikke så lang lang)
<TITLE>Ungdomstilmelding</TITLE>
<%
Dim Connect, OnTilmelding
Set Connect = Server.CreateObject(\"ADODB.Connection\")
Connect.Open \"DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=\" & Server.MapPath (\"../Databaser/Tilmelding.mdb\")
%>
<%
Set OnTilmelding = Connect.Execute (\"INSERT INTO Ungdom (Klub, Troeje, Bukser, ATroeje, ABukser, kontakt, Tlf, Fax, Adr, Postnr, Bynavn, Email, Dag, Tid, M7A, M7B, L11A, L11B, D11A, D11B, J11A, J11B, Y11A, Y11B, MPA, MPB, LPA, LPB, PA, PB, JPA, JPB, FM, LMO, LF, LMI, SMO, SF, SMI, FP) VALUES (\'\"+ Request.Form(\"Klub\")+\"\',\'\"+ Request.Form(\"Troeje\")+\"\',\'\"+ Request.Form(\"Bukser\")+\"\',\'\"+ Request.Form(\"Atroeje\")+\"\',\'\"+ Request.Form(\"ABukser\")+\"\',\'\"+Request.Form(\"Kontakt\")+\"\',\'\"+Request.Form(\"Tlf\")+\"\',\'\"+ Request.Form(\"Fax\")+\"\',\'\"+Request.Form(\"Adr\")+\"\',\'\"+Request.Form(\"Postnr\")+\"\',\'\"+ Request.Form(\"By\")+\"\',\'\"+Request.Form(\"Email\")+\"\',\'\"+Request.Form(\"Dag\")+\"\',\'\"+Request.Form(\"Tid\")+\"\',\'\"+Request.Form(\"MP7A\")+\"\',\'\"+Request.Form(\"MP7B\")+\"\',\'\"+Request.Form(\"L11A\")+\"\',\'\"+Request.Form(\"L11B\")+\"\',\'\"+Request.Form(\"D11A\")+\"\',\'\"+Request.Form(\"D11B\")+\"\',\'\"+Request.Form(\"J11A\")+\"\',\'\"+Request.Form(\"J11B\")+\"\',\'\"+Request.Form(\"Y11A\")+\"\',\'\"+Request.Form(\"Y11B\")+\"\',\'\"+Request.Form(\"MPA\")+\"\',\'\"+Request.Form(\"MPB\")+\"\',\'\"+Request.Form(\"LPA\")+\"\',\'\"+Request.Form(\"LPB\")+\"\',\'\"+Request.Form(\"PA\")+\"\',\'\"+Request.Form(\"PB\")+\"\',\'\"+Request.Form(\"JPA\")+\"\',\'\"+Request.Form(\"JPB\")+\"\',\'\"+Request.Form(\"FM\")+\"\',\'\"+Request.Form(\"LMO\")+\"\',\'\"+Request.Form(\"LF\")+\"\',\'\"+Request.Form(\"LMI\")+\"\',\'\"+Request.Form(\"SMO\")+\"\',\'\"+Request.Form(\"SF\")+\"\',\'\"+Request.Form(\"SMI\")+\"\',\'\"+Request.Form(\"FP\")+\"\')\")
%>
