Syntax error i SQL med Request.QueryString
Jeg får fejlen:Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Participants.ParticipantID='.
email_update.asp, line 16
i nedenstående kode. Jeg har prøvet at rette til uden held. Det er Request.QueryString delen, der giver fejl. Nogen, der kan se fejlen? Pft.
--- start kode ---
strSQL= "SELECT Participants.ParticipantID AS Participants_ParticipantID, Participants.Firstname, Participants.Familyname, Participants.Function, Participants.Department, Participants.Country, Participants.Mobilephone, Participants.Email, ArrivalDetails.ArrivalDate, ArrivalDetails.ArrivalMonth, ArrivalDetails.ArrivalHour, ArrivalDetails.ArrivalMinute, ArrivalDetails.ArrivalBy, ArrivalDetails.ArrivalFlightNo, ArrivalDetails.TransferToHotel, DepartureDetails.DepartureDate, DepartureDetails.DepartureMonth, DepartureDetails.DepartureHour, DepartureDetails.DepartureMinute, DepartureDetails.DepartureBy, DepartureDetails.DepartureFlightNo, DepartureDetails.TransferToAirport, RoomReservation.CheckinDate, RoomReservation.CheckinMonth, RoomReservation.CheckoutDate, RoomReservation.CheckoutMonth, RoomReservation.RoomPreference, RoomReservation.DiateryRemarks, RoomReservation.DiateryPreferences, Participants.RegID, RoomReservation.RoomRequired FROM ((Participants INNER JOIN DepartureDetails ON Participants.ParticipantID = DepartureDetails.ParticipantID) INNER JOIN RoomReservation ON Participants.ParticipantID = RoomReservation.ParticipantID) INNER JOIN ArrivalDetails ON Participants.ParticipantID = ArrivalDetails.ParticipantID WHERE Participants.ParticipantID="& Request.QueryString("ParticipantID") & ";"
