lua-users home
lua-l archive

[Date Prev][Date Next][Thread Prev][Thread Next] [Date Index] [Thread Index]


On 11 March 2012 12:06, Jeff Smith <spammealot1@live.co.uk> wrote:
>    stmt = db:prepare[[ INSERT INTO tblApplications (AppFileName, AppBlob,
> GeneralNotes) VALUES( ?, ?, ?)]];
>    stmt:bind_values( someAppName, NULL, someGenNotes)
>    stmt:bind_blob(2, blobStr)

Not directly answering your question, but since you do not define
"NULL" anywhere, it is considered a global variable, and it's value is
"nil" in Lua. So this would be equivalent:

    stmt:bind_values(someAppName, nil, someGenNotes)