From: "Sebastien Vauban" <wxhgmqzgwmuf-geNee64TY+gS+FvcfC7Uqw@public.gmane.org>
To: emacs-orgmode-mXXj517/zsQ@public.gmane.org
Subject: [babel] Verbatim output from SQL command
Date: Tue, 18 Oct 2011 15:20:29 +0200 [thread overview]
Message-ID: <80mxcymo6a.fsf@somewhere.org> (raw)
#+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
--
Sebastien Vauban
next reply other threads:[~2011-10-18 13:20 UTC|newest]
Thread overview: 68+ messages / expand[flat|nested] mbox.gz Atom feed top
2011-10-18 13:20 Sebastien Vauban [this message]
2011-10-18 16:15 ` [babel] Verbatim output from SQL command Eric Schulte
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=80mxcymo6a.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).