Save table on sqlite db?

[Feche1320]

I have this:

  
-- Client 
local x, y, z = getElementPosition(veh) 
local rx, ry, rz = getElementRotation(veh) 
if getDistanceBetweenPoints3D(x, y, z, lx, ly, lz) > 2 then 
    table.insert(recordData, {x = x, y = y, z = z, lx = lx, ly = ly, lz = lz} ) 
    lx = x ly = y lz = z 
end 
-- Server 
dbExec("UPDATE recordings SET time = " ..time.. ", recording = " ..data.. " WHERE account = '" ..account.. "'") -- This line gives me the error 

But I get an error saying that I attempt to conectate a table data value, is there any way? thanks

[Cadu12]

Any variables type?

String, Text or VARCHAR:

[mysql]

1. UPDATE table SET TIME='1111'

[/mysql]

Int:

[mysql]

1. UPDATE table SET TIME=1111

[/mysql]

[Feche1320]

I want to save the WHOLE table on the sqlite db

dbExec(db, "CREATE TABLE IF NOT EXISTS recordings (account TEXT, time INTEGER, recording STORAGE)") 

[DiSaMe]

Correct me if I'm wrong, but there's no data type "storage" in SQL. As for table, of course can't simply concatenate it into the string. This is not a good way to organize your database structure, anyway. But if you still want to make it like that, you can convert the table to a string and vice-versa using these functions:

toJSON 
fromJSON 

And the last thing to say, do not concatenate the values directly into the query string. Pass them as separate arguments into dbExec to avoid code injection.

[Feche1320]

Done, thank you!