I did see that. I changed it in my function script but that did not make a difference.
I was able to get everything working by passing the query statement to the sql module via something like msg.query. I was always using the gui in the mssql plus node instead of passing it in. Not sure why the gui does not work as it should but I'm able to make it work which is sad because I would rather of made it work in there for ease of read ability for non code people.
let rawdata = msg.payload;
let pattern = /(\d{2}:\d{2}:\d{2})/;
// Extract values using the regular expression patterns
let timematch = rawdata.match(pattern);
msg.testTime = timematch ? timematch[0] : null; // Access the first element of the array
// Construct the SQL query
msg.query = `INSERT INTO checkweigher_test (Date, Time, Code, Run, Program, Weight, hardwareId)
VALUES ('2025-01-06', '${msg.testTime}', '005', '204250', '001', '127.0', '1');`;
return msg;
This was my test function which worked with no issues.
Like I said though using the Parameters section in the mssql plus node config with the editor would not work with the same data being as an input.
Cheers.
