Hi, there I am very new to node red and this is first message here I want to build database then want to store some values inside database and then want to read database and compare with inject value then if it is same then debug true can you please guide me how to do it and if there is an exampl…

The payload isn't a string if the message exists, it is an array of length 1. If there were multiple matching records then there would be one element for each record. However, since all you are interested in is whether a record exists or not I think you would be better using the query SELECT cou…

I want to get value from mqtt and insert inside variable (check) then msg.topic= "SELECT * FROM tab WHERE name = 'check'"; but it is not working

So how are you attempting to do that? Without showing your code we can not help.

[{"id":"d7bd381c.a59b28","type":"tab","label":"Flow 4","disabled":false,"info":""},{"id":"b454bc8.2a2c94","type":"switch","z":"d7bd381c.a59b28","name":"","property":"payload","propertyType":"msg","rules":[{"t":"cont","v":"10","vt":"str"}],"checkall":"true","repair":false,"outputs":1,"x":470,"y":180,…

This is a diffrent question than you originally asked. You canstart by putting the value you want to search for in msg.payload/ Then using a CHANGE node you can set the topic by building the sql statement using the json expression. Something like "SELECT * FROM tab WHERE name = '" & $.payload & "';…

@zenofmud my question now how to compare msg.payload with a variable value using switch node? https://discourse.nodered.org/uploads/short-url/ksLUSqtzWQnrt5Oncd2S3prCorg.png

"Contains" in the switch node is for testing if a string contains another string, for example payload might be "abcde" and the Contains might be "bcd". If you are actually looking for equal to a variable value then select == then click on the dropdown to the right and you can select msg. something.…

@Colin thank so much it getting working with switch node comparing with variable

I'm looking for the same solution, could you maybe share your code?

[image] Andre: I'm looking for the same solution, could you maybe share your code? Several different questions were addressed in this thread. It would be a good idea to make it clear what particular problem you are trying to solve. However do please read right through the thread and see if …

Node-RED

Node-RED Forum

I have some questions relating database

General

Colin 1 December 2018 09:25 55

You flow is not importable. Please see this on how to share your flow.

Topic		Replies	Views
Saving Data in DB at SQLite Function - Help! General	60	8411	7 December 2020
Connection with database error General	115	2873	3 August 2020
Read from mysql db Dashboard	54	17621	23 December 2018
Need Help to Insert, Update and Delete Data from Node-RED Dashboard Inputs to the Database Dashboard	34	19111	3 May 2019
How to compare two msg.payload in a same flow General	26	14097	8 July 2020

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

I have some questions relating database

Related topics