Jump to content

SQLite Date Error when run in Titanium

BrownX's Photo
Posted Jul 16 2012 05:08 PM
1696 Views

The following SQL code works fine in SQLite Manager and in other SQLite systems, however when I use it in Titanium I get an "Uncaught SyntaxError: Unexpected String." If my syntax is wrong, how should it be coded for Titanium?

SELECT Date, Content FROM MYDATABASE WHERE strftime('%m%d', Date) = strftime('%m%d', date('now'))

Tags:
0 Subscribe


0 Replies