Re^6: Debian DBD::ODBC select row by timestamp

Yes.

use strict;
use warnings;
use DBI;
use Data::Dumper;
use JSON::XS;

my $dbh = DBI->connect
  (q{DBI:ODBC:test})
  or die $DBI::errstr;

my $sth = $dbh-> prepare("SELECT val from buf WHERE dd_mm_yyyy= ? ") o
+r die $dbh->errstr();
$sth->execute('2012-07-22 00:00:00') or die $dbh->errstr();
my $table;
my $tbl_ary_ref;
$tbl_ary_ref = $sth->fetchall_arrayref;
     if (defined $tbl_ary_ref){
         $table->{date} = $tbl_ary_ref;
     }
    $tbl_ary_ref  = encode_json $table;
    print qq{JSON-------------------JSON\n};
    print $tbl_ary_ref."\n";
    
$sth->finish;
$dbh->disconnect;
[download]

And output:

Error at Line : syntax error near ?
JSON-------------------JSON
{"date":[]}
[download]

Comment on Re^6: Debian DBD::ODBC select row by timestamp Select or Download Code

Replies are listed 'Best First'.
Re^7: Debian DBD::ODBC select row by timestamp by mje (Curate) on Jul 24, 2012 at 12:13 UTC
That Perl looks syntactically correct to me so I assume the message comes from MS Access and yet if that were the case your script would have died at line 11 or 12. The output with the JSON seems to confirm that. Are you sure that is the script you are running?	[reply]
Re^8: Debian DBD::ODBC select row by timestamp by alexx_sh (Novice) on Jul 24, 2012 at 12:20 UTC
Yes i check script. And i can't undestand why it dosn't work. How enable debug output in unixodbc? So if i edit script: `SELECT val from buf WHERE (dd_mm_yyyy= {ts '2012-07-22 00:00:00'})` i have output like this `Calling mdb_test_sarg on unknown type. Add code to mdb_test_sarg() fo +r type 8 Calling mdb_test_sarg on unknown type. Add code to mdb_test_sarg() fo +r type 8 JSON-------------------JSON {"date":[[""],[""]]}` [download] I think it's driver error libmdbodbc. Seemed it don't work properly.	[reply] [d/l] [select]
Re^9: Debian DBD::ODBC select row by timestamp by mje (Curate) on Jul 24, 2012 at 14:14 UTC
Ah, you are using mdbtools. Might have been useful to state that up front. In my experience mdbtools is not very good and the only alternative I know is not free. To enabled logging in unixODBC edit your odbcinst.ini file (find it with odbcinst -j) and add: `[ODBC] Trace=yes TraceFile=/tmp/unixodbc.log` [download] to the top of it.	[reply] [d/l]