Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight
 
PerlMonks  

Re^7: DBI, and date type SQLite

by Corion (Pope)
on Oct 10, 2011 at 06:25 UTC ( #930536=note: print w/ replies, xml ) Need Help??


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
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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://930536]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (6)
As of 2015-07-07 06:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (87 votes), past polls