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>