[Digikam-devel] advanced search calendar widget

Marcel Wiesweg marcel.wiesweg at gmx.de
Tue Jun 27 18:29:25 BST 2006

> It comes out with sqlite error:
> sqlite_compile error: near ")": syntax error on query: SELECT
> Albums.url||'/'||Images.name FROM Images, Albums LEFT JOIN
> ImageProperties on Images.id = ImageProperties.imageid WHERE ( ) AND
> (Albums.id=Images.dirid) LIMIT 500;
> SQLite doesn't like GE/LE (greater or equal, lesser or equal) on DATE
> objects or something was missed?

The sqlite3 tool is very fast and effective to test database queries.
In the above query, sqlite does not like the empty "( ) AND" part, where 
something seems to be missing while constructing the query.


More information about the Digikam-devel mailing list