emacs-orgmode
[Top][All Lists]
Advanced

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

[Orgmode] ob-sql error because of not specifying column-seperator


From: Joost Helberg
Subject: [Orgmode] ob-sql error because of not specifying column-seperator
Date: Fri, 03 Dec 2010 14:01:55 +0100 (CET)

Hi,

when using babel SQL, the column's in the resultset are converted to
org-tables using (org-table-import file sep).

The command used to retrieve the information from the databaseserver
gets the option to use the tab (\t) as columnseperator. 

The call to org-table-import however doesn't specify this
seperator. This leaves it to org-table-import to find out what the
seperator is. org-table-import doesn't always succeed in this. Hence
the diff below which sets the seperator to <tab> (\t).

regards,

Joost Helberg

diff --git a/lisp/ob-sql.el b/lisp/ob-sql.el
index 19c271d..6bb9a96 100644
--- a/lisp/ob-sql.el
+++ b/lisp/ob-sql.el
@@ -80,7 +80,7 @@ This function is called by `org-babel-execute-src-block'."
     (message command)
     (shell-command command)
     (with-temp-buffer
-      (org-table-import out-file nil)
+      (org-table-import out-file '(16))
       (org-babel-reassemble-table
        (org-table-to-lisp)
        (org-babel-pick-name (cdr (assoc :colname-names params))

-- 
Snow B.V.        http://snow.nl



reply via email to

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