Find fejlen :o)
Jeg kan bare ikke finde fejlen.Det er meget mystisk sikkert bare noget simpelt der er glippet..
<%
if Request.querystring(\"mode\") = \"opretbutik\" and session(\"level\") = \"1\" then
If Request.Form(\"Gem\") = \"Tilføj\" Then
Response.write \"Tjekker lige dine oplysninger\"
strbutiknavn = request.form(\"butiknavn\")
strkontaktperson = request.form(\"kontaktperson\")
strkontakttlfnr1 = request.form(\"kontakttlfnr1\")
kontakttlfnr2 = request.form(\"kontakttlfnr2\")
stradresse = request.form(\"adresse\")
strpostnr = request.form(\"postnr\")
strbynavn = request.form(\"bynavn\")
strkodeord = request.form(\"kodeord\")
strdmlink = request.form(\"dmlink\")
strdmlogo = request.form(\"dmlogo\")
strspar30link = request.form(\"spar30link\")
strspar30logo = request.form(\"spar30logo\")
strlevel = \"2\"
strstatus = \"butik\"
\'HER SKAL JEG SÅ LAVE SÅDAN AT DEN TJEKKER OM DE ER RIGTIGE
\'GEMNING AF OPLYSNINGER
Set rs = Server.CreateObject(\"ADODB.RecordSet\")
strSQL = \"SELECT * FROM [tblforhandlere] WHERE (ID = 0)\"
rs.Open strSQL, Conn, adOpenKeyset, adLockOptimistic
If (rs.BOF Or rs.EOF) Then
rs.AddNew
rs(\"butiknavn\") = strbutiknavn
rs(\"kontaktperson\") = strkontaktperson
rs(\"kontakttlfnr1\") = strkontakttlfnr1
rs(\"kontakttlfnr2\") = kontakttlfnr2
rs(\"adresse\") = stradresse
rs(\"postnr\") = strpostnr
rs(\"bynavn\") = strbynavn
rs(\"kodeord\") = strkodeord
rs(\"linkdm\") = strlinkdm
rs(\"logodm\") = strlogodm
rs(\"linkspar30\") = strlinkspar30
rs(\"logospar30\") = strlogospar30
rs(\"level\") = strlevel
rs(\"status\") = strstatus
rs.Update
rs.Close
Set rs = Nothing
\'BEKRÆFTELSE ELLER VIDERSENDELSE AF OPLYSNINGER
Response.write \"Brugeren er oprettet\"
end if
end if
%>
<%
if request.form(\"Gem\") <> \"Tilføj\" then
%>
</Center>
<form method=\"POST\" name=\"sender\" action=\"main.asp?mode=opretbutik\" align=\"center\">
<table border=\"1\" cellspacing=\"1\" width=\"520\" height=\"1\">
<tr>
<td colspan=\"2\" width=\"520\" height=\"2\" align=\"center\">Bruger Oprettelse</td>
</tr>
<tr>
<td height=\"15\" align=\"left\">Butiknavn</td>
<td height=\"15\" align=\"left\"><input type=\"text\" name=\"butiknavn\" value=\"\" size=\"20\"></td>
</tr>
<tr>
<td width=\"25%\" height=\"15\" align=\"left\">Kontaktperson</td>
<td height=\"15\" align=\"left\"><input type=\"text\" name=\"kontaktperson\" size=\"20\"></td>
</tr>
<tr>
<td height=\"19\" align=\"left\">Kontakt Telefon nr 1</td>
<td height=\"19\" align=\"left\"><input type=\"text\" name=\"kontakttlfnr1\" size=\"8\" maxlength=\"8\"></td>
</tr>
<tr>
<td height=\"26\" align=\"left\">Kontakt Telefon nr 2</td>
<td height=\"26\" align=\"left\"><input type=\"text\" name=\"kontakttlfnr2\" size=\"8\" maxlength=\"8\">
</td>
<tr>
<td height=\"26\" align=\"left\">Adresse</td>
<td height=\"26\" align=\"left\"><input type=\"text\" name=\"adresse\" size=\"20\">
</td>
</tr>
<tr>
<td height=\"26\" align=\"left\">Post nr</td>
<td height=\"26\" align=\"left\"><input type=\"text\" name=\"postnr\" size=\"4\" maxlength=\"4\"></td>
</tr>
<tr>
<td height=\"28\" align=\"left\">By</td>
<td height=\"28\" align=\"left\"><input name=\"bynavn\" size=\"20\" value></td>
</tr>
<tr>
<td height=\"26\" align=\"left\">Kodeord</td>
<td height=\"26\" align=\"left\"><input type=\"text\" name=\"kodeord\" size=\"20\"></td>
</tr>
<tr>
<td height=\"28\" align=\"left\">Spar30 Link</td>
<td height=\"28\" align=\"left\"><select name=\"spar30link\" size=\"1\">
<option selected value=\"Ja\">Ja</option>
<option value=\"Nej\">Nej</option></select>
</td>
</tr>
<tr>
<td height=\"28\" align=\"left\">Spar30 Logo</td>
<td height=\"28\" align=\"left\"><select name=\"spar30logo\" size=\"1\">
<option selected value=\"Ja\">Ja</option>
<option value=\"Nej\">Nej</option></select>
</td>
</tr>
<tr>
<td height=\"28\" align=\"left\">Direct Mail Link</td>
<td height=\"28\" align=\"left\"><select name=\"dmlink\" size=\"1\">
<option selected value=\"Ja\">Ja</option>
<option value=\"Nej\">Nej</option></select>
</td>
</tr>
<tr>
<td height=\"28\" align=\"left\">Direct Mail Logo</td>
<td height=\"28\" align=\"left\"><select name=\"dm30logo\" size=\"1\">
<option selected value=\"Ja\">Ja</option>
<option value=\"Nej\">Nej</option></select>
</td>
</tr>
<tr>
<td colspan=\"2\" height=\"1\"><div align=\"right\"><input type=\"submit\" value=\"Tilføj\"
name=\"Gem\"><input type=\"button\" value=\"Annuller\" name=\"Annuller\"
onClick=\"java script:history.back();\"></td>
</tr>
</table>
</form>
</Center>
</body>
</html>
<%
end if
end if
%>
Den melder
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
Mvh
Etlekana
