# Switching delete to write a 1 in hidden column

**URL:** <https://forum.inductiveautomation.com/t/switching-delete-to-write-a-1-in-hidden-column/56171>\
**Category:** Ignition\
**Created:** [February 15, 2022, 3:50pm UTC](https://forum.inductiveautomation.com/t/switching-delete-to-write-a-1-in-hidden-column/56171 "2022-02-15T15:50:29Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\
**Post date:** [February 15, 2022, 3:50pm UTC](https://forum.inductiveautomation.com/t/switching-delete-to-write-a-1-in-hidden-column/56171/1 "2022-02-15T15:50:29Z")

</div>

I don’t want to delete row. I just want to hide it.

so right now, I have 6/11 column names as param when I have selected a row

```auto
Param = {
 "ColumnName": self.parent.parent.getchild("Table".props.selection.data[0].Columnname,
.
.
.
"ColumnNameN": self.parent.parent.getchild("Table".props.selection.data[0].ColumnnameN,

}
system.db.runNamedQuery("DeleteSelectedRow", params)

```

I plan to add a column of Hidden, and I need a script to write a 1 to this column instead of deleting the row.  
I just do an insert into query right?  
use the params to determine the row in the where clause, and insert my 1 value into the hidden column right?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 15, 2022, 3:52pm UTC](https://forum.inductiveautomation.com/t/switching-delete-to-write-a-1-in-hidden-column/56171/2 "2022-02-15T15:52:42Z")

</div>

No, updating a value in an existing row is an UPDATE query. INSERT makes new rows.

---

<div class="post-metadata">

**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\
**Post date:** [February 15, 2022, 3:54pm UTC](https://forum.inductiveautomation.com/t/switching-delete-to-write-a-1-in-hidden-column/56171/3 "2022-02-15T15:54:30Z")

</div>

Thanks

a button that passes the selected parameters to run an update query is not opening my page up to injection attack right?

In my other queries I can say in the where clause hidden = 0, but will I have to place hidden in the select and then make a subquery to make the query not show that column? Edit: I tested, I can just place it in the where

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 15, 2022, 4:02pm UTC](https://forum.inductiveautomation.com/t/switching-delete-to-write-a-1-in-hidden-column/56171/4 "2022-02-15T16:02:18Z")

</div>

No, a column can be in the WHERE clause without being in the SELECT item list.

---

<div class="post-metadata">

**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\
**Post date:** [February 15, 2022, 4:08pm UTC](https://forum.inductiveautomation.com/t/switching-delete-to-write-a-1-in-hidden-column/56171/5 "2022-02-15T16:08:01Z")

</div>

the button runs the script, but the script is never accessible from the page right?  
So no risk of injection attack if the button runs an update ?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 15, 2022, 4:12pm UTC](https://forum.inductiveautomation.com/t/switching-delete-to-write-a-1-in-hidden-column/56171/6 "2022-02-15T16:12:42Z")

</div>

You are using value parameters in Named Queries? Or “Prep” updates? Then you are fine.

---

<div class="post-metadata">

**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\
**Post date:** [February 15, 2022, 4:52pm UTC](https://forum.inductiveautomation.com/t/switching-delete-to-write-a-1-in-hidden-column/56171/7 "2022-02-15T16:52:41Z")

</div>

I use runNamedQuery and pass the parameters, but the query will be an update type to write the value 1 to the Hidden column which is a bit datatype

`system.db.runNamedQuery("HideSelectedRow", params)`