Hi Anirban,
Anirban Sarkar wrote:
Hi all,
I have a variable xyz with the value 100.
I want to write a sql statement in sqlite where the variable xyz should be in the 'where' clause. For eg:
select * from 'tablename' where 'fieldname' = $xyz
What language are you using?
You might want to use the sqlite3_bind_int API.
http://www.sqlite.org/capi3ref.html
HTH
Ulrik P.