# SQLite update problem

**URL:** <https://discourse.nodered.org/t/sqlite-update-problem/69030>\
**Category:** General\
**Created:** [14 October 2022 15:37 UTC](https://discourse.nodered.org/t/sqlite-update-problem/69030 "2022-10-14T15:37:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Giamma](https://avatars.discourse-cdn.com/v4/letter/g/e47774/32.png) [@Giamma](https://discourse.nodered.org/u/Giamma)\
**Post date:** [14 October 2022 15:37 UTC](https://discourse.nodered.org/t/sqlite-update-problem/69030/1 "2022-10-14T15:37:14Z")

</div>

Hi,  
this is an update query ...

```auto
const stato2 = "F";
msg.topic = "UPDATE ListaSpesa SET Stato = '" + stato2 + "' WHERE Prodotto = 'Beer'"

```

and it works fine ....  
but if I need to set with a variable (string) the condition Where, how it will be the query?

```auto
const stato2 = "F";
const prodotto = "Beer";
msg.topic = "UPDATE ListaSpesa SET Stato = '" + stato2 + "' WHERE Prodotto = ?????

```

I couldn't do it ....

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [14 October 2022 15:44 UTC](https://discourse.nodered.org/t/sqlite-update-problem/69030/2 "2022-10-14T15:44:13Z")

</div>

```auto
const stato2 = "F";
const prodotto = "Beer";
msg.topic = "UPDATE ListaSpesa SET Stato = '" + stato2 + "' WHERE Prodotto = '" + prodotto + "'"

```

should work  
Or  
You could use string template

```auto
msg.topic = `UPDATE ListaSpesa SET Stato = '${stato2}' WHERE Prodotto = '${prodotto}'`

```

---

<div class="post-metadata">

**Author:** ![Giamma](https://avatars.discourse-cdn.com/v4/letter/g/e47774/32.png) [@Giamma](https://discourse.nodered.org/u/Giamma)\
**Post date:** [14 October 2022 15:47 UTC](https://discourse.nodered.org/t/sqlite-update-problem/69030/3 "2022-10-14T15:47:35Z")

</div>

Works!  
Thank you, thank you very much ....

---

<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:** [28 October 2022 15:48 UTC](https://discourse.nodered.org/t/sqlite-update-problem/69030/4 "2022-10-28T15:48:08Z")

</div>

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