in reply to Debian DBD::ODBC select row by timestamp
This happens because your SQL contains colons and ':' is a placeholder introducer. There are 2 ways to fix it. 1) replace '2012-07-22 00:00:00 ' (BTW, notice trailing space) with ? and call execute passing '2012-07-22 00:00:00' as an argument (read about placeholders in DBI). 2) set odbc_ignore_named_placeholders. The first is best.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Debian DBD::ODBC select row by timestamp
by alexx_sh (Novice) on Jul 23, 2012 at 17:09 UTC | |
by CountZero (Bishop) on Jul 23, 2012 at 17:19 UTC | |
by alexx_sh (Novice) on Jul 24, 2012 at 05:38 UTC | |
by mje (Curate) on Jul 24, 2012 at 08:02 UTC | |
by alexx_sh (Novice) on Jul 24, 2012 at 09:18 UTC | |
|
In Section
Seekers of Perl Wisdom