Welcome to the nuBuilder forums!

Please register and login to view forums and other content only available to registered users.

"INSERT ... ON DUPLICATE KEY UPDATE" Syntax

Post Reply
D630
Posts: 4
Joined: Fri Apr 12, 2013 12:00 pm

"INSERT ... ON DUPLICATE KEY UPDATE" Syntax

Unread post by D630 »

Hi,

In "After Save" i run this code to modify a another table :

Code: Select all

$sql  = "INSERT INTO verbindung (";
$sql .= "formal_Erschliessung_ID)";
$sql .= "VALUES (";
$sql .= "'$recordID')";
nuRunQuery($sql); 
This works fine. Now i would like to change it into a "INSERT ... ON DUPLICATE KEY UPDATE" Syntax, but i can not get at it. Can anybody give me a helping hand?

Thanks.
admin
Site Admin
Posts: 2778
Joined: Mon Jun 15, 2009 2:23 am
nuBuilder Version: 4.5

Re: "INSERT ... ON DUPLICATE KEY UPDATE" Syntax

Unread post by admin »

D630,

Using nuDebug() should help you find the problem.

http://wiki.nubuilder.com/tiki-index.ph ... g_pString_

Steven
Post Reply