* Help with babel results
@ 2013-03-10 1:32 Michael Gauland
2013-03-10 21:37 ` Eric Schulte
0 siblings, 1 reply; 4+ messages in thread
From: Michael Gauland @ 2013-03-10 1:32 UTC (permalink / raw)
To: emacs-orgmode Org-Mode
[-- Attachment #1: Type: text/plain, Size: 851 bytes --]
I'm working with an sqlite database of songs, and I've run into trouble
with titles that start with a '(' (for example,
(I Can't Get No) Satisfaction). 'Verbatim' results work:
#+BEGIN_SRC sqlite :db test-db :results verbatim
.mode csv
.separator |
drop table playlist;
create table playlist (title varchar, artist varchar);
insert into playlist values("(I Can't Get No) Satisfaction",
"Rolling Stones");
select * from playlist;
#+END_SRC
#+RESULTS:
: "(I Can't Get No) Satisfaction"|"Rolling Stones"
But :results table' reports:
eval: Symbol's function definition is void: I
It looks to me like org is trying to interpret (I Can't Get No) as emacs
lisp, but I haven't been able to figure out how to prevent that.
Advice would be greatly appreciated.
Kind Regards,
Mike
[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 901 bytes --]
^ permalink raw reply [flat|nested] 4+ messages in thread* Re: Help with babel results
2013-03-10 1:32 Help with babel results Michael Gauland
@ 2013-03-10 21:37 ` Eric Schulte
2013-03-10 23:48 ` Eric Schulte
0 siblings, 1 reply; 4+ messages in thread
From: Eric Schulte @ 2013-03-10 21:37 UTC (permalink / raw)
To: Michael Gauland; +Cc: emacs-orgmode Org-Mode
[-- Attachment #1: Type: text/plain, Size: 1223 bytes --]
Michael Gauland <mikelygee@no8wireless.co.nz> writes:
> I'm working with an sqlite database of songs, and I've run into trouble
> with titles that start with a '(' (for example,
> (I Can't Get No) Satisfaction). 'Verbatim' results work:
>
> #+BEGIN_SRC sqlite :db test-db :results verbatim
> .mode csv
> .separator |
> drop table playlist;
> create table playlist (title varchar, artist varchar);
> insert into playlist values("(I Can't Get No) Satisfaction",
> "Rolling Stones");
> select * from playlist;
> #+END_SRC
>
> #+RESULTS:
> : "(I Can't Get No) Satisfaction"|"Rolling Stones"
>
> But :results table' reports:
>
> eval: Symbol's function definition is void: I
>
> It looks to me like org is trying to interpret (I Can't Get No) as emacs
> lisp, but I haven't been able to figure out how to prevent that.
>
> Advice would be greatly appreciated.
>
> Kind Regards,
> Mike
>
Hi Mike,
Thanks for reporting this problem. Your diagnosis is correct, the table
contents were being interpreted as lisp. I've fixed this issue with the
attached patch. I'm unable to ping orgmode.org right now, so I can't
commit this fix, but I will commit it as soon as I'm able.
Thanks,
[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #2: 0001-don-t-read-sqlite-output-as-lisp.patch --]
[-- Type: text/x-patch, Size: 949 bytes --]
From 2196096cdecde82c9af8695422ae3f6c5fa42ff1 Mon Sep 17 00:00:00 2001
From: Eric Schulte <schulte.eric@gmail.com>
Date: Sun, 10 Mar 2013 15:34:56 -0600
Subject: [PATCH] don't read sqlite output as lisp
Thanks to Michael Gauland for pointing out this bug.
* lisp/ob-sqlite.el (org-babel-sqlite-table-or-scalar): Don't read
sqlite output as lisp.
---
lisp/ob-sqlite.el | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/lisp/ob-sqlite.el b/lisp/ob-sqlite.el
index 30bfc73..84d4688 100644
--- a/lisp/ob-sqlite.el
+++ b/lisp/ob-sqlite.el
@@ -143,7 +143,7 @@ This function is called by `org-babel-execute-src-block'."
(mapcar (lambda (row)
(if (equal 'hline row)
'hline
- (mapcar #'org-babel-read row))) result)))
+ (mapcar #'org-babel-string-read row))) result)))
(defun org-babel-sqlite-offset-colnames (table headers-p)
"If HEADERS-P is non-nil then offset the first row as column names."
--
1.8.1.5
[-- Attachment #3: Type: text/plain, Size: 46 bytes --]
--
Eric Schulte
http://cs.unm.edu/~eschulte
^ permalink raw reply related [flat|nested] 4+ messages in thread
end of thread, other threads:[~2013-03-11 17:44 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2013-03-10 1:32 Help with babel results Michael Gauland
2013-03-10 21:37 ` Eric Schulte
2013-03-10 23:48 ` Eric Schulte
2013-03-11 17:43 ` Michael Gauland
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).