emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: "Sebastien Vauban" <wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@public.gmane.org>
To: emacs-orgmode-mXXj517/zsQ@public.gmane.org
Subject: Re: [babel] Verbatim output from SQL command
Date: Wed, 19 Oct 2011 11:19:55 +0200	[thread overview]
Message-ID: <808vohbao4.fsf@somewhere.org> (raw)
In-Reply-To: 87k4822s4a.fsf@gmail.com

Hi Eric,

Eric Schulte wrote:
>> Babel seems to interpret every *leading space* as *one empty column*.
>> Normal, feature, bug?
>>
>> Is there some workaround to this? I thought stating "scalar" would really
>> completely override any interpretation...
>
> I've just pushed up a fix which should resolve this issue.

It does better things, but at least at the wrong place.

--8<---------------cut here---------------start------------->8---
    #+BABEL:   :engine msosql :cmdline -S <SERVER> -U <USER> -P <PASS> -d <DATABASE> -n -w 700 :results output

    #+begin_src sql :eval yes :results scalar
    EXEC sp_helptext 'reset_me'
    #+end_src
--8<---------------cut here---------------end--------------->8---

becomes, after evaluation (indented for the sake of clarity):

--8<---------------cut here---------------start------------->8---
    #+BABEL:   :engine msosql :cmdline -S <SERVER> -U <USER> -P <PASS> -d <DATABASE> -n -w 700 :results output

    Text                                                                                                                                                                                                                                                           
    ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    CREATE PROCEDURE reset_me
            @pfi varchar(16)
    AS
    BEGIN
            PRINT 'Done!'
    END
                                    
    
    #+begin_src sql :eval yes :results scalar
    EXEC sp_helptext 'reset_me'
    #+end_src

    #+results:
    #+begin_example
    #+BABEL:   :engine msosql :cmdline -S <SERVER> -U <USER> -P <PASS> -d <DATABASE> -n -w 700 :results output

    Text                                                                                                                                                                                                                                                           
    ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    CREATE PROCEDURE reset_me
            @pfi varchar(16)
    AS
    BEGIN
            PRINT 'Done!'
    END
                                    
    
    #+begin_src sql :eval yes :results scalar
    EXEC sp_helptext 'reset_me'
    #+end_src

    #+end_example

--8<---------------cut here---------------end--------------->8---

In short, it seems that:

- results is inserted at point's position (in the above case, I was using the
  eval speed command `e', thus being at #).

- the results is duplicated, with some part of the source buffer being
  repeated as well... See the presence of 2 `#+BABEL:' lines in the buffer,
  after the evaluation.

- depending on the point from which I run the code evaluation, there is (or
  there isn't) an `#+begin_example' directive. The `#+end_example' is always
  present.

Best regards,
  Seb

-- 
Sebastien Vauban

  reply	other threads:[~2011-10-19  9:19 UTC|newest]

Thread overview: 68+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2011-10-18 13:20 [babel] Verbatim output from SQL command Sebastien Vauban
2011-10-18 16:15 ` Eric Schulte
2011-10-19  9:19   ` Sebastien Vauban [this message]
2011-10-19 18:08     ` Eric Schulte
2011-10-20  8:03       ` Sebastien Vauban
2011-10-19 16:29 ` Viktor Rosenfeld
  -- strict thread matches above, loose matches on Subject: below --
2012-07-07 18:58 Functions in SBE blocks Viktor Rosenfeld
2011-12-12 23:39 Refresh of http://orgmode.org Bastien
2011-12-13 17:25 ` Achim Gratz
2011-12-13 19:27   ` Bastien
2011-12-13 19:32     ` Nick Dokos
2011-12-13 20:27     ` Achim Gratz
2011-12-20 23:23       ` Bastien
2011-12-13 17:39 ` Samuel Wales
2011-12-13 18:39   ` Eric S Fraga
2011-12-13 18:59     ` Samuel Wales
2011-12-13 19:35     ` Bastien
2011-12-13 19:51       ` Samuel Wales
2011-12-14  8:49       ` Eric S Fraga
2011-12-13 19:33   ` Bastien
2011-12-13 21:50 ` Viktor Rosenfeld
2011-12-13 22:22   ` Bastien
2011-12-14  8:53     ` Eric S Fraga
2011-12-14 12:54     ` Viktor Rosenfeld
2011-12-14 17:40       ` Bastien
2011-12-14 18:15       ` Bastien
2011-12-14 22:10         ` Viktor Rosenfeld
2011-12-14 22:17           ` Eric Schulte
2011-12-14  1:19   ` Eric Schulte
2011-12-14 10:07     ` Bastien
2011-12-14 18:45       ` Eric Schulte
2011-12-15  4:11         ` Eric Schulte
2011-12-15 14:03           ` Bastien
2011-12-15 15:10             ` Eric Schulte
2011-12-15 15:18               ` Bastien
2011-12-15 15:26                 ` Eric Schulte
2011-12-15 15:44                   ` Bastien
2011-12-15 14:10         ` Bastien
2011-12-14 13:17   ` Stefan Vollmar
2011-12-14  2:30 ` Scott Randby
2011-12-15 13:10 ` Martyn Jago
2011-11-16 15:27 Question regarding remote references in tables Viktor Rosenfeld
2011-10-19 16:21 Export an org file from the command line in the background Viktor Rosenfeld
2011-10-19 16:27 ` Jambunathan K
2011-10-19 20:14   ` Viktor Rosenfeld
2011-09-22  7:36 [Bug] local variables definition at beginning of file is ignored Viktor Rosenfeld
2011-09-22  9:48 ` Viktor Rosenfeld
     [not found] ` <listuser36@googlemail.com>
2011-09-22 14:43   ` Nick Dokos
2011-09-22 14:58     ` Nick Dokos
2011-10-19 16:47   ` [babel] Verbatim output from SQL command Nick Dokos
2011-10-19 17:31     ` Viktor Rosenfeld
2011-10-19 17:34     ` Sebastien Vauban
2011-10-19 21:12   ` Export an org file from the command line in the background Nick Dokos
2011-10-19 22:28     ` Viktor Rosenfeld
2011-10-19 21:22   ` Code block evaluation export bug ? (was: Re: Export an org file from the command line in the background) Nick Dokos
2011-10-21  1:57     ` Code block evaluation export bug ? Thomas S. Dye
2011-10-21  2:42       ` Nick Dokos
2011-10-21  4:37         ` Nick Dokos
2011-10-22 23:51       ` Nick Dokos
2011-11-09 21:13         ` Eric Schulte
2011-11-09 21:55           ` Nick Dokos
2011-10-19 22:37   ` Export an org file from the command line in the background Nick Dokos
2011-11-16 15:52   ` Question regarding remote references in tables Nick Dokos
2011-11-16 16:40     ` Nick Dokos
2011-11-16 17:43     ` Viktor Rosenfeld
2011-12-13 22:16   ` Refresh of http://orgmode.org Nick Dokos
2012-07-07 20:02   ` Functions in SBE blocks Nick Dokos
2012-07-08  0:55     ` Viktor Rosenfeld

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=808vohbao4.fsf@somewhere.org \
    --to=wxhgmqzgwmuf-genee64ty+gs+fvcfc7uqw@public.gmane.org \
    --cc=emacs-orgmode-mXXj517/zsQ@public.gmane.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
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).