# SQL INSERT INTO... WHERE.... Statement

**URL:** <https://forum.inductiveautomation.com/t/sql-insert-into-where-statement/8487>\
**Category:** Ignition\
**Created:** [May 22, 2014, 3:45pm UTC](https://forum.inductiveautomation.com/t/sql-insert-into-where-statement/8487 "2014-05-22T15:45:15Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![tbackus](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tbackus/32/5091_2.png) [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\
**Post date:** [May 22, 2014, 3:45pm UTC](https://forum.inductiveautomation.com/t/sql-insert-into-where-statement/8487/1 "2014-05-22T15:45:15Z")

</div>

This below statement works great.

system.db.runPrepUpdate(“INSERT INTO QC\_CupMeasurements\_Temp (testValue) VALUES (?)”, [testValue],“Ignition”)

But I want to add “WHERE sampleID = somevariable”

Whats the syntax? I know I am going to facepalm when I see it.

---

<div class="post-metadata">

**Author:** ![adamaustin](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@adamaustin](https://forum.inductiveautomation.com/u/adamaustin)\
**Post date:** [May 22, 2014, 4:35pm UTC](https://forum.inductiveautomation.com/t/sql-insert-into-where-statement/8487/2 "2014-05-22T16:35:35Z")

</div>

Try this:

```auto
INSERT INTO QC_CupMeasurements_Temp (testValue)
SELECT something FROM sometable
WHERE sampleID = somevariable
```

---

<div class="post-metadata">

**Author:** ![tbackus](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tbackus/32/5091_2.png) [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\
**Post date:** [May 22, 2014, 5:22pm UTC](https://forum.inductiveautomation.com/t/sql-insert-into-where-statement/8487/3 "2014-05-22T17:22:44Z")

</div>

adamaustin, I get the SQL syntax, I was referring to the syntax as it relates to putting the SQL statement within the system.db.runPrepUpdate statement.

---

<div class="post-metadata">

**Author:** ![tbackus](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tbackus/32/5091_2.png) [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\
**Post date:** [May 22, 2014, 6:14pm UTC](https://forum.inductiveautomation.com/t/sql-insert-into-where-statement/8487/4 "2014-05-22T18:14:57Z")

</div>

Specifically here is my issue:

`sampleID1 = 02-20140522100349
t1Leak1 = 25
system.db.runPrepUpdate("INSERT INTO QC_CupMeasurements_Temp (t1Leak) VALUES (?) SELECT sampleID,t1Leak FROM QC_CupMeasurements_Temp WHERE (sampleID) = (?)", (t1Leak1),(sampleID1),"Ignition")
`

Result is an error:

[code]Traceback (most recent call last):  
File “”, line 3, in   
java.lang.ClassCastException: java.lang.ClassCastException: Cannot coerce value ‘25’ into type: class [Ljava.lang.Object;

```
caused by ClassCastException: Cannot coerce value '25' into type: class [Ljava.lang.Object;

```

Ignition v7.6.4 (b2013112117)  
Java: Oracle Corporation 1.7.0\_51  
[/code]

---

<div class="post-metadata">

**Author:** ![adamaustin](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@adamaustin](https://forum.inductiveautomation.com/u/adamaustin)\
**Post date:** [May 22, 2014, 6:15pm UTC](https://forum.inductiveautomation.com/t/sql-insert-into-where-statement/8487/5 "2014-05-22T18:15:37Z")

</div>

Try:

```auto
system.db.runPrepUpdate("""INSERT INTO QC_CupMeasurements_Temp (testValue) 
SELECT something FROM sometable 
WHERE sampleID = ?""", [somevariable],"Ignition")
```

---

<div class="post-metadata">

**Author:** ![adamaustin](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@adamaustin](https://forum.inductiveautomation.com/u/adamaustin)\
**Post date:** [May 22, 2014, 6:19pm UTC](https://forum.inductiveautomation.com/t/sql-insert-into-where-statement/8487/6 "2014-05-22T18:19:27Z")

</div>

Try:

```auto
system.db.runPrepUpdate("INSERT INTO QC_CupMeasurements_Temp (SAMPLEID, t1Leak) SELECT sampleID, ? FROM QC_CupMeasurements_Temp WHERE (sampleID) = (?)", [t1Leak1,sampleID1],"Ignition")
```

---

<div class="post-metadata">

**Author:** ![tbackus](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tbackus/32/5091_2.png) [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\
**Post date:** [May 23, 2014, 6:12pm UTC](https://forum.inductiveautomation.com/t/sql-insert-into-where-statement/8487/7 "2014-05-23T18:12:23Z")

</div>

I wanted to use UPDATE not INSERT…

DOH!!