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

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.

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

Replies are listed 'Best First'.
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]