Unclear error in SQLLITE

[zenzizenzizenzic]

I'm running the following code:

Code: Select all

  local statement= db:prepare([[SELECT author_id FROM item_author WHERE item_id=(:a)]])
  statement:bind_names({a=key})
  statement:dostep()
  authors=statement:get_values()

I keep getting the following error:

Code: Select all

Misuse of function!

Can someone explain exactly what the error is?

Thank you!

(Data is in the DB, and results exist for the query.)

[airsoftsoftwair]

Try sending a PM to lazi. He is the SQL expert here...