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
E.g
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
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users