Hi,
Is it possible to use ON DUPLICATE With the DBOutput component? It keeps giving me enum errors, so I presume it is not coded?
Thanks
Des
Hi,
Is it possible to use ON DUPLICATE With the DBOutput component? It keeps giving me enum errors, so I presume it is not coded?
Thanks
Des
Hello Des,
It is possible to use a SQL query in DBOutputTable with ON DUPLICATE clause.
E.g.
INSERT INTO `aTable` (`field1`, `field2`) VALUES ($field1, $field2) on duplicate key update field3 = ‘aValue’
However, there is no direct support for this clause, you can only use it with a SQL query.
Best regards,
Tomas Waller
Thanks for the answer.