Re: Error in generated MySQL-syntax
Thanks for your reply!
If I do it that way, I get another error, and not even the first entry is entered in the database:
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 'VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title',' at line 1INSERT INTO events(StartDatum,StartTijd,EindDatum,EindTijd,Weergavetijd,Titel,Locatie,Beschrijving) VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'), VALUES ('2016-01-01', '00:01:00', '2016-01-01', '02:00:00', 'Nicetime', 'Title', 'Location', 'Description'),
Could you help me out with that please?