emacs-orgmode
[Top][All Lists]
Advanced

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

[O] A strange problem with org-babel and SQLite


From: Cecil Westerhof
Subject: [O] A strange problem with org-babel and SQLite
Date: Fri, 31 Aug 2018 10:47:50 +0200

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

reply via email to

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