dbExecAwait

Syntax

Arguments

connectionelement

A connection from dbConnect.

querystring

An SQL query with ? placeholders.

...mixed, optional

Values for the ? placeholders.

Returns

true, affected rows, insertId; false and an error message if the write failed.

Example

async(function()
    local ok, rows, id = dbExecAwait(db, "INSERT INTO cars (owner, model) VALUES (?, ?)", "Jan", 411)
    if ok then print("nowe auto nr " .. id) else print("błąd: " .. tostring(rows)) end
end)

See also

• dbExecRuns a query that returns no result (INSERT, UPDATE, CREATE). Arguments replace the ? placeholders.
• dbTransactionRuns several queries as one transaction. The function receives a tx object with the tx:query, tx:queryOne and tx:exec methods. An SQL error, error() or return false inside the function rolls back every change.
• dbQuerySends a query that returns a result. Collect it with dbPoll or in a callback that receives the query handle.