GoldenEagle
05-02-2006, 03:43 PM
I am using a form that is pulling off an ID from the previous page and writting to the database. I think I need to conver it to a number format (its being sent as text) to write it into the database. It is set up as a number in the database. I am using this code:
objComm.CommandText = "INSERT INTO Classes(StudentID, CourseID, Taken) VALUES (StudentID, 'ENG101', '" & Taken1 & "')"
and it is returning this error:
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/grg/cisprogramming0506add.asp, line 62
objComm.CommandText = "INSERT INTO Classes(StudentID, CourseID, Taken) VALUES (StudentID, 'ENG101', '" & Taken1 & "')"
and it is returning this error:
Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.
/grg/cisprogramming0506add.asp, line 62