From mboxrd@z Thu Jan 1 00:00:00 1970 From: Philip Rooke Subject: Re: Bug: [Babel] sqlite if: End of file during parsing Date: Wed, 15 Feb 2012 20:21:46 +0000 Message-ID: References: <874nust1tu.fsf@gmx.com> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([140.186.70.92]:40905) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1RxlMV-0001zQ-Dh for emacs-orgmode@gnu.org; Wed, 15 Feb 2012 15:22:04 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1RxlMO-0008JE-9W for emacs-orgmode@gnu.org; Wed, 15 Feb 2012 15:21:59 -0500 Received: from mail-wi0-f169.google.com ([209.85.212.169]:60219) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1RxlMO-0008J0-0a for emacs-orgmode@gnu.org; Wed, 15 Feb 2012 15:21:52 -0500 Received: by wibhj13 with SMTP id hj13so1046321wib.0 for ; Wed, 15 Feb 2012 12:21:50 -0800 (PST) In-Reply-To: <874nust1tu.fsf@gmx.com> (Eric Schulte's message of "Wed, 15 Feb 2012 10:59:25 -0700") 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-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Eric Schulte Cc: emacs-orgmode@gnu.org Eric Schulte writes: > Does the following work with the addition of ":results scalar"? Yes, there is no error although the format of the result is different to the one database line query or the equivalent shell command. This is what happens for me: #+begin_src sqlite :db ob-bug.db :results output scalar select f_name || " " || l_name from person; #+end_src #+results: : "Joe Bloggs" : "Fred Smith" Phil