[brl_admin]

Hey Guys, Hope all are doing well. I was able to set up a web server here at work and am back in the web dev business! Kind of.. Can I get a second set of eyes/ If I comment out the date lines in the sql statement, this works fine. With date lines running I get Syntax error in UPDATE statement. Do I need to do something special with the date info to update ?? Thanks for any help. My code is below.. Chip Code: --------- Dim strFormID, strFormLastName, strFormFirstName, strFormPosition, strFormCrew1, strFormCrew1C, strFormCrew2, strFormCrew2C, strFormCrew3, strFormCrew3C, strFormSimNo, strFormDate, strFormTimeIn, strFormTimeOut strFormInstID = Trim(Request.Form("InstID")) strFormCrew1 = Trim(Request.Form("Crew1")) strFormCrew1C = Trim(Request.Form("Crew1C")) strFormCrew2 = Trim(Request.Form("Crew2")) strFormCrew2C = Trim(Request.Form("Crew2C")) strFormCrew3 = Trim(Request.Form("Crew3")) strFormCrew3C = Trim(Request.Form("Crew3C")) strFormAircraft = Trim(Request.Form("Aircraft")) strFormTimeIn = Trim(Request.Form("TimeIn")) strFormTimeOut = Trim(Request.Form("TimeOut")) strFormSimNo = Trim(Request.Form("SimNo")) strFormDate = Trim(Request.Form("Date")) strQ = "UPDATE Instructor SET Crew1 = '" strQ = strQ & strFormCrew1 strQ = strQ & "', Crew1C = '" strQ = strQ & strFormCrew1C strQ = strQ & "', Crew2 = '" strQ = strQ & strFormCrew2 strQ = strQ & "', Crew2C = '" strQ = strQ & strFormCrew2C strQ = strQ & "', Crew3 = '" strQ = strQ & strFormCrew3 strQ = strQ & "', Crew3C = '" strQ = strQ & strFormCrew3C strQ = strQ & "', Date = '" strQ = strQ & strFormDate strQ = strQ & "', Aircraft = '" strQ = strQ & strFormAircraft strQ = strQ & "', TimeIn = '" strQ = strQ & strFormTimeIn strQ = strQ & "', TimeOut = '" strQ = strQ & strFormTimeOut strQ = strQ & "', SimNo = '" strQ = strQ & strFormSimNo strQ = strQ & "' WHERE InstID=" strQ = strQ & strFormInstID strQ = strQ & ";" objRS.Open strQ ---------



More...