From mboxrd@z Thu Jan  1 00:00:00 1970
From: "Eric Schulte" <schulte.eric@gmail.com>
Subject: Re: [Babel] Patch for adding Microsoft's osql command-line utility
Date: Sun, 05 Dec 2010 07:24:33 -0700
Message-ID: <87bp501en2.fsf@gmail.com>
References: <8039qe28bi.fsf@missioncriticalit.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from [140.186.70.92] (port=54379 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1PPFW5-0008M1-K4
	for emacs-orgmode@gnu.org; Sun, 05 Dec 2010 09:24:42 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <schulte.eric@gmail.com>) id 1PPFW4-0000e1-1P
	for emacs-orgmode@gnu.org; Sun, 05 Dec 2010 09:24:41 -0500
Received: from mail-iw0-f169.google.com ([209.85.214.169]:53092)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <schulte.eric@gmail.com>) id 1PPFW3-0000de-UP
	for emacs-orgmode@gnu.org; Sun, 05 Dec 2010 09:24:39 -0500
Received: by iwn33 with SMTP id 33so1937878iwn.0
	for <emacs-orgmode@gnu.org>; Sun, 05 Dec 2010 06:24:38 -0800 (PST)
In-Reply-To: <8039qe28bi.fsf@missioncriticalit.com> (=?utf-8?Q?=22S=C3=A9b?=
	=?utf-8?Q?astien?= Vauban"'s
	message of "Fri, 03 Dec 2010 16:18:57 +0100")
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: =?utf-8?Q?S=C3=A9bastien?= Vauban <wxhgmqzgwmuf@spammotel.com>
Cc: emacs-orgmode@gnu.org

Hi Seb,

Thanks for the patch, this has just been applied.

-- Eric

S=C3=A9bastien Vauban <wxhgmqzgwmuf@spammotel.com> writes:

> Hi Eric,
>
> Here a patch for osql from Microsoft.
>
> diff --git a/lisp/ob-sql.el b/lisp/ob-sql.el
> index 19c271d..9e6f06a 100644
> --- a/lisp/ob-sql.el
> +++ b/lisp/ob-sql.el
> @@ -66,6 +66,10 @@ This function is called by `org-babel-execute-src-bloc=
k'."
>           (out-file (or (cdr (assoc :out-file params))
>                         (org-babel-temp-file "sql-out-")))
>           (command (case (intern engine)
> +                    ('msosql (format "osql %s -s \"\t\" -i %s -o %s"
> +                                     (or cmdline "")
> +                                     (org-babel-process-file-name in-fil=
e)
> +                                     (org-babel-process-file-name out-fi=
le)))
>                      ('mysql (format "mysql %s -e \"source %s\" > %s"
>                                      (or cmdline "")
>  				    (org-babel-process-file-name in-file)
>
> Best regards,
>   Seb