28 November, 2012

Mirth : Add parameter in database query


Problem:
Insert / Update database field value using param.

Solution:

//Add param.
params = new java.util.ArrayList();

var paramValue = 'SomeValue';



//Add param Value in param array.
params.add(paramValue);

//Insert / Update in DB.
dbCon.executeUpdate('INSERT INTO tableName (?) VALUES ("' + SomeValue + '")', params);

No comments:

Post a Comment