emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[O] ob-sql, quoting SQL wildcards


From: Michael Welle
Subject: [O] ob-sql, quoting SQL wildcards
Date: Sat, 12 May 2018 19:32:56 +0200
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/25.3.50 (gnu/linux)

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



reply via email to

[Prev in Thread] Current Thread [Next in Thread]