Avatar billede ip Nybegynder
18. juni 1999 - 14:02 Der er 2 kommentarer

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>[ - - - - -&nbsp; 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''>&nbsp;&nbsp;&nbsp; <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>
Avatar billede overload.dk Nybegynder
18. juni 1999 - 18:27 #1
Det er i denne del der laves fejl:

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") & "'


Tjek at kolonne 25 er oprettet i database-filen, og prøv også at tjekke om der virkelig hentes noget i Request("25") sidst i linien.

Prøv evt. at sætte response.write Request("25") og se hvad output'en er.

HV:
Overload
att: Peter Loft Jensen
e.mail: peterloft@get2net.dk
Avatar billede vallemanden Nybegynder
11. oktober 2004 - 00:40 #2
hmmm måske på tide at lukke
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Kurser inden for grundlæggende programmering

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester