Add a text as variable in a SQL query

[admin]

Try this:

Code:

nameparam = dbcon:escape('NameX')
valueparam = 1000

dbcon:execute("INSERT INTO test (name, value) VALUES ('" .. nameparam .. "', " .. valueparam .. ")")