What you may be able to do is to use a case statement(s) which uses a bound variable to either a column or dummy


order by case orderControlValue = 1 then column1 else "" end, ...

On 10/5/2017 11:51 AM, Igor Tandetnik wrote:
On 10/5/2017 2:45 PM, Stephen Chrzanowski wrote:
Given the query:

select EventID, Airline, ContactInfo,TicketID,CreateDate from tEvents where
Resolved=:Resolved order by :OrderBy

I wanted to bind :OrderBy with field names

You can't.  A bound parameter can only appear where a literal is allowed by syntax. Field names you'll have to embed directly into the query.

sqlite-users mailing list

Reply via email to