[sqlite] binding ORDER BY

[njhinder]

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