Re^7: DBI, and date type SQLite

in reply to Re^6: DBI, and date type SQLite
in thread DBI, and date type SQLite

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.

Comment on Re^7: DBI, and date type SQLite

Replies are listed 'Best First'.
Re^8: DBI, and date type SQLite by nando (Acolyte) on Oct 10, 2011 at 06:52 UTC
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	[reply]

In Section Seekers of Perl Wisdom