# Error during inject into database

**URL:** <https://discourse.nodered.org/t/error-during-inject-into-database/47205>\
**Category:** General\
**Created:** [15 June 2021 21:04 UTC](https://discourse.nodered.org/t/error-during-inject-into-database/47205 "2021-06-15T21:04:36Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![sarah](https://avatars.discourse-cdn.com/v4/letter/s/9de053/32.png) [@sarah](https://discourse.nodered.org/u/sarah)\
**Post date:** [15 June 2021 21:04 UTC](https://discourse.nodered.org/t/error-during-inject-into-database/47205/1 "2021-06-15T21:04:37Z")

</div>

Hi there!

I'm creating flow to get csv data from opengov website. the csv data contain daily vaccination and I want to put into my database, during the process I face some problem regarding the rows that I want to exclude. Here I want to exclude rows based on column state\_id which contain 0(if (state\_id !== 0)), but here the "Error: A query must have either text or a name. Supplying neither is unsupported." appears when inject into the database.  
Any suggestion?  
thanks before!

```auto
var date = msg.payload.date;
var state_id = msg.payload.stateid;
var registered = msg.payload.regist;
//var registered_per100 = msg.payload.regist_per100;
var partly_vac = msg.payload.partly_vac;
//var partly_vac_per100 = msg.payload.partly_vac_per100;
var group_U25_m = msg.payload.group_u25_m1;
var group_U25_w = msg.payload.group_u25_w1;
var group_25_34_m = msg.payload.group_25_34_m1;
var group_25_34_w = msg.payload.group_25_34_w1;
var group_35_44_m = msg.payload.group35_44_m1;
var group_35_44_w = msg.payload.group35_44_w1;
var group_45_54_m = msg.payload.group45_54_m1;
var group_45_54_w = msg.payload.group45_54_w1;
var group_55_64_m = msg.payload.group55_64_m1;
var group_55_64_w = msg.payload.group55_64_w1;
var group_65_74_m = msg.payload.group65_74_m1;
var group_65_74_w = msg.payload.group65_74_w1;
var group_75_84_m = msg.payload.group75_84_m1;
var group_75_84_w = msg.payload.group75_84_w1;
var group_A84_m = msg.payload.groupo84_m1;
var group_A84_w = msg.payload.groupo84_w1;
var Vac_Pfizer = msg.payload.pfizer1;
var Vac_Moderna = msg.payload.moderna1;
var Vac_AstraZeneca = msg.payload.astrazeneca1;
//var population = msg.payload.population;
var lander = msg.payload.state;

//var group_u25 = group_U25_m + group_U25_w;//

var insertStatement = "";
var deleteStatement = "";
var updateMviewStatement = "";

if (state_id !== 0){

insertStatement += "INSERT INTO s1078805.covid19_vac_daily (date, state_id, registered, partly_vac, group_U25_m, group_U25_w, group_25_34_m, group_25_34_w, group_35_44_m, group_35_44_w, group_45_54_m, group_45_54_w, group_55_64_m, group_55_64_w, group_65_74_m, group_65_74_w, group_75_84_m, group_75_84_w, group_A84_m, group_A84_w, Vac_Pfizer, Vac_Moderna, Vac_AstraZeneca, lander) VALUES ('" + date + "'," + state_id + "," + registered + "," + partly_vac + ", " + group_U25_m + ", " + group_U25_w + ", " + group_25_34_m + ", " + group_25_34_w + ", " + group_35_44_m + ", " + group_35_44_w + ", " + group_45_54_m + ", " + group_45_54_w + ", " + group_55_64_m + ", " + group_55_64_w + ", " + group_65_74_m + ", " + group_65_74_w + ", " + group_75_84_m + ", " + group_75_84_w + ", " + group_A84_m + ", " + group_A84_w + ", " + Vac_Pfizer + ", " + Vac_Moderna + ", " + Vac_AstraZeneca + ",'" + lander + "');";

msg.payload = insertStatement;
}
return msg;

```

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/8/f84949ebf5aecf79a125329acc202ff2d530d2bb.png)

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [15 June 2021 22:10 UTC](https://discourse.nodered.org/t/error-during-inject-into-database/47205/2 "2021-06-15T22:10:12Z")

</div>

[Which postgres node](https://flows.nodered.org/search?term=postgre&type=node) are you using?

NOTE: I use `node-red-contrib-postgrestor-next` or `@digitaloak/node-red-contrib-digitaloak-postgresql` without issue.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [15 June 2021 22:12 UTC](https://discourse.nodered.org/t/error-during-inject-into-database/47205/3 "2021-06-15T22:12:30Z")

</div>

PS: it is quite likely `state_id` is zero and your `insertStatement` is not being set.

Add `node.warn("state_id = " + state_id );` above `if (state_id !== 0){` the check the debug sidebar

---

<div class="post-metadata">

**Author:** ![sarah](https://avatars.discourse-cdn.com/v4/letter/s/9de053/32.png) [@sarah](https://discourse.nodered.org/u/sarah)\
**Post date:** [15 June 2021 22:39 UTC](https://discourse.nodered.org/t/error-during-inject-into-database/47205/4 "2021-06-15T22:39:35Z")

</div>

Hi, thank you for your reply!

I use node-red-contrib-re-postgres, the csv somehow already in database but the error message still comes up, I check the last data is yesterday, so it's actually working. When not injected into the DB, the error not showing up as well.  
I check as you suggest, the `state_id` seems setted up.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/c/eca1bbe51a4605582059161781d809719b923b0b.png)

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [16 June 2021 06:14 UTC](https://discourse.nodered.org/t/error-during-inject-into-database/47205/5 "2021-06-16T06:14:09Z")

</div>

So I was correct. You SQL statement was not created because the state\_id value is 0.

Look at your payload, it is not a SQL statement. That's why you get the error. The payload is still an object (not SQL)

I believe you need to move the `return msg` inside the `if` block so that when state\_id is 0 you don't send the `msg` to the database.

---

<div class="post-metadata">

**Author:** ![sarah](https://avatars.discourse-cdn.com/v4/letter/s/9de053/32.png) [@sarah](https://discourse.nodered.org/u/sarah)\
**Post date:** [16 June 2021 09:53 UTC](https://discourse.nodered.org/t/error-during-inject-into-database/47205/6 "2021-06-16T09:53:12Z")

</div>

Hi Steve! thank you it works now!

---

<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:** [30 June 2021 09:53 UTC](https://discourse.nodered.org/t/error-during-inject-into-database/47205/7 "2021-06-30T09:53:25Z")

</div>

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