From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?UTF-8?Q?Alain_Cl=C3=A9ment?= Subject: Babel sql code block issue and patch proposal Date: Thu, 3 Mar 2011 12:23:47 +0100 Message-ID: Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1941124286==" Return-path: Received: from [140.186.70.92] (port=40941 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1Pv6dk-0003tn-Hi for emacs-orgmode@gnu.org; Thu, 03 Mar 2011 06:24:21 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Pv6df-00023V-Iw for emacs-orgmode@gnu.org; Thu, 03 Mar 2011 06:24:16 -0500 Received: from mailc1.unil.ch ([130.223.27.61]:38386) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Pv6df-00022z-6t for emacs-orgmode@gnu.org; Thu, 03 Mar 2011 06:24:11 -0500 Received: from mail-wy0-f169.google.com ([74.125.82.169]) by mailc1.unil.ch stage1 with esmtpsa (Exim MailCleaner) id 1Pv6db-0001sg-P2 for from ; Thu, 03 Mar 2011 12:24:07 +0100 Received: by wyi11 with SMTP id 11so1092880wyi.0 for ; Thu, 03 Mar 2011 03:24:07 -0800 (PST) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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: emacs-orgmode@gnu.org --===============1941124286== Content-Type: multipart/alternative; boundary=0016e64c0b8c838479049d9244e5 --0016e64c0b8c838479049d9244e5 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi everyone, The =3Dorg-babel-temp-file=3D string seems to be escaped with backslashes o= n some platforms (like MacOSX), which is not very appreciated by the =3Dmysql -e=3D command. I suggest the following patch for =3Dob-sql.el=3D (Org-mode = Version 7.4 (release_7.4.590.g85d4d)): 74c74 < ('mysql (format "mysql %s < %s > %s" --- > ('mysql (format "mysql %s -e \"source %s\" > %s" Best regards, -- Alain --=20 Alain Cl=C3=A9ment Dr =C3=A8s sc. math=C3=A9matiques Universit=C3=A9 de Lausanne Quartier UNIL-Centre B=C3=A2timent Unicentre Bureau 339 CH-1015 Lausanne T. +41 21 692 20 36 (direct) T. +41 21 692 20 60 (secr=C3=A9tariat) alain.clement@unil.ch --0016e64c0b8c838479049d9244e5 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi everyone,

The =3Dorg-babel-temp-file=3D string seems = to be escaped with backslashes on some platforms (like MacOSX), which is no= t very appreciated by the =3Dmysql -e=3D command. I suggest the following p= atch for =3Dob-sql.el=3D (Org-mode Version 7.4 (release_7.4.590.g85d4d)):

74c74
< =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ('mysql (format "mysql %= s < %s > %s"
---
> =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ('mysql (format "= mysql %s -e \"source %s\" > %s"

Best regards,
-- Alain

--
<= br>


Alain Cl=C3=A9ment
Dr =C3=A8s sc. math=C3=A9matiques

Universit=C3=A9 de Lausanne
Qua= rtier UNIL-Centre
B=C3=A2timent Unicentre
Bureau 339
CH-1015 Lausa= nne

T. +41 21 692 20 36 (direct)
T. +41 21 692 20 60 (secr=C3=A9t= ariat)

al= ain.clement@unil.ch
--0016e64c0b8c838479049d9244e5-- --===============1941124286== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline -- Emacs-orgmode mailing list Please use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode --===============1941124286==--