# Stackhero-MYSql - Query not working

**URL:** <https://discourse.nodered.org/t/stackhero-mysql-query-not-working/74938>\
**Category:** General\
**Tags:** database\
**Created:** [9 February 2023 12:28 UTC](https://discourse.nodered.org/t/stackhero-mysql-query-not-working/74938 "2023-02-09T12:28:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nico25](https://avatars.discourse-cdn.com/v4/letter/n/d2c977/32.png) [@nico25](https://discourse.nodered.org/u/nico25)\
**Post date:** [9 February 2023 12:28 UTC](https://discourse.nodered.org/t/stackhero-mysql-query-not-working/74938/1 "2023-02-09T12:28:40Z")

</div>

Hi everyone,

I have a very strange problem with the Stackhero-MySQL-Node.

When I pass the query using a simple inject node, it works and I get this reply from the server:

```auto
{"_msgid":"d855ae7a356ff9bc","topic":"SELECT `ID`,`Vorname`,`Nachname` FROM `Users` WHERE `Karte`='8054EE72598B04' ","payload":[{"ID":916,"Vorname":"Nico","Nachname":"1234ABC"}]}

```

Since I want the Query to be dynamic I wrote this function:

```auto

var CardID=flow.get("UserCardID"||0);
if(CardID == 0){
    msg.error= "No Valid Card-ID!!"
    return msg;
}

msg.topic = 'SELECT `ID`,`Vorname`,`Nachname` FROM `Users` WHERE `Karte`='
msg.topic = msg.topic + "'";
msg.topic = msg.topic + CardID;
msg.topic = msg.topic + "' ";
delete msg.payload;
delete msg.port;

return msg;

```

The Query gets processed but I receive an empty array for msg.payload as output:

```auto
{"_msgid":"5925c8104e02c839","topic":"SELECT `ID`,`Vorname`,`Nachname` FROM `Users` WHERE `Karte`='8054EE72598B4' ","payload":[]}

```

 ![grafik](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/0/f0f1b885ea4ebc4e6921f37e01f98beaa2658304.png)

I really can´t tell what I am doing wrong. To me both query look the same. I am sitting over this for more than an hour right now 😅

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [9 February 2023 12:57 UTC](https://discourse.nodered.org/t/stackhero-mysql-query-not-working/74938/2 "2023-02-09T12:57:20Z")

</div>

....98B04 vs ....98B4

---

<div class="post-metadata">

**Author:** ![nico25](https://avatars.discourse-cdn.com/v4/letter/n/d2c977/32.png) [@nico25](https://discourse.nodered.org/u/nico25)\
**Post date:** [10 February 2023 10:07 UTC](https://discourse.nodered.org/t/stackhero-mysql-query-not-working/74938/3 "2023-02-10T10:07:49Z")

</div>

Thank you, I guess I got blind while sitting over it for too long 😃

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [24 February 2023 10:08 UTC](https://discourse.nodered.org/t/stackhero-mysql-query-not-working/74938/4 "2023-02-24T10:08:45Z")

</div>

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