Insert into - fejl
HeyHvad er der galt her:
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../db/dbase.mdb") & "; UID=administrator; PWD=black"
Conn.Open DSN
strIp = Request.ServerVariables("REMOTE_ADDR")
strFos = request.form("dag") & "-" & request.form("maaned") & "-" & request.form("aar")
strSQL = "Insert into members("
strSQL = strSQL & "ip, "
strSQL = strSQL & "navn, "
strSQL = strSQL & "brugernavn, "
strSQL = strSQL & "password, "
strSQL = strSQL & "hjemmeside, "
strSQL = strSQL & "email, "
strSQL = strSQL & "beskrivelse, "
strSQL = strSQL & "fødselsdato, "
strSQL = strSQL & "status, "
strSQL = strSQL & "by) "
strSQL = strSQL & "values( "
strSQL = strSQL & "'" & strIp & "',"
strSQL = strSQL & "'" & Request.Form("navn") & "',"
strSQL = strSQL & "'" & Request.Form("brugernavn") & "',"
strSQL = strSQL & "'" & Request.Form("password") & "',"
strSQL = strSQL & "'" & Request.Form("hjemmeside") & "',"
strSQL = strSQL & "'" & Request.Form("email") & "',"
strSQL = strSQL & "'" & Request.Form("beskrivelse") & "',"
strSQL = strSQL & "'" & strFos & "',"
strSQL = strSQL & "'" & "Ansoger" & "',"
strSQL = strSQL & "'" & Request.Form("by") & "')"
Conn.Execute(strSQL)
Conn.Close
Set Conn = Nothing
...får fejlen:
Fejltype:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access-driver] Der er en syntaksfejl i INSERT INTO-sætningen.
/musicchart/html/tilfoj_bruger.asp, line 71
...linie 71:
Conn.Execute(strSQL)
/Bjarke - (KLEIFDESIGN)
