Code: Select all
local statement=db:prepare([[SELECT sort_name, Name from Author where Name LIKE :za ]])
statement:bind_names({za=filter})
I get full results when I remove the "where Name LIKE :za".
Also, I get results when I run the SQL in the SQLMan with the like included.
The value of filter I pass in for testing is
Code: Select all
'%a%'