Help! system.db.runPrepUpdate error

Ignition
1

Hi, I have this database created and I want to insert data but I get error

[i]CREATE TABLE inventory
(
id int NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL,
description varchar(255) not null,

PRIMARY KEY (id)
)[/i]

I have a button to insert data into the db, this is the script

[color=#4000BF]name= event.source.parent.getComponent(‘name’).text
description = event.source.parent.getComponent(‘description’).text

system.db.runPrepUpdate(“INSERT INTO inventory (name,description) VALUES (?,?)”,[name],[description])[/color]

I get the following error

[color=#FF0000]Traceback (most recent call last):

File “event:actionPerformed”, line 5, in

java.lang.Exception: java.lang.Exception: Error executing system.db.runPrepUpdate(INSERT INTO inventory (name,description) VALUES (?,?), [Product1], [u’Description1’], , false, false)

caused by Exception: Error executing system.db.runPrepUpdate(INSERT INTO inventory (name,description) VALUES (?,?), [Product1], [u'Description1'], , false, false)
caused by GatewayException: Connection Error: Datasource "[u'Description1']" does not exist in this Gateway.
caused by SQLException: Datasource "[u'Description1']" does not exist in this Gateway.

Ignition v7.6.4 (b2013112117)
Java: Oracle Corporation 1.7.0_25[/color]

2

You need one list of values, not two lists.

Change your function call to this:

system.db.runPrepUpdate("INSERT INTO inventory (name,description) VALUES (?,?)",[name, description])
3

Thanks a lot that worked!