emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* A strange problem with org-babel and SQLite
@ 2018-08-31  8:47 Cecil Westerhof
  2018-08-31  9:17 ` Robert Klein
  0 siblings, 1 reply; 13+ messages in thread
From: Cecil Westerhof @ 2018-08-31  8:47 UTC (permalink / raw)
  To: emacs-orgmode

[-- Attachment #1: Type: text/plain, Size: 1024 bytes --]

I have a strange problem with org-babel and SQLite.

I have a database that is created with:
    CREATE TABLE "quotes" (
        quoteID         TEXT           PRIMARY KEY,
        quote           TEXT NOT NULL  UNIQUE,
        lastUsed        TEXT,
        totalUsed       INT  DEFAULT 'unused'
    )

When using:
    #+BEGIN_SRC sqlite :db ~/Twitter/twitter.sqlite :colnames yes
    SELECT   lastUsed
    ,        totalUsed
    FROM     quotes
    ORDER BY lastused  ASC
    ,        totalUsed DESC
    LIMIT    40
    #+END_SRC

Everything is fine. But when I use (add the quote field in the select):
    #+BEGIN_SRC sqlite :db ~/Twitter/twitter.sqlite :colnames yes
    SELECT   quote
    ,        lastUsed
    ,        totalUsed
    FROM     quotes
    ORDER BY lastused  ASC
    ,        totalUsed DESC
    LIMIT    40
    #+END_SRC

I get:
    executing Sqlite code block...
    Wrote /tmp/babel-27920y_/ob-input-2792BTG
    org-babel-read: End of file during parsing

What could be the problem?

-- 
Cecil Westerhof

[-- Attachment #2: Type: text/html, Size: 1523 bytes --]

^ permalink raw reply	[flat|nested] 13+ messages in thread

end of thread, other threads:[~2018-09-10  7:11 UTC | newest]

Thread overview: 13+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2018-08-31  8:47 A strange problem with org-babel and SQLite Cecil Westerhof
2018-08-31  9:17 ` Robert Klein
2018-08-31 10:24   ` Cecil Westerhof
2018-08-31 11:22     ` Robert Klein
2018-09-01  9:12       ` Cecil Westerhof
2018-09-01 12:24         ` Robert Klein
2018-09-02 13:22           ` Cecil Westerhof
2018-09-03  0:19             ` Cecil Westerhof
2018-09-03  1:09           ` Cecil Westerhof
2018-09-03  1:23             ` Cecil Westerhof
2018-09-05  6:56               ` Robert Klein
2018-09-09 12:36                 ` Robert Klein
2018-09-10  7:05                   ` Cecil Westerhof

Code repositories for project(s) associated with this public inbox

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

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).