sql destination update

Hi,



I've been trying to use the database writer in a destination (d2) to update a table based on the response in the previous destination (d1).



I've set up the variables that I need access to into the channelMap, and I do have access to them and they are set correctly.



What I find interesting is that it works using Javascript:

Code:

---

var result = dbConn.executeUpdate("UPDATE patient_patient SET process_status = '"+$('ris_response')+"' WHERE id = "+$('patient_id'));

---

But not using the sql syntax:

Code:

---

UPDATE patient_patient SET process_status = '${ris_response}' WHERE id = ${patient_id}

---

Any ideas?



I'm using Mirth 3.0.3



Thanks,

Alexander

sql destination update