Author: akv
Date: 2009-12-18 22:29:02 +0100 (Fri, 18 Dec 2009)
New Revision: 2795
Modified:
trunk/src/rs-library.c
Log:
Made searches in library case insensitive.
Modified: trunk/src/rs-library.c
===================================================================
--- trunk/src/rs-library.c 2009-12-16 21:53:00 UTC (rev 2794)
+++ trunk/src/rs-library.c 2009-12-18 21:29:02 UTC (rev 2795)
@@ -430,7 +430,7 @@
{
tag = (gchar *) g_list_nth_data(tags, n);
- sqlite3_prepare_v2(db, "insert into filter select
phototags.photo from phototags, tags where phototags.tag = tags.id and
tags.tagname = ?1;", -1, &stmt, NULL);
+ sqlite3_prepare_v2(db, "insert into filter select
phototags.photo from phototags, tags where phototags.tag = tags.id and
lower(tags.tagname) = lower(?1) ;", -1, &stmt, NULL);
rc = sqlite3_bind_text(stmt, 1, tag, strlen(tag),
SQLITE_TRANSIENT);
rc = sqlite3_step(stmt);
sqlite3_finalize(stmt);
_______________________________________________
Rawstudio-commit mailing list
[email protected]
http://rawstudio.org/cgi-bin/mailman/listinfo/rawstudio-commit
