Hi Umbracians

I use this code to insert values

Node
 
 
 n = Node.GetCurrent();
 
ISqlHelper
 
 
 SqlHelper = DataLayerHelper.CreateSqlHelper(umbraco.GlobalSettings.DbDSN);
SqlHelper.ExecuteNonQuery(
 
 
@"INSERT INTO mytable(TEST,NODEID)
              values(@TEST,@NODEID)",
SqlHelper.CreateParameter(
 
"@TEST", test),
SqlHelper.CreateParameter("@NODEID", n.Id));

and this code to update

 
 
ISqlHelper SqlUpdateHelper = DataLayerHelper.CreateSqlHelper(umbraco.GlobalSettings.DbDSN);
SqlUpdateHelper.ExecuteNonQuery(
 
 
@"UPDATE mytable SET...

but that can't work, because it insert and update the values in the database at the same time :-).

How can I check if n.Id in mytable already exist?

I think of something like that

 
 
if (value... @NODEID = n.Id) {
UPDATE mytable SET...
}
 
 
else
INSERT INTO mytable...

Calvin