Michael Welle
2018-05-12 17:32:56 UTC
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
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