Kan du finde fejlen i dette ASP
Hejjeg har lavet 2 asp sider og en database. Når jeg går ind på den første side som hedder konk.asp virker den fint, men når den så for komandoen "send" åbner den ikke siden konk_exec.asp.
De ligger i samme mappe, ligeledes gør databasen.
Jeg håber i kan gennemskue fejlen
Morten
--------------------------------------------------------
<%
DataSource = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("konkurrence.mdb") & ";"
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open DataSource
%>
<HTML>
<HEAD>
<TITLE>Klub 3</TITLE>
</HEAD>
<BODY LINK="#336699" VLINK="#336699" alink="#336699" text="#336699" leftmargin="0" marginwidth="0" topmargin="0" marginheight="0" bgcolor="#c8c8c8">
<font face="Verdana"><A NAME="top"></A></font><font size="2" face="Verdana"><a href="java script:history.go(-1);">Tilbage</a></font><font size="2" face="arial">
<hr>
</font>
<div align="center">
<table cool width="502" height="361" usegridx usegridy showgridx showgridy gridx="2" gridy="2" border="0" cellpadding="0" cellspacing="0">
<tr height="360">
<td width="2" height="360"></td>
<td width="499" height="360" align="left" xpos="2" content valign="top" csheight="358">
<div align="center">
<font face="Verdana"><font size="3"><b>Konkurrence</b> </font></font>
<p><font face="Verdana" size="2">Se om du kan tippe rigtigt og tryk på send knappen<br>
Vi trækker lod mellem de rigtige svar og vinderene af en <br>
Klub 3 T-shirt bliver offentliggjort løbende på vores hjemmeside.<br>
Go</font><font face="Verdana" size="2">d fornøjelse... </font></p>
<form name="FormName" method="post" action="konk_exec.asp">
<table cool width="622" height="231" usegridx usegridy showgridx showgridy gridx="2" gridy="2" border="0" cellpadding="0" cellspacing="0">
<tr height="8">
<td width="31" height="210" rowspan="14"></td>
<td width="341" height="8" colspan="4"></td>
<td width="5" height="183" rowspan="13"></td>
<td width="244" height="8" colspan="2"></td>
<td width="1" height="8"><spacer type="block" width="1" height="8"></td>
</tr>
<tr height="24">
<td width="341" height="24" colspan="4" valign="top" align="left" xpos="31"><label><font face="Verdana" size="2">Hvor mange medarbejdere er der i Klub 3 ?</font></label></td>
<td width="244" height="24" colspan="2" valign="top" align="left" xpos="377"><select name="medarbejdere" size="1" tabindex="1">
<option value="0" selected></option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
</select></td>
<td width="1" height="24"><spacer type="block" width="1" height="24"></td>
</tr>
<tr height="24">
<td width="341" height="24" colspan="4" valign="top" align="left" xpos="31"><label><font face="Verdana" size="2">Hvor mange medlemmer er der ca. i Klub 3 ?</font></label></td>
<td width="244" height="24" colspan="2" valign="top" align="left" xpos="377"><select name="medlemmer" size="1" tabindex="2">
<option value="0" selected></option>
<option value="80">80</option>
<option value="100">100</option>
<option value="130">130</option>
</select></td>
<td width="1" height="24"><spacer type="block" width="1" height="24"></td>
</tr>
<tr height="24">
<td width="341" height="24" colspan="4" valign="top" align="left" xpos="31"><label><font face="Verdana" size="2">Hvor mange pool borde er der i Klub 3 ?</font></label></td>
<td width="244" height="24" colspan="2" valign="top" align="left" xpos="377"><select name="Poolborde" size="1" tabindex="3">
<option value="0" selected></option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
</select></td>
<td width="1" height="24"><spacer type="block" width="1" height="24"></td>
</tr>
<tr height="24">
<td width="341" height="24" colspan="4" valign="top" align="left" xpos="31"><label><font size="2" face="Verdana">Hvad koster en Slush ice incl. pant i Klub 3 ?</font></label></td>
<td width="244" height="24" colspan="2" valign="top" align="left" xpos="377"><select name="Slush ice pris" size="1" tabindex="4">
<option value="0" selected></option>
<option value="8 kr">8 kr</option>
<option value="10 kr">10 kr</option>
<option value="12 kr">12 kr</option>
</select></td>
<td width="1" height="24"><spacer type="block" width="1" height="24"></td>
</tr>
<tr height="2">
<td width="85" height="2" colspan="2"></td>
<td width="256" height="24" colspan="2" rowspan="2" valign="top" align="left" xpos="116"><input type="text" name="Navn" size="24" tabindex="5"></td>
<td width="244" height="79" colspan="2" rowspan="8"></td>
<td width="1" height="2"><spacer type="block" width="1" height="2"></td>
</tr>
<tr height="22">
<td width="85" height="22" colspan="2" valign="top" align="left" xpos="31"><label><font face="Verdana" size="2">Navn</font></label></td>
<td width="1" height="22"><spacer type="block" width="1" height="22"></td>
</tr>
<tr height="2">
<td width="1" height="82" rowspan="7"></td>
<td width="84" height="2"></td>
<td width="256" height="24" colspan="2" rowspan="2" valign="top" align="left" xpos="116"><input type="text" name="Adresse" size="24" tabindex="6"></td>
<td width="1" height="2"><spacer type="block" width="1" height="2"></td>
</tr>
<tr height="22">
<td width="84" height="22" valign="top" align="left" xpos="32"><label><font face="Verdana" size="2">Adr.</font></label></td>
<td width="1" height="22"><spacer type="block" width="1" height="22"></td>
</tr>
<tr height="2">
<td width="84" height="2"></td>
<td width="42" height="26" rowspan="2" valign="top" align="left" xpos="116"><input type="text" name="Postnr" size="4" tabindex="7"></td>
<td width="214" height="26" rowspan="2" valign="top" align="left" xpos="158"><input type="text" name="By" size="18" tabindex="8"></td>
<td width="1" height="2"><spacer type="block" width="1" height="2"></td>
</tr>
<tr height="24">
<td width="84" height="24" valign="top" align="left" xpos="32"><label>Postnr & <font face="Verdana" size="2">By</font></label></td>
<td width="1" height="24"><spacer type="block" width="1" height="24"></td>
</tr>
<tr height="1">
<td width="84" height="1"></td>
<td width="256" height="32" colspan="2" rowspan="3" valign="top" align="left" xpos="116"><input type="text" name="Email" size="24" tabindex="9"></td>
<td width="1" height="1"><spacer type="block" width="1" height="1"></td>
</tr>
<tr height="4">
<td width="84" height="31" rowspan="2" valign="top" align="left" xpos="32"><label><font face="Verdana" size="2">E-mail</font></label></td>
<td width="1" height="4"><spacer type="block" width="1" height="4"></td>
</tr>
<tr height="27">
<td width="44" height="27" colspan="2" valign="top" align="left" xpos="372"><input type="submit" name="submitButtonName" value="Send" tabindex="10"></td>
<td width="205" height="27" valign="top" align="left" xpos="416"><input type="reset" value="Slet" tabindex="11"></td>
<td width="1" height="27"><spacer type="block" width="1" height="27"></td>
</tr>
<tr height="20">
<td width="621" height="20" colspan="8" valign="top" align="left" xpos="0"><label><font face="Verdana" size="1">Hvis du ikke har mulighed for at bruge Outlook som mail, må du gerne indsende svarene via din egen mail </font></label></td>
<td width="1" height="20"><spacer type="block" width="1" height="20"></td>
</tr>
<tr height="1" cntrlrow>
<td width="31" height="1"><spacer type="block" width="31" height="1"></td>
<td width="1" height="1"><spacer type="block" width="1" height="1"></td>
<td width="84" height="1"><spacer type="block" width="84" height="1"></td>
<td width="42" height="1"><spacer type="block" width="42" height="1"></td>
<td width="214" height="1"><spacer type="block" width="214" height="1"></td>
<td width="5" height="1"><spacer type="block" width="5" height="1"></td>
<td width="39" height="1"><spacer type="block" width="39" height="1"></td>
<td width="205" height="1"><spacer type="block" width="205" height="1"></td>
<td width="1" height="1"></td>
</tr>
</table>
</form>
</div>
</td>
<td width="1" height="360"><spacer type="block" width="1" height="360"></td>
</tr>
<tr height="1" cntrlrow>
<td width="2" height="1"><spacer type="block" width="2" height="1"></td>
<td width="499" height="1"><spacer type="block" width="499" height="1"></td>
<td width="1" height="1"></td>
</tr>
</table>
</div>
</BODY>
<%
Conn.Close
Set conn = nothing
%>
</HTML>
--------------------------------------------------------
<% @Language = VBScript %>
<% Response.Buffer=true %>
<%
DataSource = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("konkurrence.mdb") & ";"
Medarbejdere = request("medarbejdere")
Medlemmer = request("medlemmer")
Poolborde = request("Poolborde")
Slush ice pris = request("Slush ice pris")
Navn = request("Navn")
Adresse = request("Adresse")
Postnr = request("Postnr")
By = request("By")
Email = request("Email")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open DataSource
indsaetModtager = "insert into Konk (Svar 1, Svar 2, Svar 3, Svar 4, Navn, Adr, Postnr, By, Email) values ("&Medarbejdere&","&Medlemmer&","&Poolborde&", "&Slush ice pris&",'"&Navn&"','"&Adresse&"',"&Postnr&",'"&By&"','"&Email&"')"
conn.Execute(indsaetModtager)
%>
<html>
<head>
</head>
<body bgcolor="#c8c8c8" text="#336699" link="#336699" alink="#336699" vlink="#336699">
<div align="center">
<table border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
</tr>
<tr>
<td class="overskrift" align="center"><font face="Verdana" size="3">Dine oplysninger er nu registret!</font></td>
</tr>
</table>
<BR>
<BR>
<BR>
<table border="0" cellspacing="0" cellpadding="0" align="center" width="245">
<tr>
<td width="70"><strong>Medarbejdere</strong></td>
<td width="180"><%=Medarbejdere%></td>
</tr>
<tr>
<td><strong>Medlemmer</strong></td>
<td><%=Medlemmer%></td>
</tr>
<tr>
<td><strong>Poolborde</strong></td>
<td><%=Poolborde%></td>
</tr>
<tr>
<td><strong>Slush ice pris</strong></td>
<td><%=Slush ice pris%></td>
</tr>
<tr>
<td><strong>Navn</strong></td>
<td><%=Navn%></td>
</tr>
<tr>
<td><strong>Adresse</strong></td>
<td><%=Adresse%></td>
</tr>
<tr>
<td><strong>Postnr</strong></td>
<td><%=Postnr%></td>
</tr>
<tr>
<td><strong>By</strong></td>
<td><%=By%></td>
</tr>
<tr>
<td><strong>Email</strong></td>
<td><%=Email%></td>
</tr>
</table>
</div>
</body>
<%
Conn.Close
Set conn = nothing
%>
</html>
--------------------------------------------------------
