I am trying to take the full XML message generated by Mirth and put it into a memo field in a table.
sends the text "datastuff" to the table (this was a test of the connection).
Sends a null for the datastuff amount, as does
Similar results with an SQL Insert. Any ideas?
Code:
var dbConn = DatabaseConnectionFactory.createDatabaseConnection('sun.jdbc.odbc.JdbcOdbcDriver','jdbc:odbc:IHEData','doug','doug'); var datastuff = $(message.encodedData); var expression = "EXECUTE PROCEDURE UpdateTable('PATIENT','datastuff');"; var result = dbConn.executeUpdate(expression);
Code:
var dbConn = DatabaseConnectionFactory.createDatabaseConnection('sun.jdbc.odbc.JdbcOdbcDriver','jdbc:odbc:IHEData','doug','doug'); var datastuff = $(message.encodedData); var expression = "EXECUTE PROCEDURE UpdateTable('PATIENT','"+datastuff+"')"; var result = dbConn.executeUpdate(expression);
Code:
var dbConn = DatabaseConnectionFactory.createDatabaseConnection('sun.jdbc.odbc.JdbcOdbcDriver','jdbc:odbc:IHEData','doug','doug'); var datastuff = $(message.encodedData).toString(); var expression = "EXECUTE PROCEDURE UpdateTable('PATIENT','"+datastuff.toString()+"')"; var result = dbConn.executeUpdate(expression);
Comment