OK , Steve , I still get the same Errors as before and implemented the nodes as instructed ,
Response from Join Node ,
{"topic":"accreq","payload":{"psa001/d1/user_input ":{"Name ":"Pieter","Surname":"Hattingh","PIN":5054,"OTP":1234,"Door ID":1},"accreq":"74657ce6651d26d4650b2da3c16127de6017ed409492fcf62a0a48eee27c2667"},"qos":0,"retain":false,"_msgid":"5d9caa65.05e1d4"}
Response from Function Node:
{"topic":"INSERT INTO ACCREQ (\n DATE, TIME, MSGID_ID, DOOR_ID, DOOR_OTP, HASHKEY\n) values (\n '2020-07-06', '20:48:01', '5d9caa65.05e1d4', 1, 1234 ,74657ce6651d26d4650b2da3c16127de6017ed409492fcf62a0a48eee27c2667\n);","payload":{"psa001/d1/user_input ":{"Name ":"Pieter","Surname":"Hattingh","PIN":5054,"OTP":1234,"Door ID":1},"accreq":"74657ce6651d26d4650b2da3c16127de6017ed409492fcf62a0a48eee27c2667"},"qos":0,"retain":false,"_msgid":"5d9caa65.05e1d4"}
Response From DB node
Error: SQLITE_ERROR: unrecognized token: "74657ce6651d26d4650b2da3c16127de6017ed409492fcf62a0a48eee27c2667"
what now?
