SQL INSERT statement error...
'declare SQL statement that will query the database
sSQL= "INSERT INTO CQCurrAssess (Fleet, DutyPosition, TrainingDate) VALUES ('" & Request.form("fleettype") &"', '" & Request.form("position") &"', '" & Request.form("trainingdate") & "')"
Is generating this error:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/flightcrew/hazcomm/CQTest.asp, line 14, column 779
This is just an ASP file trying to write to a database. Appreciate the help if you can see where this is flawed.
Could it be that your SQL statement is whitin an if statement or a for loop or something?
Because the sql statement seems to be fine to me
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)