From: Eric Schulte <schulte.eric@gmail.com>
To: Sebastien Vauban <wxhgmqzgwmuf@spammotel.com>
Cc: emacs-orgmode@gnu.org
Subject: Re: [babel] Verbatim output from SQL command
Date: Tue, 18 Oct 2011 10:15:33 -0600 [thread overview]
Message-ID: <87k4822s4a.fsf@gmail.com> (raw)
In-Reply-To: <80mxcymo6a.fsf@somewhere.org> (Sebastien Vauban's message of "Tue, 18 Oct 2011 15:20:29 +0200")
Hi Seb,
I've just pushed up a fix which should resolve this issue.
Best -- Eric
"Sebastien Vauban" <wxhgmqzgwmuf@spammotel.com> writes:
> #+BABEL: :engine msosql :cmdline -S <SERVER> -U <USER> -P <PASS> -d <DATABASE> -n -w 700
>
> * Show code of stored procedure
>
> Despite telling Babel that I'd like to see the output as it is, it displays it
> in a 4-column table.
>
> See http://i.imgur.com/neDO3.png for the original layout in SQL Query Analyser
> (1 column, 34 lines).
>
> 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...
>
> ** Code
>
> This is an example of code run against a Microsoft SQL server.
>
> #+begin_src sql :eval yes :results output scalar
> EXEC sp_helptext 'dt_setpropertybyid'
> #+end_src
>
> #+results:
> | Text | | | |
> |-----------------------------------------+-------------------------------------------------------------------------+---------------------------------------------------------------------------------------------+--------------------------------------------|
> | /* | | | |
> | | | | |
> | ** | If the property already exists, reset the value; otherwise add property | | |
> | | | | |
> | ** | | id -- the id in sysobjects of the object | |
> | | | | |
> | ** | | property -- the name of the property | |
> | | | | |
> | ** | | value -- the text value of the property | |
> | | | | |
> | ** | | lvalue -- the binary value of the property (image) | |
> | | | | |
> | */ | | | |
> | | | | |
> | create procedure dbo.dt_setpropertybyid | | | |
> | | | | |
> | | @id int, | | |
> | | | | |
> | | @property varchar(64), | | |
> | | | | |
> | | @value varchar(255), | | |
> | | | | |
> | | @lvalue image | | |
> | | | | |
> | as | | | |
> | | | | |
> | | set nocount on | | |
> | | | | |
> | | declare @uvalue nvarchar(255) | | |
> | | | | |
> | | set @uvalue = convert(nvarchar(255), @value) | | |
> | | | | |
> | | if exists (select * from dbo.dtproperties | | |
> | | | | |
> | | | | where objectid=@id and property=@property) |
> | | | | |
> | | begin | | |
> | | | | |
> | | | -- | |
> | | | | |
> | | | -- bump the version count for this row as we update it | |
> | | | | |
> | | | -- | |
> | | | | |
> | | | update dbo.dtproperties set value=@value, uvalue=@uvalue, lvalue=@lvalue, version=version+1 | |
> | | | | |
> | | | | where objectid=@id and property=@property |
> | | | | |
> | | end | | |
> | | | | |
> | | else | | |
> ...
>
> Best regards,
> Seb
--
Eric Schulte
http://cs.unm.edu/~eschulte/
next prev parent reply other threads:[~2011-10-18 16:15 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 [this message]
2011-10-19 9:19 ` Sebastien Vauban
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=87k4822s4a.fsf@gmail.com \
--to=schulte.eric@gmail.com \
--cc=emacs-orgmode@gnu.org \
--cc=wxhgmqzgwmuf@spammotel.com \
/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).