all messages for Emacs-related lists mirrored at yhetil.org
 help / color / mirror / code / Atom feed
* ob-sql, quoting SQL wildcards
@ 2018-05-12 17:32 Michael Welle
  0 siblings, 0 replies; only message in thread
From: Michael Welle @ 2018-05-12 17:32 UTC (permalink / raw)
  To: emacs-orgmode

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

^ permalink raw reply	[flat|nested] only message in thread

only message in thread, other threads:[~2018-05-12 17:33 UTC | newest]

Thread overview: (only message) (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2018-05-12 17:32 ob-sql, quoting SQL wildcards Michael Welle

Code repositories for project(s) associated with this external index

	https://git.savannah.gnu.org/cgit/emacs.git
	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is an external index of several public inboxes,
see mirroring instructions on how to clone and mirror
all data and code used by this external index.