Hvor er fejlen ???
Hej, eksperte !Jeg er ved at lave en asp så jeg kan rette/opdater i min db. Men jeg få den her fejl:
Microsoft JET Database Engine error '80040e14'
Syntax error in UPDATE statement.
/ekocla/UpdateMember.asp, line 62
Her er linien 62:
Connection.Execute("UPDATE Members SET MembershipLevel = '" & Level & "', MemberFirstName = '" & FirstName & "', MemberLastName = '" & LastName & "', MemberAddress = '" & Address & "', MemberZipCode = '" & ZipCode & "', MemberCity = '" & City & "', MemberOfProvince = '" & Province & "', MemberMobilNumber = '" & MobilNumber & "', MemberTelefonNumber = '" & TelefonNumber & "', MemberBirthDate = '" & BirthDate & "', MemberEmailAddress = '" & Email & "', MemberHomePage = '" & Homepage & "', MemberSchooling = '" & Schooling & "', MemberEducation = '" & Education & "', MemberProfessionQualification = '" & Profession & "', MemberGender = '" & Gender & "', MemberSignOutDate = '" & SignOutDate & "', MemberLivingHome = '" & LivingHome & "', MemberHealthStatus = '" & Health & "', MemberHobby = '" & Hobby & "', MemberKnowledgeOfLanguages = '" & Languages & "', MemberCountryOfOrigin = '" & CountryOfOrigin & "', MemberCitizenship = '" & Citizenship & "', MemberMarriedStatus = '" & MarriedStatus & "', MemberComment = '" & Comment & "', WHERE(MemberID = " & EditID & ") ")
Kan det være pga. at lininen er for lang eller...?
På forhånd tak!
