Page 1 of 1

Unclear error in SQLLITE

Posted: Sun Mar 31, 2019 5:33 pm
by 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.)

Re: Unclear error in SQLLITE

Posted: Tue Apr 02, 2019 10:15 pm
by airsoftsoftwair
Try sending a PM to lazi. He is the SQL expert here...