From mboxrd@z Thu Jan 1 00:00:00 1970 From: Cecil Westerhof Subject: A strange problem with org-babel and SQLite Date: Fri, 31 Aug 2018 10:47:50 +0200 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="000000000000316ddc0574b73f4a" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:40306) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1fvf5t-0004Kn-QC for emacs-orgmode@gnu.org; Fri, 31 Aug 2018 04:47:55 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fvf5s-0003Mf-Tm for emacs-orgmode@gnu.org; Fri, 31 Aug 2018 04:47:53 -0400 Received: from mail-oi0-x22e.google.com ([2607:f8b0:4003:c06::22e]:33357) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1fvf5s-0003MF-NN for emacs-orgmode@gnu.org; Fri, 31 Aug 2018 04:47:52 -0400 Received: by mail-oi0-x22e.google.com with SMTP id 8-v6so20440677oip.0 for ; Fri, 31 Aug 2018 01:47:52 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: emacs-orgmode@gnu.org --000000000000316ddc0574b73f4a Content-Type: text/plain; charset="UTF-8" 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 --000000000000316ddc0574b73f4a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: base64 PGRpdiBkaXI9Imx0ciI+PGRpdiBkaXI9Imx0ciI+PGRpdiBjbGFzcz0iZ21haWxfZGVmYXVsdCIg c3R5bGU9ImZvbnQtZmFtaWx5OiBjb3VyaWVyXCBuZXcsIG1vbm9zcGFjZTsiPkkgaGF2ZSBhIHN0 cmFuZ2UgcHJvYmxlbSB3aXRoIG9yZy1iYWJlbCBhbmQgU1FMaXRlLiA8YnI+PGJyPkkgaGF2ZSBh IGRhdGFiYXNlIHRoYXQgaXMgY3JlYXRlZCB3aXRoOjxicj7CoMKgwqAgQ1JFQVRFIFRBQkxFICZx dW90O3F1b3RlcyZxdW90OyAoPGJyPsKgwqDCoMKgwqDCoMKgIHF1b3RlSUTCoMKgwqDCoMKgwqDC oMKgIFRFWFTCoMKgwqDCoMKgwqDCoMKgwqDCoCBQUklNQVJZIEtFWSw8YnI+wqDCoMKgwqDCoMKg wqAgcXVvdGXCoMKgwqDCoMKgwqDCoMKgwqDCoCBURVhUIE5PVCBOVUxMwqAgVU5JUVVFLDxicj7C oMKgwqDCoMKgwqDCoCBsYXN0VXNlZMKgwqDCoMKgwqDCoMKgIFRFWFQsPGJyPsKgwqDCoMKgwqDC oMKgIHRvdGFsVXNlZMKgwqDCoMKgwqDCoCBJTlTCoCBERUZBVUxUICYjMzk7dW51c2VkJiMzOTs8 YnI+wqDCoMKgICk8YnI+PGJyPldoZW4gdXNpbmc6PGJyPsKgwqDCoCAjK0JFR0lOX1NSQyBzcWxp dGUgOmRiIH4vVHdpdHRlci90d2l0dGVyLnNxbGl0ZSA6Y29sbmFtZXMgeWVzPGJyPsKgwqDCoCBT RUxFQ1TCoMKgIGxhc3RVc2VkPGJyPsKgwqDCoCAswqDCoMKgwqDCoMKgwqAgdG90YWxVc2VkPGJy PsKgwqDCoCBGUk9NwqDCoMKgwqAgcXVvdGVzPGJyPsKgwqDCoCBPUkRFUiBCWSBsYXN0dXNlZMKg IEFTQzxicj7CoMKgwqAgLMKgwqDCoMKgwqDCoMKgIHRvdGFsVXNlZCBERVNDPGJyPsKgwqDCoCBM SU1JVMKgwqDCoCA0MDxicj7CoMKgwqAgIytFTkRfU1JDPGJyPjxicj5FdmVyeXRoaW5nIGlzIGZp bmUuIEJ1dCB3aGVuIEkgdXNlIChhZGQgdGhlIHF1b3RlIGZpZWxkIGluIHRoZSBzZWxlY3QpOjxi cj7CoMKgwqAgIytCRUdJTl9TUkMgc3FsaXRlIDpkYiB+L1R3aXR0ZXIvdHdpdHRlci5zcWxpdGUg OmNvbG5hbWVzIHllczxicj7CoMKgwqAgU0VMRUNUwqDCoCBxdW90ZTxicj7CoMKgwqAgLMKgwqDC oMKgwqDCoMKgIGxhc3RVc2VkPGJyPsKgwqDCoCAswqDCoMKgwqDCoMKgwqAgdG90YWxVc2VkPGJy PsKgwqDCoCBGUk9NwqDCoMKgwqAgcXVvdGVzPGJyPsKgwqDCoCBPUkRFUiBCWSBsYXN0dXNlZMKg IEFTQzxicj7CoMKgwqAgLMKgwqDCoMKgwqDCoMKgIHRvdGFsVXNlZCBERVNDPGJyPsKgwqDCoCBM SU1JVMKgwqDCoCA0MDxicj7CoMKgwqAgIytFTkRfU1JDPGJyPjxicj5JIGdldDo8YnI+wqDCoMKg IGV4ZWN1dGluZyBTcWxpdGUgY29kZSBibG9jay4uLjxicj7CoMKgwqAgV3JvdGUgL3RtcC9iYWJl bC0yNzkyMHlfL29iLWlucHV0LTI3OTJCVEc8YnI+wqDCoMKgIG9yZy1iYWJlbC1yZWFkOiBFbmQg b2YgZmlsZSBkdXJpbmcgcGFyc2luZzxicj48YnI+V2hhdCBjb3VsZCBiZSB0aGUgcHJvYmxlbT88 YnI+PGJyIGNsZWFyPSJhbGwiPjwvZGl2Pi0tIDxicj48ZGl2IGNsYXNzPSJnbWFpbF9zaWduYXR1 cmUiPkNlY2lsIFdlc3RlcmhvZjwvZGl2Pg0KPC9kaXY+PC9kaXY+DQo= --000000000000316ddc0574b73f4a--