HI everyone
Am trying to insert varaiable data through form ui to sqlite , but its not working .pls help me out
thanks in advance
I think you want to make like this.
i share you the code.
[{"id":"39c40dcef896fa99","type":"ui_form","z":"698c69548f0b524c","name":"","label":"","group":"bc09249168d821ac","order":4,"width":0,"height":0,"options":[{"label":"name","value":"name","type":"text","required":true,"rows":null},{"label":"age","value":"age","type":"number","required":true,"rows":null}],"formValue":{"name":"","age":""},"payload":"","submit":"submit","cancel":"cancel","topic":"topic","topicType":"msg","splitLayout":"","className":"","x":480,"y":220,"wires":[["6644a8c393171d19","c41b7fe9dbcb9e39"]]},{"id":"c41b7fe9dbcb9e39","type":"function","z":"698c69548f0b524c","name":"function 42","func":"msg.topic = `INSERT INTO user (name, age) VALUES ($name, $surname)`\nmsg.payload = [msg.payload.name, msg.payload.age]\nreturn msg;\n// return msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":630,"y":220,"wires":[["70bbd3e3decad314"]]},{"id":"6644a8c393171d19","type":"debug","z":"698c69548f0b524c","name":"debug 86","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":630,"y":140,"wires":[]},{"id":"70bbd3e3decad314","type":"sqlite","z":"698c69548f0b524c","mydb":"ea8cf61559215e94","sqlquery":"msg.topic","sql":"INSERT INTO (name, age) VALUES ('{{paylaod.name}}', {{payload.age}})","name":"","x":770,"y":220,"wires":[["428cc0525a8351ed"]]},{"id":"428cc0525a8351ed","type":"debug","z":"698c69548f0b524c","name":"debug 87","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":900,"y":220,"wires":[]},{"id":"3c708203e102f8d0","type":"inject","z":"698c69548f0b524c","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":500,"y":280,"wires":[["692aac2a6df6b18a"]]},{"id":"692aac2a6df6b18a","type":"sqlite","z":"698c69548f0b524c","mydb":"ea8cf61559215e94","sqlquery":"fixed","sql":"SELECT * FROM user","name":"","x":680,"y":280,"wires":[["0f96ddd5c2fe6c28"]]},{"id":"0f96ddd5c2fe6c28","type":"debug","z":"698c69548f0b524c","name":"debug 88","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":860,"y":280,"wires":[]},{"id":"bc09249168d821ac","type":"ui_group","name":"Patient","tab":"7dcc246f.ee661c","order":1,"disp":false,"width":"24","collapse":false,"className":""},{"id":"ea8cf61559215e94","type":"sqlitedb","db":"ok","mode":"RWC"},{"id":"7dcc246f.ee661c","type":"ui_tab","name":"TEST","icon":"dashboard","order":3,"disabled":false,"hidden":false}]
k ,let me try this
hi , now i am able insert data through , can u clarify in ur code , debug panel it is showing array(2), but am not able to get any valu in array ,but when i enter in form ui and submit now , data is showing in db
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
