emacs-orgmode
[Top][All Lists]
Advanced

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

[O] SQL result as a single string, rather than table?


From: Gary Oberbrunner
Subject: [O] SQL result as a single string, rather than table?
Date: Thu, 28 Mar 2013 10:18:35 -0400

I'd like to be able to put a result from SQL inline into my exported document.  Something like this:

Latest database record is from src_sql[:colnames no :results scalar]{select DATE(CreatedAt) from Event order by CreatedAt desc limit 1;}.

In that case, the SQL result almost works (it surrounds the results with =...=), but at least on my Windows machine there is an extra ^M and newline in there.  I'd be happy to submit a patch to strip whitespace from the end of the line in scalar mode, if people think that's a good idea.

In fact here's what I propose:

diff --git a/lisp/ob-sql.el b/lisp/ob-sql.el
index 658a54f..ac999f4 100644
--- a/lisp/ob-sql.el
+++ b/lisp/ob-sql.el
@@ -138,7 +138,8 @@ This function is called by `org-babel-execute-src-block'."
     (org-babel-eval command "")
     (org-babel-result-cond result-params
       (with-temp-buffer
-  (progn (insert-file-contents-literally out-file) (buffer-string)))
+  (progn (insert-file-contents-literally out-file)
+ (replace-regexp-in-string "[ \t\r\n]*$" "" (buffer-string))))
       (with-temp-buffer
  (cond
   ((or (eq (intern engine) 'mysql)

--
Gary

reply via email to

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