Re: [sqlite] binding ORDER BY

On Mon, 2005-09-19 at 09:42 -0500, [EMAIL PROTECTED] wrote: > I am trying to 'ORDER BY ?' in my query because I would like to bind the > order by criteria later in my code. This always fails on sqlite3_prepare() > with an error, "ORDER BY terms must be non-integer constants". Do you have > any su

[sqlite] binding ORDER BY

I am trying to 'ORDER BY ?' in my query because I would like to bind the order by criteria later in my code. This always fails on sqlite3_prepare() with an error, "ORDER BY terms must be non-integer constants". Do you have any suggestions on how I can use a variable in my ORDER BY clause? Thanks,