Insert INto statement error
Jeg får en error når jeg laver noget databaseinput med mit asp. Jeg har et felt som hedder 25, men jeg får en fejlbesked som hedder :[Microsoft][ODBC Microsoft Access 97 Driver] The INSERT INTO statement contains the following unknown field name: ''25''. Make sure you''ve typed the name correctly, and try the operation again.
Jeg har herunder vedlagt hele min asp!!! HJÆÆÆLLPP!!!!
----------
<!doctype html public "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta NAME="Author" Content="Mads Krog-Jensen">
<meta HTTP-EQUIV="Content-Type" CONTENT="text/html;CHARSET=iso-8859-1">
<meta NAME="description"
CONTENT="Sport Extreme - The ultimate referance for the extremeist!">
<meta name="keywords"
content="climb, climbing, extremesports, extreme, adrenalin, skydiving, diving, scuba, mountinbiking, ">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250">
<title>[ - - - - - s p o r t e x t r e m e . c o m - - - - - ]</title>
</head>
<body bgcolor="#000000" text="#000000" link="#C0C0C0" vlink="#808080" alink="#C0C0C0">
<%
font = "<font size = ''2'' face=''Verdana''>"
strongfont = "<font size = ''5'' face=''Verdana''><Strong>"
linecolor = "#FF0000"
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = "DBQ=" & server.mappath("email.mdb")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath
If Request.Servervariables("Content_Length") > 0 then
if Request("1") = "" then
text1 = "false"
else
text1 = "true"
end if
if Request("2") = "" then
text2 = "false"
else
text2 = "true"
end if
if Request("3") = "" then
text3 = "false"
else
text3 = "true"
end if
if Request("4") = "" then
text4 = "false"
else
text4 = "true"
end if
if Request("5") = "" then
text5 = "false"
else
text5 = "true"
end if
if Request("6") = "" then
text6 = "false"
else
text6 = "true"
end if
if Request("7") = "" then
text7 = "false"
else
text7 = "true"
end if
if Request("8") = "" then
text8 = "false"
else
text8 = "true"
end if
if Request("9") = "" then
text9 = "false"
else
text9 = "true"
end if
if Request("10") = "" then
text10 = "false"
else
text10 = "true"
end if
if Request("11") = "" then
text11 = "false"
else
text11 = "true"
end if
if Request("12") = "" then
text12 = "false"
else
text12 = "true"
end if
if Request("13") = "" then
text13 = "false"
else
text13 = "true"
end if
if Request("14") = "" then
text14 = "false"
else
text14 = "true"
end if
if Request("15") = "" then
text15 = "false"
else
text15 = "true"
end if
if Request("16") = "" then
text16 = "false"
else
text16 = "true"
end if
if Request("17") = "" then
text17 = "false"
else
text17 = "true"
end if
if Request("18") = "" then
text18 = "false"
else
text18 = "true"
end if
if Request("19") = "" then
text19 = "false"
else
text19 = "true"
end if
if Request("20") = "" then
text20 = "false"
else
text20 = "true"
end if
if Request("21") = "" then
text21 = "false"
else
text21 = "true"
end if
if Request("22") = "" then
text22 = "false"
else
text22 = "true"
end if
if Request("23") = "" then
text23 = "false"
else
text23 = "true"
end if
if Request("24") = "" then
text24 = "false"
else
text24 = "true"
end if
ipnummer = Request.ServerVariables ("REMOTE_ADDR")
datoen = Date
Response.Write ("dit ipnummer er: " & ipnummer & "<br>")
Response.Write ("Datoen er : " & datoen & "<br>")
Response.Write ("Så kan du nok selv finde ud af at sætte disse 2 variable i en database.. :]<br>")
Sql = "Insert into extreme (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25) values(" & text1 & "," & text2 & "," & text3 & "," & text4 & "," & text5 & "," & text6 & "," & text7 & "," & text8 & "," & text9 & "," & text10 & "," & text11 & "," & text12 & "," & text13 & "," & text14 & "," & text15 & "," & text16 & "," & text17 & "," & text18 & "," & text19 & "," & text20 & "," & text21 & "," & text22 & "," & text23 & "," & text24 & ",''" & Request("25") & "'')"
conn.execute(sql)
Response.Write strongfont & "Thanks.. We will let you know!</font></Strong><br><br>"
end if
If "" = Request.QueryString("Mode") then
response.write strongfont & "Extreme</font></strong>"
end if
If "add" = Request.QueryString("Mode") then
response.write strongfont & "<font color=''#FFFFFF''>Notify me when the following goes online : </font></strong>"
response.write "<form method=''POST'' action=''" & Request.ServerVariables("SCRIPT_NAME") & "''>"
response.write "<div align=''left''><table border=''0'' width=''50%''>"
response.write "<tr><td valign=''top'' align=''right'' colspan=''2'' bgcolor=''" & linecolor & "''></td></tr>"
response.write "<tr><td valign=''top'' align=''right''>" & font & "Email:</td>"
response.write "<td valign=''top''>" & font & "<input type=''text'' name=''25'' size=''40''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Climbing Guide Europe. (More than 20.000 routes)</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''1'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Big wall guide. (Guide to major bigwalls all over the world!)</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''2'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Mountainering in Himalaya</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''3'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Extreme climbing shop</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''4'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Virtuel guide to the best dives in the world. </td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''5'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Top 10 in new places</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''6'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Complete list of places to go diving near you</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''7'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Newest info about equiptment</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''8'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Virtual dive shop</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''9'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Used equiptment</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''10'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Virtual guide to the best mountainbiking places in Europe</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''11'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Complete list of Mountainbike areas near you</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''12'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Virtual bike shop</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''13'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Virtual guide to best wildwater on Earth</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''14'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Articles about kajak and canoe expeditions in wild places</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''15'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Virtual shop and used gear marked</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''16'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Guide to best wavejump places on Earth</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''17'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Virtual shop</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''18'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Guide to hot Rip Curl places</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''19'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Guide to hidden rip curl places around the world!</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''20'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & " Guide to best caves around the world</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''21'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & " Guide to showcaves around Europe</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''22'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Guide to best Cave Diving</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''23'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' valign=''top'' align=''right''>" & font & "Articles about newly discovered caves</td>"
response.write "<td bgcolor=''#C0C0C0'' valign=''top''>" & font & "<input type=''checkbox'' name=''24'' value=''true''></td></tr>"
response.write "<tr><td bgcolor=''#C0C0C0'' colspan=''2'' valign=''top'' align=''right''><div align=''center''><center><p>" & font & "<input type=''submit'' value=''Send'' name=''B1''> <input type=''reset'' value=''Slet'' name=''B2''></td></tr>"
response.write "<tr bgcolor=''#C0C0C0'' align=''center''><td colspan=''2'' valign=''top'' align=''right'' bgcolor=''" & linecolor & "''></td></tr></table>"
response.write "</form></body></html>"
end if
%>
</body>
</html>
