[Digikam-devel] advanced search calendar widget

[Marcel Wiesweg]

> 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.

Marcel