Re^7: DBI, and date type SQLite

[Corion]

Using a placeholder within the ORDER BY clause happens to work with for example MySQL, but is not supported everywhere. Specifically when preparing a statement, the database driver must be enabled to create a query plan for the statement, whether placeholders are present or not. Placeholders for (e.g.) the table name or the order by clause prevent that.

[nando]

Thank you. There are many details to consider ... Therefore it is very interesting ;)

NetWallah has proven that we can use placeholder with SQLite driver in clause ORDER BY