fejl ved tilføjning i MySQL
Hej Exp´sJeg har lavet dette script som tilføjer nogle brugeroplysninger til en MySQL-database.
<%
If request.form("navn") = "" then
response.redirect "tilmeld.asp?mode=navn"
elseIf request.form("nickname") = "" then
response.redirect "tilmeld.asp?mode=nickname"
elseIf request.form("pwd") = "" then
response.redirect "tilmeld.asp?mode=pwd"
elseIf request.form("pwd_2") = "" then
response.redirect "tilmeld.asp?mode=pwd_2"
elseIf request.form("adresse") = "" then
response.redirect "tilmeld.asp?mode=adresse"
elseIf request.form("postnr") = "" then
response.redirect "tilmeld.asp?mode=postnr"
elseIf request.form("by") = "" then
response.redirect "tilmeld.asp?mode=by"
elseIf request.form("mail") = "" then
response.redirect "tilmeld.asp?mode=email"
else
Dim conn, strSQL
Set conn = createobject("ADODB.Connection")
conn.open = "DRIVER={MySQL ODBC 3.51 Driver};"_
& "SERVER=localhost;"_
& "DATABASE=vp;"_
& "UID=root;PWD=;"
strSQL = "insert into bruger (navn, nickname, pwd, adresse, postnr, by, msn, icq, hp_url, mail, selv_beskriv) values('" & request.form("navn") & "' , '" & request.form("nickname") & "' , '" & request.form("pwd") & "' , '" & request.form("adresse") & "' , '" & request.form("postnr") & "' , '" & request.form("by") & "' , '" & request.form("msn") & "' , '" & request.form("icq") & "' , '" & request.form("hp_url") & "' , '" & request.form("mail") & "' , '" & request.form("selv_beskriv") & "')"
conn.execute(strSQL)
conn.close
set conn = nothing
End If
%>
Jeg får denne fejl i browseren:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.14-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'by, msn, icq, hp_url, mail, selv_beskriv) values('demo' , 'demo
/vp/tilmeld_exe.asp, line 50
Hvad er der galt??
