Ok fellow monks,
This is a strange one. I'm using DBI to update a mysql database. There are 5 integer fields. If I name the last field 'with', I get an SQL syntax error. If I change the name of the field to something else, I don't get the error.
This is the error I get when naming the field 'with'. (All of the fields are integer fields):
DBD::mysql::st execute failed: You have an error in your SQL syntax.
+Check the manual that corresponds to your MySQL server version for th
+e right syntax to use near 'with) VALUES (11,'14','1','1','1')' at li
+ne 1 at ./put1.pl line 25, <CEV> line 1.
I have searched SQL documentation and unless I am missing something, 'with' is not a keyword that would cause confusion. Is there something special about the word in Perl that would be causing this error?