SQL Insert error

Ignition
1

Hi,
I’m trying to run a
system.db.runPrepUpdate(“INSERT INTO table (col1,col2,col3) values (?,?,?)” [x,y,z])
col1 and col3 are strings and col2 is date
I get the error “str indices must be integers”
I’ve used this method before and i never had this issue. any idea why?
I did some research online but couldn’t find an answer to my issue…
Thanks in advance

2

It looks like you are missing a comma between the SQL statement and arguments.

Try:

system.db.runPrepUpdate("INSERT INTO table (col1,col2,col3) values (?,?,?)", [x,y,z])
2 Likes
3

Oh wait, sure does like like my Idiot meter was running high… wow… how I missed that I have no idea lol. Thanks for the help!!:+1: