I'm trying to insert a series of large datasets into an SQLite database. My
plan was to loop through the datasets and insert chunks of rows into the
database. I'm trying to get a single row to work and then expand it to work
with blocks of rows.
So far, this works:
v1 = vals[1,1]
v2 = vals[1,2]
v3 = vals[1,3]
v4 = vals[1,4]
query(db,"INSERT INTO tbl VALUES ('$v1','$v2','$v3','$v4')")
I'd like to do something like this:
query(db,"INSERT INTO tbl VALUES ('$vals[1,1:4]')")
My attempt to pass an array gives me an error that the table has 4 columns
but only 1 value was supplied. How do I properly pass the array?
Thanks.
Brandon
