Re: [sqlite] prepared statemnt for column names and sorting preference

On Thu, 5 Dec 2013 13:48:36 +0400 d b wrote: > Now, I want to write prepared statement for above query. > > select * from emp order by ? ?; //I want to substitute column name > and sorting preference. Remember that parameters stand for data, not SQL. You can use a

Re: [sqlite] prepared statemnt for column names and sorting preference

ANNOT call sqlite3_bind_xxx() after sqlite3_step() has been called). -Ursprüngliche Nachricht- Von: d b [mailto:va230...@gmail.com] Gesendet: Donnerstag, 05. Dezember 2013 10:49 An: sqlite-users@sqlite.org Betreff: [sqlite] prepared statemnt for column names and sorting preference Hi,

[sqlite] prepared statemnt for column names and sorting preference

Hi, select * from emp order by empid desc; //here empid is column name among clolumns. Now, I want to write prepared statement for above query. select * from emp order by ? ?; //I want to substitute column name and sorting preference. is it possible with sqlite? thanks, a