Hi!
>>>>> "Anna" == Anna Fowles-Winkler <[EMAIL PROTECTED]> writes:
Anna> I removed the semicolon from the end of the query string, and I still get the
Anna> same syntax error:
Anna> You have an error in your SQL syntax near ''.1' at line 10
Anna> This is what the query looks like:
Anna> INSERT INTO micromodels
Anna> (name, revision, dynamic, m_class, novars, equation, min_0, min_1,
Anna> min_2, min_3, min_4, min_5, min_6, min_7, min_8, max_0, max_1,
Anna> max_2, max_3, max_4, max_5, max_6, max_7, max_8, except_0,
Anna> except_1, except_2, except_3, except_4, except_5, except_6,
Anna> except_7, except_8, prompt_0, prompt_1, prompt_2, prompt_3, prompt_4,
Anna> prompt_5, prompt_6, prompt_7, prompt_8, allow_0, allow_1, allow_2,
Anna> allow_3, allow_4, allow_5, allow_6)
Anna> VALUES ('Eye Movement
Anna>
Time',1,NULL,'per',0,'.1;',0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,-1,-1,-1,-1,-1,-1,-1,-1,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,1)
The MySQL server should not have any problems with the above query.
The ';' is something that is parsed by the command line client 'mysql'
and not something that the server really cares about.
Exactly how did you try to submit the above line ?
Can you show us the exact code where you stored the above query in a
string and sent it to the server ?
Please check with a debugger or by starting mysqld with --log and
examining the log file, that the server really got the above query!
Regards,
Monty
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
