This is a mysql error message that has nothing to do with zope. I don't believe that mysql supports the 'ON DUPLICATE KEY' syntax...

Wayne Connolly wrote:

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 ( ,
   ,
   ,
   ,
  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>