[OA] Evaljrl table insert problem

[Les Richardson]

Hi Methodius,

This is now fixed and updated in the 2.01 updates. (enroladd1.pl) Thanks 
for the heads up.

Les


On Tue, 5 Sep 2006, Methodius Dusyk wrote:

> Hi
>
> When a school is enrolling students into subjects, and the student name 
> contains an apostrophe such as in "O'Grady" , the enroladd1.pl script 
> complains when an insert into the evaljrl table is required.
>
> DBD::mysql::st execute failed: 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 'Grady-Blais','xxxx','xxxx','xxxx-09-23','')' 
> at line 3 at /opt/schools/bready/cgi/repcard/enroladd1.pl line 121., 
> referer: http://brea.lskysd.ca/cgi-bin/repcard/enroladd0.pl
>
> The last name in this case is "O'Grady-Blais"  I replaced parts of the 
> student name and birthdate with xxxx in this email The script that 
> enrolls a student into OpenAdmin seems to have no problem with names 
> that have an apostrophe in them.
>
> Methodius
>
> _______________________________________________
> Openadmin mailing list
> Openadmin at pananix.com
> https://www.pananix.com/cgi-bin/mailman/listinfo/openadmin
>