Error Inputing Final Grade

[tomgarraway]

Below is the error message I receive whenever I attempt to input a final grade. I am in Version 4.6 an early build.

Date: 06/15/2010 12:12:14

Failure Notice: DB Execute Failed.

SQL: INSERT INTO STUDENT_REPORT_CARD_GRADES (SYEAR,SCHOOL_ID,STUDENT_ID,COURSE_PERIOD_ID,MARKING_PERIOD_ID,REPORT_CARD_GRADE_ID,GRADE_PERCENT, COMMENT,GRADE_LETTER,WEIGHTED_GP,UNWEIGHTED_GP,COURSE_TITLE,GP_SCALE,CREDIT_ATTEMPTED,CREDIT_EARNED) values('2009','1','69','13','17','8','0',NULL,'C','2.00',NULL,'Baha'i Studies 8 & 9','1.000','0.250','0.250')
Traceback: /var/www/opensis4dot6/modules/Grades/InputFinalGrades.php at 314
Additional Information: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'i Studies 8 & 9','1.000','0.250','0.250')' at line 3

[tomgarraway]

I found the problem and the solution. The title for the course had an apostrophe as part of the name. This is not good usage as it messes with SQL. I removed the apostrophe and all works well now. Cheers!