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

 
 
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

date is a "reserved" word in SQL, and as such should not be used as a column name.

Thanks Chris, I'll change the name in my database. As always, I appreciate the help. I'm going to try to make the time to frequent more often... See you around.

Chip