I was trying to get a date comparison into a simple select statement.
query = 'select * from telemetry where measured_at < `06/06/2012 11:25:00 AM`;';
I kept getting this "super" informative error message.
Error using database/fetch (line 37)
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
Error in get_DB_conn (line 17)
x = fetch(conn, query);
"Too few parameters". Hmm, I thought I called the function the wrong way. Then again, where statement with other fields worked just fine. Took me sometime to figure out this is a formatting issue. Apparently, I need to place 'special markers' around the date so that it knows it is a date. doh!
Changed to
query = 'select * from telemetry where measured_at < #06/06/2012 11:25:00 AM#;';
and it works fine now.
Maybe it is nice to have this piece of information emphasized somewhere in the documentation?
No comments:
Post a Comment