From mboxrd@z Thu Jan 1 00:00:00 1970 From: =?utf-8?Q?S=C3=A9bastien_Vauban?= Subject: Re: [Babel] Tangling ignores LOB file? Date: Mon, 20 Dec 2010 16:31:28 +0100 Message-ID: <80tyi8a2b3.fsf@missioncriticalit.com> References: <80zkshfz0x.fsf@missioncriticalit.com> <87lj3rkl0r.fsf@gmail.com> <80aak0h6r0.fsf@missioncriticalit.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Return-path: 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-mXXj517/zsQ@public.gmane.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org-mXXj517/zsQ@public.gmane.org To: emacs-orgmode-mXXj517/zsQ@public.gmane.org Hi Eric, > "Eric Schulte" wrote: >>> In other words, it seems that the tangle process does not take into >>> account the code blocks located in the LOB. >> >> I just pushed up a fix which should allow noweb references to be resolved >> using the library of babel. > > TESTED as FIXED. Case is CLOSED. > > Thanks a lot. Though, I just discovered a little problem not related to tangling, but well to the LOB: #+TITLE: nil when code block is moved to my LOB #+DATE: 2010-12-20 #+LANGUAGE: en_US #+BABEL: :engine msosql :cmdline -S server -U user -P password -d datab= ase -n -w 700 :results output :exports both :noweb yes * Abstract When the code block is local to the file, the =3Dcall=3D is returning expec= ted results, when =3DC-c C-v C-e=3D. When moved to the LOB (and the LOB ingested), the same =3Dcall=3D returns = =3Dnil=3D. * Example ** Local source code block The code block is in the same file as the one where the =3Dcall=3D is locat= ed. #+srcname: show-count-per-tinyint-value #+begin_src sql :var table=3D"sometable" :var column=3D"somecolumn" SELECT $column, COUNT(ISNULL($column, 255)) AS 'Count' FROM $table GROUP BY $column ORDER BY $column #+end_src #+call: show-count-per-tinyint-value(table=3D"mytable", column=3D"mycolumn") #+results: show-count-per-tinyint-value(table=3D"mytable", column=3D"mycolu= mn") | mycolumn | Count | | ------------ | ----------- | | NULL | 8062 | | 0 | 5759 | | 1 | 49174 | | 2 | 1994 | | 3 | 9651 | | 4 | 27 | | 5 | 2262 | | 6 | 21 | | | | | (8 lignes affect=EF=BC=A6s) | | ** Now, with the source code in the LOB After having moved the code block to the LOB (and ingested it), the executi= on does not return the expected results anymore: #+call: show-count-per-tinyint-value(table=3D"mytable", column=3D"mycolumn") #+results: show-count-per-tinyint-value(table=3D"mytable", column=3D"mycolu= mn") : nil * Extra Would it be possible to have: - the previewing enabled, and - speed commands on the =3Dcall=3D lines? Best regards, Seb --=20 S=C3=A9bastien Vauban _______________________________________________ Emacs-orgmode mailing list Please use `Reply All' to send replies to the list. Emacs-orgmode-mXXj517/zsQ@public.gmane.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode