28. maj 2002 - 19:03
Der er
7 kommentarer og 1 løsning
Lavet en formular får en underlig fejlmeddelse
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access-driver] Der er en syntaksfejl i INSERT INTO-sætningen. og min lille stk kode ser således ud: ' find antallet af arrangementer i tabellen strSQL = "INSERT * INTO Users WHERE USER(FullName, Address, Postnum, City, Birthday, Gender, Member, EMail, UserName, Password, Admin) VALUES (" strSQL = strSQL & "'" & Request.Form("fullname") & "', " strSQL = strSQL & "'" & Request.Form("address") & "', " strSQL = strSQL & "" & Request.Form("postnum") & ", " strSQL = strSQL & "'" & Request.Form("city") & "', " strSQL = strSQL & "'" & strDate & "', " strSQL = strSQL & "" & fGender & ", " strSQL = strSQL & "" & fMember & ", " strSQL = strSQL & "'" & Request.Form("email") & "', " strSQL = strSQL & "'" & Request.Form("user") & "', " strSQL = strSQL & "'" & Request.Form("password1") & "', " strSQL = strSQL & "" & 0 & ") " det er her den skriver der er en fejl..--->>> Set objRSadd = objConn.Execute( strSQL ) if objRS.EOF then Set objCDO = Server.CreateObject("CDONTS.NewMail")
Annonceindlæg fra Computerworld
' find antallet af arrangementer i tabellen strSQL = "INSERT * INTO USERS (FullName, Address, Postnum, City, Birthday, Gender, Member, EMail, UserName, Password, Admin) VALUES (" strSQL = strSQL & "'" & Request.Form("fullname") & "', " strSQL = strSQL & "'" & Request.Form("address") & "', " strSQL = strSQL & "" & Request.Form("postnum") & ", " strSQL = strSQL & "'" & Request.Form("city") & "', " strSQL = strSQL & "'" & strDate & "', " strSQL = strSQL & "" & fGender & ", " strSQL = strSQL & "" & fMember & ", " strSQL = strSQL & "'" & Request.Form("email") & "', " strSQL = strSQL & "'" & Request.Form("user") & "', " strSQL = strSQL & "'" & Request.Form("password1") & "', " strSQL = strSQL & "" & 0 & ") " Prøv med denne! //>Rune
' find antallet af arrangementer i tabellen strSQL = "INSERT INTO USERS (FullName, Address, Postnum, City, Birthday, Gender, Member, EMail, UserName, Password, Admin) VALUES (" strSQL = strSQL & "'" & Request.Form("fullname") & "', " strSQL = strSQL & "'" & Request.Form("address") & "', " strSQL = strSQL & "" & Request.Form("postnum") & ", " strSQL = strSQL & "'" & Request.Form("city") & "', " strSQL = strSQL & "'" & strDate & "', " strSQL = strSQL & "" & fGender & ", " strSQL = strSQL & "" & fMember & ", " strSQL = strSQL & "'" & Request.Form("email") & "', " strSQL = strSQL & "'" & Request.Form("user") & "', " strSQL = strSQL & "'" & Request.Form("password1") & "', " strSQL = strSQL & "" & 0 & ") " ups. vi prøver lige igen! //>Rune
desværre stadigvæk samme fejlmeddelse Fejltype: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access-driver] Der er en syntaksfejl i INSERT INTO-sætningen. /neta/neta/MyWare/MyWare/adduser.asp, line 66
hmm.. prøv lige med denne så: strSQL = "INSERT INTO USERS (FullName,Address,Postnum,City,Birthday,Gender,Member,EMail,UserName,Password,Admin) VALUES ('" & Request.Form("fullname") & "','" & Request.Form("address") & "'," & Request.Form("postnum") & ",'" & Request.Form("city") & "','" & strDate & "'," & fGender & "," & fMember & ",'" & Request.Form("email") & "','" & Request.Form("user") & "','" & Request.Form("password1") & "'," & 0 & ")" //>Rune
*SNØØØØØØØØØØØØØØØØØØØØØØØFTZ*
Hmmm...prøv at giv mig hele din kode, så kan jeg lige se på det... //>Rune
hvor kan jeg sende den hen?
Computerworld tilbyder specialiserede kurser i database-management