From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Welle <mwe012008@gmx.net>
Subject: ob-sql, quoting SQL wildcards
Date: Sat, 12 May 2018 19:32:56 +0200
Message-ID: <87sh6wvkxj.fsf@luisa.c0t0d0s0.de>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:43733)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <mwe012008@gmx.net>) id 1fHYON-00083h-4D
	for emacs-orgmode@gnu.org; Sat, 12 May 2018 13:33:11 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <mwe012008@gmx.net>) id 1fHYOI-0001KO-8O
	for emacs-orgmode@gnu.org; Sat, 12 May 2018 13:33:11 -0400
Received: from mout.gmx.net ([212.227.17.20]:47321)
	by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_128_CBC_SHA1:16)
	(Exim 4.71) (envelope-from <mwe012008@gmx.net>) id 1fHYOH-0001Jg-V0
	for emacs-orgmode@gnu.org; Sat, 12 May 2018 13:33:06 -0400
Received: from stella.c0t0d0s0.de ([89.204.154.128]) by mail.gmx.com (mrgmx103
	[212.227.17.168]) with ESMTPSA (Nemesis) id 0MQ2Tn-1fCLb32HWV-005HIs
	for <emacs-orgmode@gnu.org>; Sat, 12 May 2018 19:33:02 +0200
Received: from Stella (stella.c0t0d0s0.de [192.168.42.1])
	by stella.c0t0d0s0.de (Postfix) with ESMTP id 0EBB9C431B
	for <emacs-orgmode@gnu.org>; Sat, 12 May 2018 19:32:57 +0200 (CEST)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode/>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: "Emacs-orgmode"
	<emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: emacs-orgmode@gnu.org

Hello,

I try to fetch some values from an sqlite database (want to grab some
statistics from Zotero ;)):

#+begin_src sqlite :db zotero.sqlite
select value from itemdatavalues where lower(value) like '%gelesen%';
#+end_src

The SQL wildcards cause trouble:

Evaluate this sqlite code block on your system? (y or n) y
executing Sqlite code block...
Wrote /tmp/tmp_welle/babel-82601NB/ob-input-8260GeN
org-babel-read: End of file during parsing


I guess I have to quote the wildcards. But how?

Regards
hmw