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 suggestions on how I can use a variable in my ORDER BY clause? > Thanks, > Nicole Hinderman > >
Changes to the ORDER BY modify the choice of algorithms used to process the query. This requires that you rerun sqlite3_prepare() in order to generate new code for the virtual machine. -- D. Richard Hipp <[EMAIL PROTECTED]>
