[ASK] using variable in SQLite query Corona

Getting Started Newbie Questions
#1

I want to update row table in SQLite database (Corona SDK) using variable, but I have stuck to call variable in query

value = true

i = 1

local q = [[UPDATE keadaan SET status=’]]… ‘value’ …[[’ WHERE id=’]]… ‘i’ …[[’;]]
db:exec( q )

anyone can help me ?

#2

Take the quotes off of value and i.

Rob

#3

Take the quotes off of value and i.

Rob