Re: [babel] Verbatim output from SQL command

[Eric Schulte <schulte.eric@gmail.com>]

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/