Hi, i have been playing round with this insert/update script on zope/mysql and keep recieving the following error...any idea's on how to get rid of this would be muchly appreciated? -------------------------------------------------------------------- Error, _mysql_exceptions.ProgrammingError: (1064, "You have an error in your SQL syntax near 'ON DUPLICATE KEY update charts set \n plays=plays + 1\n\twhere title='wayne'' at line 14") -------------------------------------------------------------------- the ZSQL used is below -------------------------------------------------------------------- insert into charts (title, artist, genre, album, plays) VALUES (<!--#sqlvar title type=string --> , <!--#sqlvar artist type=string --> , <!--#sqlvar genre type=string --> , <!--#sqlvar album type=string --> , plays=1 ) ON DUPLICATE KEY update charts set plays=plays + 1 where title=<dtml-sqlvar title type=nb> and artist=<dtml-sqlvar artist type=nb>