[PATCH 5/7] bookmarks: Implement search all elements
- From: "Juan A. Suarez Romero" <jasuarez igalia com>
- To: grilo-list gnome org
- Subject: [PATCH 5/7] bookmarks: Implement search all elements
- Date: Thu, 3 Feb 2011 10:40:44 +0100
Signed-off-by: Juan A. Suarez Romero <jasuarez igalia com>
---
src/bookmarks/grl-bookmarks.c | 8 ++++++--
1 files changed, 6 insertions(+), 2 deletions(-)
diff --git a/src/bookmarks/grl-bookmarks.c b/src/bookmarks/grl-bookmarks.c
index c3baf16..e14a078 100644
--- a/src/bookmarks/grl-bookmarks.c
+++ b/src/bookmarks/grl-bookmarks.c
@@ -95,7 +95,8 @@ GRL_LOG_DOMAIN_STATIC(bookmarks_log_domain);
"SELECT b1.*, count(b2.parent <> '') " \
"FROM bookmarks b1 LEFT OUTER JOIN bookmarks b2 " \
" ON b1.id = b2.parent " \
- "WHERE b1.title LIKE '%%%s%%' OR b1.desc LIKE '%%%s%%' " \
+ "WHERE (b1.title LIKE '%%%s%%' OR b1.desc LIKE '%%%s%%') " \
+ " AND b1.type = 1 " \
"GROUP BY b1.id " \
"LIMIT %u OFFSET %u"
@@ -508,7 +509,10 @@ produce_bookmarks_by_text (OperationSpec *os, const gchar *text)
gchar *sql;
GRL_DEBUG ("produce_bookmarks_by_text");
sql = g_strdup_printf (GRL_SQL_GET_BOOKMARKS_BY_TEXT,
- text, text, os->count, os->skip);
+ text? text: "",
+ text? text: "",
+ os->count,
+ os->skip);
produce_bookmarks_from_sql (os, sql);
g_free (sql);
}
--
1.7.3.5
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]