Connection with database error

And what do you think that is telling you?

The mysql node is not finding any matching records where rfidno is equal to E1234562

To me that suggests that ID doesn't appear in the database. But that is something you have to find out.

Ya i got it .Thank You Sir for the solution .thank you very much

I want that String taken and send/pass to my MQTT out node so that i can catch this string in my mqtt subscriber code.how to do that?

What does the MQTT node help text say about how to pass it data to publish?

  • you have already got msg.payload set to the value you want to be published.
  • you have an MQTT out node ready to publish the message to topic you want

So how do you think you might pass a message to the MQTT node?

like putting a mqtt out node in both the change node,am i right?

The great thing with Node-RED is it is really quick and easy to try things.

actually i have run the subscriber code but their i am not able to receive this string

You'll have to explain much more about what you have tried.

I assume you have the MQTT Out node configured with the right topic? And that you have wired the Change nodes to the MQTT Out node?

yes , i am trying onw more time Sir,if not get the output i will ask
thank you Sir

Show us how you have configured the MQTT Out node and put a debug node showing what you are sending to that node.

yes @Colin Sir see this and please tell how can i do this

Please help anyone how can i do this

The screenshot shows you have wired the change nodes to an MQTT node.

So what are you having a problem with?

Shipra - in your screen shot, notice the red triangle on the mqtt-out node? That indicates you haven't configured it properly. You need to
1 - point it at your mqtt broker (like you have done in the mqtt-in node)
2 - define a topic to publish the message to.
NOTE: do not use the same topic that the mqtt-in node uses to prevent a loop from occuring

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.